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
This option allows to get a history report of requisition to and from any locations during a specified period. Before the system can generate it you will have to complete the following information:
Product Code
Select the inventory item code.
Inventory Category
If you have selected all the items at the previous field you have the possibility to specify a inventory category.
Inventory Group
If you have selected all the categories at the previous field you have the possibility to specify an inventory.
From
This is the source location of the requisitions you want to list.
To
This is the destination location of the requisitions you want to list.
Date
You can enter the beginning and the ending date of the period you want this report for.
Number
You can enter the Requisition number you want this report for.
Sort Order
Select the field you want the information to be sorted on. There are five different sorts available: The Description The Category The Group By Time period
The Number
This report shows you your sales grouped by supplier, invoice number ,date and inventory group for the specific week.
Period
Enter the Period number for which you want to see this report.
Week
Enter the Week number for which you want to see this report.
With this option you will see the supplier, the date, the product, the quantity received, the cost of each item and the amount of each purchase.
Supplier Code
Select the supplier code from the list displayed. If you want all the suppliers check "All".
Product Code
Select the Product code from the list displayed. If you want all product codes check "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.
Date
Enter here the Beginning and the ending date for this report.
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
By Time period
By Check number
This report will show you the following information:
Supplier
Displays the supplier name.
Date
Displays the date of the invoice.
Product
Displays the inventory item description.
Quantity Received
Displays the quantity received.
Cost of each Item
Displays unit cost of the inventory item.
Total Invoice
Displays the total amount per invoice.
This report shows purchases grouped by supplier, invoice number, date and inventory group for the specific period.
Supplier
For the Purchase Analysis report, you can select a specific Supplier or click "All" to see all suppliers.
Start Date,End Date
You can select a range of date or select "All" to see the complete purchase analysis.
This report shows you your sales grouped by supplier, invoice number ,date and inventory group for the specific week.
Period
Enter the Period number for which you want to see this report.
Week
Enter the Week number for which you want to see this report.
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.
Purchase
Requisition
