Information Systems:Auditors - Inventory
Jump to navigation
Jump to search
Go to InfoNet / Inventory / Summarize/Extract Item Transactions.
Item balances can be calculated for any period by summarizing all transactions up to that point.
Key in a starting fiscal period that is older than any inventory transaction, and for ending period, the period for which you want the balance. Summarize by warehouse and item. Click on the search button.
The total 'Amount' should agree with the G/L.
If it doesn't, an adjustment will have to made to the G/L.
Click on 'Summary to Excel' - be careful NOT to click on 'Detail to Excel'; as of January 2016 that would be almost 27 million records!