Items that you purchase or produce for the purpose of selling to customers are maintained in the Inventory module. There are many different types of items you can create, with different information available to track based on the selected type.
When the Inventory module is opened, the list of items is presented in a grid with the column layout remembered from the previous use.
There are buttons particular to the use of Inventory in the toolbar. Except when specified, toolbar button function are applied to all highlighted items in the grid.
Copy – When you copy a single highlighted item, a screen is opened to allow selection of what to copy to the new item, including the warehouse code. A unique part number must be entered for the new item, and when you continue from this screen, the new item will be editable for additional changes before saving it.
- Selling Price List
- Extended Description
- Units of Measure
- Place on Hold
Labels – Print item labels for use such as bin/shelf location identification or affixing to each individual item.
- Set quantity to one label for each litem, such as for a bin/shelf
- Set quantity to equal on-hand for each item (default), such as for individual labelling
- The quantity on each item can be modified from either 1 or on-hand quantity to print as many labels as you want
- Set a blank label count to skip printing at the beginning of the sheet, such as if some of the labels on the sheet were already used
- Once all selections are made they can print the labels required
Adjust – Create and post quantity and cost changes to either increase or decrease values. Selected items are loaded into an Inventory Adjustment list that can be edited and added to, prior to posting. Cost changes are accounted for in an Adjustment account that can be updated for any item. Read the Inventory Adjustments manual topic for more information.
Count – Perform a stock count to verify actual quantity on hand with the value stored in the data. Differences in the count are posted similar to adjustments. Read the Inventory Count manual topic for more information.
Transfer – Move inventory items from one warehouse to another, if multiple warehouses are configured. Update costs or prices for stock in the destination warehouse. Read the Inventory Transfer manual topic for more information.
Purchase – Create a new Purchase Order transaction, if security allows. Read the Purchase Order manual topics for more information.
Sell – Create a new Sales Order transaction, if security allows. Read the Sales Order manual topics for more information.
Requisition – Create an authorization request to purchase items, that you could process yourself into a PO or add to a list for someone else to verify and process. The ‘Suggested Order Qty’ – only visible as a column from this grid – is useful to assist in deciding which items should be purchased. Read the Requisitions manual topic for more information.
Refresh – Refreshes the list with any changes made by another user when editing an item or posting a transaction.
Filters – Display a list of items that meet selection criteria you create. Read the Filters manual topic for more information.
Export – Exports the current list and layout to a new Excel or .csv file.
Add – Create a new inventory item
Edit – Modify an existing inventory item,
Delete – Delete an existing inventory item. There cannot be any on-hand, back ordered, committed, or on-order quantities or historical linked records to this item, to be able to delete.
Print – Prints inventory reports, either or all or selected items in the grid.
Reports
From the Inventory list, there are many different reports you can print for selected or all items, where some are particular to the type of items selected.
Components Usage – Prints a list of selected item and any Kits, Production Templates and Production Orders each item belongs to. If an item does not belong to any of these, it will be excluded from the report.
Inventory Re-Order – Prints a list of selected items that also have a non-zero suggested order quantity, grouped by primary vendor. Quantity on Hand and other allocated quantities are also printed for each item, with the current unit cost and the calculated cost to purchase the suggested quantity. Any Vendor prices configured for items are also printed. If an item has a zero suggested order quantity, it will be excluded from the report.
Inventory Statistics – Prints a list of selected items with sales quantity and amount totals for each of the pervious 24 months up to this month. Comparisons for each month in both years are also printed to see if sales increased or decreased from the prior year.
Inventory Status – Prints a list of selected items, grouped by product code, with quantity on hand and cost information.
Inventory UPC List – Prints a list of selected items and any UPC code values for each item. If multiple UPC codes exist for an item, either with the same or different unit of measure, they are listed separately.
Item Allocations – Prints a list of selected items and quantity on hand and allocated information, any sales or production or purchase orders they exist on.
Manufactured Item Calculated Cost – Prints a list of selected manufactured items and their respective calculated costs from the components on the Bill of Materials tab of each item. The Bill of Materials Extended Cost prints as the Extended Average on this report, and the Extended Current and Standard costs are calculated from component usage and respective costs.
Manufactured Item Calculated Cost – Detailed – Prints a list of selected manufactured items and their respective components on the Bill of Materials tab of each item. The unit Average, Current and Standard costs for each component and their calculated extended costs by usage are printed, along with total costs for the manufactured item.
Movement
This tab lists all transactions posted for all inventory items, complete within one grid. You can also see credited sales orders and purchase order returns.
This allows you to print an inventory movement report for one or more items, that displays all transactions in chronological sequence, either by the transaction date or the posting date, to see the running balance of the quantity on hand. This is especially useful when the transaction list is filtered to a desired selection of records.
Sell Prices
This tab lists all defined price levels for all inventory items, complete within one grid.
This screen is useful to create a filtered list of price levels across a group or all inventory items, for the purpose of exporting to a spreadsheet and re-importing price changes.
This allows you to print an Inventory Sell Price List report for one or more items, based on selected price level records. This could list the price history of particular items, or see all prices that will change on a chosen effective date. A Notes area to the right is available to hand-write information on a printed copy.
Video Instruction