OnTarget Point of Sale Inventory Control

The OnTarget Inventory Control module is designed to help small to mid-sized retailers and wholesalers manage their most important asset, their inventory. There are many functions and features necessary to manage your stock.

Maintain Items : This function is where you maintain the inventory database. This function is the foundation of the Inventory control system. It is where you add, maintain and remove the information about items you stock. There are several sub-functions:

Maintain Inventory Description Data allows you to enter Product Codes, Descriptions, and other data, as well as assign it to a location (Warehouse), and Stock Classes 1 & 2. (Stock Class 2 being a sub-category of Stock Class 1). As you can see, you also indicate whether this product is allowed on the eCommerce website, if you have elected to purchase that option. If so, you can enter the Web image and additional Web description about the product here.

Maintain Inventory Pricing Data This function allows you to indicate to the system the Base Wholesale and Retail prices, Set "Sale" prices and start and end dates of the sale. You also indicate whether the item is subject to sales tax or not, and indicate the type of discount pricing to be used, if any, and what those discount prices should be. Retailers would normally only be concerned with the Retail List price. Wholesalers usually have a significantly more complex pricing scheme.

Maintain Inventory Costing Data This function allows you to enter and update the Type of costing you are using (weighted (A)verage, (F)ifo, or (L)ifo, the cost used for calculating Inventory Value, printing the Sales report, and Posting to the General ledger, if you have that system), and also allows you to enter a Beginning cost for historical comparison, a Vendor cost to show the price you normally pay your vendor when no special discounts are allowed (the default used when creating Purchase Orders), and the Standard cost (used for Salesman commission reports, and other reports that you want to exclude special pricing that you obtain on the item from time to time). You also enter information about your primary and alternate vendors for this part here.

Inventory Sales Analysis Displays sales information for this product for the current and previous calendar years.

Inventory Mass Maintenance Unlike the other sub-modules that only change data for a single item at a time, this function gives you a grid display and allows you to select and change a single piece of data for many items at once.

Maintain Inventory Stocking Data Allows you to review and update stocking information about the item such as the warehouse or location that it is stored and sold from, the location of the item in that warehouse (which Aisle, Row Shelf, etc.), and also has a place for overflow inventory location, the number in stock, allocated to customer orders, ordered from vendors, the quantity sold and dollar sales and cost period to data and year to date, the G/L account numbers to use for sales inventory and cost of goods sold, and a flag to indicate whether the quantity in stock should be reduced when one or more are sold. This feature is useful if you are a wholesaler or distributor that also does service work and invoices for things like a service call, or installation time, that are not stocking items.

Memo Field This function allows you to enter and maintain freehand notes about any special information related to this item. Checking the "Display in Order Entry and PO's" checkbox will cause the program to display any special instructions entered here whenever the part is entered on a sales order or Purchase order.

View Inventory Drilldown Information is a function that displays information on this item with respect to open Purchase Orders, Sales Orders and un-posted Sales Invoices.

Inventory Sub Assembly Maintenance is a function that allows you to define and maintain the items in your inventory that are sub-assembly Parts of this product. This Sub-Assembly, or "Kit Building" function is extremely useful if you combine different items of inventory into a kit and sell the kit as a separate product. Once defined here the "Create Kits" function automatically reduces the stocking levels of all the parts that make up the kit and increases the stocking level of the kit itself based on the number of "kits" you create.

Update Physical Inventory This function is a quick and easy way to update the database to the quantities actually counted when you take physical inventory. You first print out the "Physical Inventory List" report. The personnel counting then write the counts on the inventory sheets. When counts are entered into the program later, the items pop up in the same order as the printed inventory sheets.

Close # Sold PTD/YTD This is a function that periodically resets the inventory number sold counters to 0. If you choose the YTD option it also resets the number sold YTD counter.

Maintain Units of Measure This function allows you to define and maintain the Units of Measure table that is displayed in the "Maintain Inventory Description" function.

Create Edit Purchase Orders This function allows you to create, edit and issue purchase orders that are sent to your Vendor to order new stock. If you have a fax modem in your system you can fax the PO directly to the Vendor from this function. You can also print out hard copy for your files.

Receive Purchase Orders This function allows you to automatically update inventory stocking levels and Inventory costs for the items ordered on the P.O. when the stock arrives from the vendor. If the vendor fills your order in multiple shipments you can do partial receipts until all items have been received. It keeps track of the items received on previous shipments, and will let you over-receive if the vendor ships more than you initially ordered. A receiving report showing the items you received, and a report showing open customer orders that are waiting for the item received to arrive to be invoiced and shipped is automatically printed.

Maintain Cross Reference Table This function allows you to cross reference items to each other allowing you to look up the Substitute or Accessory part in the Order Entry function.

Maintain Warehouse Master File This function allows you to maintain the information that the system needs for your various locations.

Lookup Customers by Product Code This function allows you to look up all customers that have ever bought a particular product form you. It displays their name and address as well as the invoice number and date of purchase. It is very useful if you are "closing out" an item and want to send out a flyer to customers that have bought it before. It is even more important if there is a recall on the product and you need to contact them. In either case it will print mailing labels for you.

Inter-Warehouse Transfers This function allows you to transfer stock from one warehouse or location to another. It automatically updates the "in stock" and costing levels in both places, and prints out an audit trail report.

Create Kits This function will print a listing telling you how many different items you will need to pull from stock to create the number of kits you request. Once you have created them you then click the create kits button and it automatically reduces the sub assembly items by the number used and then calculates the current cost per kit item based on the current cost of the sub-assembly items used and increases the Kit items by the number of kits created and updates the cost accordingly.

Inventory Class Maintenance This function allows you to create and maintain Classes and sub-classes that you assign items to in order to categorize them for reporting and e-Commerce Website purposes.

Inventory Reports Inventory reports available include : Valuation and Review Price List Profit Margin Recommended Ordering Physical Inventory List Purchase Orders Report Purchase Orders Report By Vendor Purchase Orders Report By Single Vendor Print Barcode Labels Inventory Sales Report