The Inventory Position Gross Margin report reviews sales, purchases, and margins for a specific fiscal month range. This report is located at Accounting Reports / Inventory / Inventory Position.
Setup
Definitions for the headings used on the Inventory Position Gross Margin report are noted below.
- Quantity Sold - the total quantity sold on Accounts Receivable Invoices during the specified fiscal month range.
- Units - the inventory unit of measure for the product.
- Dollars Sold - the total dollar amount sold on Accounts Receivable Invoices during the specified fiscal month range.
- Beg Inv Val - this is the Beginning Inventory Value and is calculated as (Company Owned quantity at the beginning of the first fiscal month in the selected range / Billing Divisor) * department level cost at the beginning of the first fiscal month selected.
- Purchases - valued one of two ways depending on the department level cost:
- If the department is set to use Estimated Average Cost, then the value of all Purchase Receipts in the fiscal month range is equal to the Purchase Receipt Estimated Cost + the value of all Direct Purchase Invoices in the fiscal month range + the change in the value for all From Receipt Purchase Invoices comparing the Purchase Receipt cost to the Purchase Invoice cost.
- If the department is not set to use Estimated Average Cost, then the value of purchases is the value of all Purchase Invoices in the fiscal month range, both Direct and From Receipt.
- Note: Both calculations include freight, additional charges, and manufactured blends.
- End Inv Val - this is the Ending Inventory Value and either the Company Owned Inventory value saved at the end of the month for the last fiscal month selected in the range or the current value of the Company Owned Inventory if the last month is the current fiscal month.
- Cost of Sales - calculated as Beg Inv Value + Purchases - End Inv Value.
- Gross Margin - calculated using the Dollars Sold - Cost of Sales.
- Per Unit - calculated as Gross Margin / (Quantity Sold / Billing Divisor). If the Quantity Sold is equal to 0.00, then the Per Unit margin is set to 0.00.
- % - calculated as (Gross Margin / Dollars Sold) * 100. If the Dollars Sold is 0.00, then the margin is set to 0.00.
The following options are available on the Report Criteria area of the report.
- Exclude Zero Value Products - products are suppressed when the Quantity Sold, Dollars Sold, Beg Inv Value, Purchases, and Adjustment Value are all 0.00.
- Include Adjustment Value - the dollar value of the inventory adjustments displays.
