|
Physical Inventory Physical Inventory Worksheet Audit |
|
Physical Inventory Physical Inventory Worksheet Audit |
The Physical Inventory Worksheet Audit is a report that enables the auditing of the posted actual inventory counts and the affects the counts will have on the General Ledger adjustment to the Inventory account.
Audit Setup
Program ID. Enter the program ID of the program to audit. If the program ID is not known, enter "?" to display the Active Programs window. Select the program by entering the sequence number to the left of the program ID.
The audit will print the following information:
| 1. | Item Number and Description. |
| 2. | A/R/B. Aisle/Row/Bin. This is the physical location in the warehouse of the item listed. |
| 3. | Actual Quantity. The quantity posted in Physical Inventory Posting . |
| 4. | Current Quantity. The quantity the system stated as On Hand before the physical inventory counting. |
| 5. | Variance. This is a calculated figure of Actual less Current quantity. |
| 6. | D. Discontinued Y or N. |
| 7. | Average Cost. This is the average cost loaded in the F5=Inventory option of Inventory Item Maintenance on the IFM menu. |
| 8. | Extended Cost. This is a calculated figure of Variance multiplied by the Average Cost. |
