Minimum Version Required: 24.10
Pre-Conditions
Important Configurations:
Options that can be set are:
Low Beer
Strong Beer
Wine
Low Proof Spirits
Steps
1. Ensure State Tax Codes on Locations Product Types table EXACTLY match the tax codes listed on the dashboard
2. Filter to desired location and start/end dates
3. Select the form you wish to export
4. Use reports below to get additional detail behind any form values
Fields And Definitions
Beginning Inventory = On Hand Inventory as of Report End Date
Total Purchases = Total gallons purchased or transfered into filtered Location from Purchases in Received or greater status.
Gallons Destroyed = NULL (This value should be manually populated based on state-approved destructions)
Transfers Out = Total gallons invoiced to customers with Customer Account Type = Transfer Out
Sales to Out-of-state-Customers = Total gallons invoiced to customers with Customer Account Type = Sale and State <> ID
Sales to sub-distributors = Total gallons invoiced to customers with Customer Account Type = Sale and Customer Type Trade Channel ID = 43
Inventory Adjustments = Total gallons invoiced to customers with Customer Account Type = Inventory Adjustment
Sales to Military = Total gallons invoiced to customers with Customer Account Type = Sale and Customer Type has Military = True