You use this program to generate a report of sales and/or inventory transactions for a selected range of stock items. Inventory movement transactions are processed using the Inventory Movements program.
The report can be generated to print details of selected or all sales and/or inventory transactions for:
- a selected period
- a single warehouse or range of warehouses
- a single stock code or range of stock codes
- a single supplier or range of suppliers
- a single product class or a range of product classes
- a single customer or range of customers
- a single salesperson or range of salespersons
- a single buyer or all buyers
You can also indicate a range of dates according to which transactions must be selected for printing.
| Field | Description | ||||
|---|---|---|---|---|---|
| Sequence | Indicate the sequence in which you want to print the
report. The following sequences are available:
|
||||
| Print options | |||||
| Print warehouse details |
Select this to print totals for individual warehouses together with an accumulated total of all warehouses for each stock code. If you do not select this option, then only the accumulated warehouse totals for each stock code is printed.
|
||||
| Only print items with MTD activity |
Select this to print only those stock codes against which any month-to-date activity has been recorded in at least one warehouse.
|
||||
| Subtotals required | Select this to include warehouse totals, stock totals and sales movement totals on the report. | ||||
| Calculate FIFO/LIFO unit costs |
Select this to calculate and print FIFO/LIFO unit costs based on the transaction value (i.e. dividing the value by the quantity). The new cost remains blank.
|
||||
| Movement totals required |
Select this if you want to print totals for each individual movement type you select using the Movement Options. The total quantity and transaction value are printed for each movement type. |
||||
![[Note]](images/note.png)
| Field | Description |
|---|---|
| Stock code selection | Indicate the stock item(s) you want to include in the report. |
| Warehouse selection | Indicate the warehouse(s) for which you want to include stock items on the report. |
| Supplier selection |
Select stock items for printing based on the supplier of the items. The supplier for an item is defined against the item (see Stock Code Maintenance - Replenishment tab). This option enables you to select only those stock items that are supplied by the suppliers you select here. |
| Product class selection | Indicate the product class(es) for which you want to include stock items on the report. |
| Buyer selection | Indicate the buyer(s) for which you want to include stock items on the report. |
| Cycle count selection | Indicate the cycle count(s) for which you want to include stock items on the report. |
| Field | Description |
|---|---|
| Movements to print | |
| Inventory movements | Select this to print Inventory movements on the report.
Inventory transaction types are indicated on the report as
follows:
|
| Sales movements |
Select this to print Sales movements on the report. Sales transaction types are indicated on the report as follows:
|
| Inventory movements | Indicate the type of inventory movement(s) you want to
include. The following can be selected:
This applies if you selected to print Inventory movements. |
| Field | Description |
|---|---|
| Date selection | Indicate the date(s) according to which transactions must be selected for printing. |
| Customer selection | Indicate the customer(s) for which sales transactions must be included in the report. This only applies if you selected to print sales movements. |
| Salesperson selection | Indicate the salesperson(s) for which sales transactions must be included in the report. This only applies if you selected to print sales movements. |
| Field | Description | ||||
|---|---|---|---|---|---|
| ABC class selection | Select a stock item according to its ABC classification. At lease one ABC class selection must be made. | ||||
| Make to order items | |||||
| Include | Select this to include made to order items in the report. | ||||
| Exclude | Select this to exclude made to order items from the report. | ||||
| Only | Select this to only include made to order items in the report. | ||||
| MPS items | Indicate whether you want to include or exclude Master Production Schedule (MPS) items. | ||||
| Include | Select this to include MPS items in the report. | ||||
| Exclude | Select this to exclude MPS items from the report. | ||||
| Only | Select this to only include MPS items in the report. | ||||
| Statistical items |
Indicate whether to include or exclude statistical items.
|
||||
| Include | Select this to include statistical items in the report. | ||||
| Exclude | Select this to exclude statistical items from the report. | ||||
| Only | Select this to only include statistical items in the
report. This is not relevant if you are including MPS and/or Make to order items. |
||||
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
Details of bin transfers are printed for transfers within the same warehouse if you selected the option: Record movements for bin transfers (Inventory Setup - Options tab). This only applies if you are using multiple bins (Inventory Setup - General tab).
For receipts, the value in the New Cost column indicates the new average cost calculated by the system according to the receipt processed for the item. The value in the Entered Cost column indicates the receipt cost entered at the time of processing the receipt for the item.
-
The amount of data available is dependent on the length of time that movement records are retained (Inventory Setup - History tab).
-
The unit cost is not printed on the report if your costing method is set to either FIFO or LIFO (Inventory Setup or Browse on Warehouses).
-
If you are running on an SQL server-based system, the optimized SQL version of the report does not print warehouse details for which there are no movements.