Requisition List (Detailed or Condensed)

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

Products List

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

Suppliers List

With this option it is possible to display/print all the Suppliers that were entered in the System.

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.

Condensed Purchase List

Purchase Weekly 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.

Detailed Purchase List

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.

Purchase Analysis

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.

Purchase Weekly 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.

Back to top