List
Products
The Inventory Management Module allows to create any type of product list you need to manage your inventory. You can program the list format with the "Products List Setup " option.
Report
Select the format of the list you want.
Supplier Code
Select the supplier code from the list displayed. If you want all the suppliers check "All".
Product Code
This is an eight letters mask. The system uses this mask to select the item to be printed. For example you can enter "AR" to get all the items beginning by "AR" (this function is case insensitive). If you want all the items check the "All".
Inventory Category
If you select all the items you can specify the inventory category you want to report
Inventory Group
If you select all the categories, you can specify an inventory group
Location
If you have the multi-location option you can select for which location you want this report.
Site
Type in the site description you want or check the "All" option for all sites.
Sort Order
Select the field you want the information to be sorted on. There are six different sorts available: The Description The Category The Group The Supplier
The Product code
The Site
Products List Setup
This function permits creation or modification of the report format being used with the "Products List" report. You can create as many reports as you need.
Select this option to Modify a report.
Select this option to Add a new report.
Select this option to Remove a report.
Code
This is the code for this report format.
Description
This is the complete description for this report format. This field will be printed as a title on the reports.
Column 1 to 10
For each format report you can select up to 10 columns. There are 25 options available to fill a column. When an option as been enabled it will removed from the list of available options, this will prevent to insert two time the same information in a report.
Options List:
Adjustment
Date of adjustment.
Average Cost
The average cost.
Buying Format
The unit of measure used for the buying format.
Code
The code of the inventory item.
Cost
The actual buying cost.
Description
The complete item description.
Inventory Format
The unit used for the inventory format.
Inventory Format Quantity
The quantity of the buying format constituting an inventory format.
Inventory Category
The category this inventory item belongs to.
Inventory Group
The group this inventory item belongs to.
Last Cost
The buying cost before the last increase.
Last Increase
Day of increase.
Last Supplier
The supplier before the actual supplier.
Maximum
This option will print the maximum stock quantity requested.
Minimum
This option will print the minimum stock quantity requested.
Monthly turnover
This is the number of months it will take to sell the inventory.
Periodic Turnover
This is the number of period it will take to sell the inventory.
Quantity on Hand
Quantity in stock.
Site
The site in the requested location.
Supplier
The actual supplier.
Unit Cost
The buying cost for a buying format.
Usage
This is the average amount of product being used.
Usage Format
The unit used for the usage format.
Usage Format Quantity
The quantity of the inventory format constituting an usage format.
Weekly Turnover
This is the number of weeks it will take to sell the inventory.
Not Defined
Any unused.