Inventory Month End Reports - Month End Analysis

The following reports should "tie out" with each other in the various categories. Follow the chart below - it is designed to read up and down (i.e. the figures for Beginning Inventory come from GL Trial Balance: Module 4- Task 9 and Inventory EOM Status: Module 5- Task 10- Subtask 2)

Beg. End

Module Report (module, task, sub-task & report name) Inv Sales Purch COS Inv

G/L	GL Trial Balance, 4-9 GLTBAL	X	X	X	X	X
A/R	AR to GL Interface, 2-32-3 ARTOGL		X		X
A/R	Sales History, 2-19 SHSMNT		X
A/P	AP to GL Interface, 3-32-3 APTOGL			X
A/P	Expense Distribution, 3-11 APDIST			X
I/C	EOM Status, 5-10-2 WHSEOM	X		X	X	X
I/C	Inventory Value by P/C, 5-9-9 INVPRD					X
I/C	Inventory Value by GL, 5-9-12 INVGLA					X
O/E	OE Activity Summary, 6-16-1-6 IHSACT		X		X

Issues/questions to be aware concerning variances in the amounts on the reports:

Non-stock items. If they are NOT being added to Inventory, they will not appear on the I/C reports.
Are transactions being entered directly into either Accounts Payable or Accounts Receivable instead of coming through Order Processing or Purchasing? Transactions entered directly into AR or AP DO NOT appear on reports generated out of Purchasing or Order Entry.
Items that are labor, are they indicated as such? Otherwise they will appear on Inventory reports.
Regarding any figures in the variance column of the End of Month Status (EOM Status) report, were any accruals, reversals or quantity changes made? If so, has the General Ledger been adjusted accordingly?

Additional Information:

Follow an item through to verify that the amounts (quantity and dollar) on the valuation report are correct. Find an item or two that have a known correct beginning value and run two reports to determine the activity of the item(s).

Summary by Expense Account (PO module, Task 10, Sub-task 6 - MHSACT). This report will detail the purchase activity for an item or range of items by a date range. It is useful in determining the quantity purchased and what the purchase cost was for the item(s). If the beginning quantity/valuation of the item is added to the purchased quantities, all that is needed then is to determine how many of the item(s) were sold for the same time period. Use the G/L Sales Account/Date/Item report.
G/L Sales Account/Date/Item (OE module, Task 15, Sub-task 11 - IHSACT). This report details the sales activity for an item or group of items. Subtracting the sold quantity from the beginning on-hand and purchased quantities from the report suggested above (MHSACT), will provide the on-hand physical quantities, as well as the valuation for the item(s).
Shipping Summary by warehouse (OE Module, Task 16, Sub-task 3, Sub-task 3 IHSSHP). This report selects records from the item history file showing item#, order#, customer#, order date, promise date, ship date, number of days to ship and shipping accuracy. Completed orders in the Invoiced Order holding file must be posted before running this report.