Reconciliation and Reporting

Several reports are provided to assist you in verifying that the physical inventory counts have been entered accurately and completely.  These reports assist you in reconciling your physical count to system records.  Discrepancies may be resolved by correcting counted quantities using the Physical Inventory Ticket Maintenance conversation, or by entering unrecorded inventory transactions through the standard MAC-PAC inventory conversations.

The Physical Inventory Ticket Exception report (IC680A) lists each "Uncounted," "Canceled," and "Blank" ticket.  The objective of this report is to help you identify tickets for which counts have not been recorded.

The Physical Inventory Edit reports (IC675A, IC675B) list every ticket for a specified company/warehouse (sorted by ticket number or batch number).  The edit reports provide the ticket status and the perpetual and actual physical inventory balances for the ticket.

Note:    You should verify that all tickets are accounted for--using either the Physical Inventory Ticket/Batch Edit reports or the Physical Inventory Exception report.  This check should be done before adjustment calculations are performed because the adjustments report will only list tickets with a status of "Counted."

The Perpetual vs. Physical Inventory reports (IC685A, IC685B, IC685C) compare the perpetual and actual physical inventories, including the calculated adjustment quantity and value.  The information is presented in three different formats:  by part, by accounting code, or by adjustment value.  The report sorted by accounting code is useful in evaluating the effect of the adjustments on inventory accounts.  The report in adjustment value sequence helps you quickly identify the most significant adjustment amounts.

Note:    You should verify that all discrepancies (such as duplicate ticket information or tickets not found for which inventory balances exist) are resolved before requesting the Physical Inventory Adjustment Generation option--which generates adjustments against inventory balances on the system.