Inventory Statements

The Inventory Statements report is found at Accounting Reports / Inventory / Inventory Status.

On Hand

In the Select Style section, choose On Hand. Select any other additional criteria then choose to Print, Preview, or create a PDF File and insert a File Name.

The On Hand Inventory Statement shows the quantity and value of the Products that are in warehouses right now. The report shows the On Hand amount (which can be seen when editing a Product) in Inventory and Billing Units, the Cost of the Product, Total Cost, List price, Markup, and Margin. Run this report to review costs or List prices or determine if enough of a Product is available for a customer to buy.

Company Owned

At Accounting / Accounting Reports / Inventory / Inventory Status Reports select Inventory Statements. In the Select Style section, choose Company Owned.  Input Report Criteria and choose to Print, Preview, create a PDF File or a Text File and insert a File Name if selecting a pdf or text file. This report can be scheduled to run through Agvance Agent.

The Company Owned Inventory Statement shows how much Product the company owns, which is not necessarily the same as the Product in the warehouse. The report starts with the On Hand amount of each Product, adds to the Product any unprocessed, loaded Blend and Delivery Tickets, and subtracts the amount of Product on unprocessed Purchase Receipts.

Product on unprocessed, loaded Blend and Delivery Tickets has left the warehouse, and therefore is no longer On Hand but, because the Customer has not been invoiced, the company still owns the Product. Product on unprocessed Purchase Receipts is sitting in the warehouse On Hand but has not been billed by the vendor so the Product is not yet owned. The company owned quantity times cost is the value that is posted into the Inventory Asset General Ledger Account when the Post Inventory to G/L function is performed (optionally including the value of unprocessed Purchase Receipts).