The Print Stock Adjustments Report (IC51) program produces an audit trail of stock and cost adjustments created in Enter Inventory Adjustments (IC50).
You can run this report as often as you want but it is typically printed at the end of each day. Upon acceptance of the report, the Inventory Adjustment transaction file is erased; the next user entering IC50 will be allowed to enter a new GL posting date for the next batch.
The transactions on the report are grouped by Warehouse/Inventory Adjustment Code, giving subtotals for each type of adjustment. The report includes a page for each of the following sections: (Note: User-defined Inventory Adjustment Codes also display as individual sections on the report)
- 1 - Bin/Location Transfer - in a multi-bin environment, bin location transfers entered via Whse Relocate Stock (WH30).
- A - General Quantity Adjustment - the adjustment quantity, on hand quantity (before and after), adjustment value, GL Adjustment account and GL Inventory account display.
- C - Cost - the Average Cost (before and after), latest cost (before and after), adjustment value, GL Adjustment account and GL Inventory account display.
- H - Maintain Lot Hold Flag - the Hold code, Operator Code that assigned the Hold, and the Lot/Serial # associated with the Hold display.
- L - Maintain Lot Comment & Expiry - the Hold code, Operator Code that assigned the Hold, Expiry Date of Hold, and the Comment associated with code display.
- N - Recode Lot/Serial Number - the old and new Bin, Lot or Serial number displays.
- R - Stock Receipt - the receipt quantity, on hand quantity (before and after), cost of adjustment, receipt value, GL Adjustment account and GL Inventory account display.
- T - Stock Transfers - two separate transactions are recorded: one for the source Warehouse and one for the destination Warehouse. The transfer quantity, To Warehouse/From Warehouse, GL Adjustment account and GL Inventory account display.
- GL Posting - a summary of the General Ledger postings prints at the end of this report (as per the Inventory Adjustment GL Relating Table in Enter Inventory Adjustment GL (IM44)) and, upon acceptance of the report, the GL accounts are updated. We recommend that IC51 be printed before closing the General Ledger.
To Generate the Stock Adjustment Report (IC51):
- The Printer Selection screen automatically opens. Select the Printer destination and click OK.
- The following message displays: "Do you wish to print supplier/product code? Yes/No". Select Yes to include the Supplier-Product code on the report. Select No to print the report without the Supplier-Product code.
- IC51 runs automatically; no other report parameters are required.
- The Report Complete screen opens when the report is generated. Depending on the print device selected, you are presented with one of the following two options:
- If you are printing the report to a local printer device, PDF file or to your screen, enter the Acceptance Codes to accept the report, click Restart to restart the printing of the report, or click Abort
to cancel the report.
- If you are sending the report via an email or fax device, click OK to accept the report, click Restart to restart the fax/email (not always applicable), or click Abort to cancel the report.
Here is a sample page of the IC51 report:
Example of Adjustment A: Inventory Adjustments Report (IC51)
|