Minimum Version Required: 24.11
Pre-Conditions
Important Configurations:
Options that can be set are:
Cider
Non-Fortified Wine
Fortified Wine
Beer - Low Rate
Beer - High Rate
Spirits
Steps
Select Location(s)
Select Date Range
Select Report Type
Create Report
Fields And Definitions
Form LIQ755 and LIQ755A: Beer & Wine Purchases
Purchase Data = Purchase.ReceiveDate within Start/End Date filters and Vendor.VendorType <> Distributor or Transfer
Licensed Trade Name = TaxEntities.TaxEntity
Location Address = Locations.Address
Supplier's WSLCB License No = Suppliers.LicenseNumber
Supplier Name = Suppliers.Supplier
City or Country = Vendor.City or Vendor.Country if <> United States of America
Form LIQ779 and LIQ779A: Beer & Wine Tax Credits
Invoice Data = InvoiceTransHist.Date within Start/End Date filters
Licensed Trade Name = TaxEntities.TaxEntity
Location Address = Locations.Address
Supplier's WSLCB License No = Suppliers.LicenseNumber
Supplier Name = Suppliers.Supplier
City or Country = Vendor.City or Vendor.Country if <> United States of America
Total liters/barrels sold to Military = Customers.CustomerType.IsMilitary = 1, True
Total liters/barrels exported from state = Customers.State <> WA
Total liters/barrels claimed for freight damage and destruction are not automatically populated. These values need to be inputted by the user offline based on claims approved by the state.
Form LIQ161: Spirits Purchases
Part 1:
Purchase Data = Purchase.ReceiveDate within Start/End Date filters and Vendor.VendorType <> Distributor or Transfer
Licensed Trade Name = TaxEntities.TaxEntity
Location Address = Locations.Address
Supplier's WSLCB License No = Suppliers.LicenseNumber
Supplier Name = Suppliers.Supplier
City or Country = Vendor.City or Vendor.Country if <> United States of America
Part 2:
Invoice Data = InvoiceTransHist.Date within Start/End Date filters and Customer.CustomerAccountType = Sale
Sales to On Premise Retailers = Customers.OnPremise = On Premise
Sales to Off Premise Retailers = Customers.OnPremise = Off Premise
Sales to Washington Distributors = Customers.CustomerType.TradeChannel = 43, Sub-distributors
Sales exported from Washington = Customers.State <> WA