The Inventory Detail Recap report shows a high-level summary of product activity reflecting the movement of inventory. Navigate to Accounting Reports / Inventory / Inventory Position / Inventory Detail Recap. The headings on the report are as follows:
- Beg Amt On Hand – This is the amount of Product on hand according to Agvance at the beginning of the starting fiscal month selected in the Report Criteria set up area.
- Receipts & Purchases – This is the sum of unprocessed Purchase Receipts and Purchase Invoices.
- Manufacture Process – This is the sum of manufactured inventory from Accounting / Inventory / Manufacture Inventory, Accounting / Inventory / Advanced Manufacturing, Accounting / A/R / Invoicing if the product is set to Affect Inventory at Billing, and Blending / Edit / Blend to Stock.
- Inter-Comp Transfers – This is the sum of Inter-Company Transfers.
- Invoices, Blends & Deliveries – This is the sum of A/R Invoices, unprocessed Blend Tickets, and unprocessed Delivery Tickets.
- Recap Amount – This is a calculated amount based on the first five columns: Beg Amt On Hand + Receipts & Purchases + Manufacture Process + Inter-Comp Transfers - Invoices, Blends & Deliveries = Recap Amount.
- Inventory Adjustments – This is the sum of Inventory Adjustments.
- Current Amt On Hand – This is the amount of product on hand according to Agvance for the ending fiscal month selected in the Report Criteria set up area.
- UOM – This is the unit of measure selected for Use Quantity Units in the Report Criteria set up area. This can be Inventory Units, Billing (Pricing), Package Units, Lbs, or Tons.
