You use this program to generate a report of journals created from transactions processed that affect Inventory.
These journals are created by the Inventory GL Integration program and serves as an audit trail of transactions posted from within the following programs:
The report can be run at any time and as often as required.
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Reprint |
|
||||||||
Report options | |||||||||
Print summary journal | Select this to print an additional page summarizing all transactions posted for the journal. | ||||||||
Print new page per journal | Select this to print journals on separate
pages. This option cannot be deselected if you selected the Print summary journal option. |
||||||||
Print multiple bin transfer |
Select this to list all Bin transfer transactions posted in the Inventory Movements program. This option only applies if the Multiple bins option is enabled (Inventory Setup). |
||||||||
Journal print options | |||||||||
Show | Indicate the types of journals you want to include in
the report.
|
||||||||
Warehouse selection | Indicate the warehouse(s) for which to include journals in the printed report. | ||||||||
Period selection |
|
||||||||
Journal selection | Indicate the transaction journal(s) to print. |
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).
The following details are included on the report:
A warning is printed in the report column: EXCP if a non-zero cost variance percentage is defined (Inventory Setup) and a receipt was processed where the percentage change between the old and new cost exceeds this cost variance.
In addition, if the stock code had any quantity on backorder, then the one of following messages is printed in the EXCP report column:
The GRN number is only printed in the Reference column of the report when GRN matching is required (Purchase Orders Setup) and the detail line contains a purchase order number.
The Job number is printed in the Reference field when the Reference field equals the job number and the Reference is not spaces. The presentation length of the job number is formatted according to the format defined for Jobs in the Set Key Information program.
If you enabled the FIFO valuation and Print FIFO Journals setup options (Inventory Setup) then two journals are generated for each transaction; one being the standard journal and the other the FIFO journal (regardless of whether the warehouse in which the transaction occurred uses FIFO costing).
No detail Inventory journals are created for transactions processed using the WIP Inspection Variance Closure program. In addition, the Summary Inventory journal page reflects zero values. This is because these transactions are for variance values only and therefore do not affect inventory quantities. The variance values are reflected on the ledger distribution report and are posted to the General Ledger.
An Out of balance Lot adjustment can be created by running the Balance function of the Inventory Period End program as follows:
The Balance function compares the total on hand for all Lots to the total on hand for all Bins for a stock item. If there is a discrepancy, it reads through all the rows in the LotDetail file and then updates the Bins with the quantity on hand for each of these LotDetail records (the Bin is part of the key).
If the total on hand quantity of lots for a warehouse matches the on hand quantity of the bins, but does not match the total on hand quantity stored against the warehouse, then the total on hand quantity for the warehouse is updated and an adjustment entry is posted to the Journal file and Movement file.
The adjustment value posted is the total amount by which the warehouse was adjusted by the lots (i.e. The Warehouse is adjusted by the difference. Lots are not adjusted as they are seen as being correct).
The same is true for previous ECC revision/releases. ECC uses the LotDetail table to hold the quantities for ECC controlled items at revision/release level even when the item is not lot traceable. If it is not lot traceable then the information is stored in LotDetail file with a dummy lot number that is built up as Revision + Release.
The same logic applies in that it reads through the LotDetail file for each lot/bin combination and updates the quantities on the InvMultBin table.
Based on the above, it is not possible to list which lot/bin/rev/rel is being updated as it is not the lot being adjusted, but the actual quantity on hand according to the bin/warehouse.
A lot can exist in multiple bins and in each bin there can be multiple lots, so when summing up for each lot/bin combination there can be any combination that adds up to the quantity on hand and not necessarily a single lot/rev/rel updating a single bin.
You can only reprint Inventory journals for as long as you are retaining Inventory journals (Inventory Setup).
Inventory journals are deleted as part of the Purge function of the Inventory Period End program.
The Period selection is ignored when reprinting journals. All journals are reprinted irrespective of the periods selected.