Minimum Version Required: 25.12
Steps
All calculations are based on data from a chosen Location and its related Tax Entity
All Invoice Load Sheets must be in Loaded, Balanced, or Verified status in order to populate on report
All Production Orders must be in Confirmed or Verified status in order to populate on report
FIFO Adjustment invoices as well as Inventory Adjustment invoices created without a TTB Tax Code are omitted from the report
Quarterly BRO
Additions to Beer Inventory
Line 1 - On hand beginning of this report period: Sum of Inventory on given start date of all Brands.TTB Category: Beer and Products with Product Type.TTBProcessType: Produced, Canned, Racked, or Bottled
Line 2 - Beer produced by fermentation: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced brought into inventory through a Production Order
Line 3 - Beer received in bond: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled brought into inventory on a Purchase with positive NumUnits using Vendors with TTBTaxCode: Received in Bond or Purchase with Non-Production Order type Shipment (for example: imported purchase).
Line 4 - Beer returned to the brewery after removal from this brewery: Sum of Product with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled brought back into inventory on a negative Invoice which doesn't include reversal invoice
Line 5 - Physical inventory disclosed an overage: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled written out of inventory on an Invoice using Customer with TTBTaxCode: Overage or Shortage
Line 6 - (not a standard BRO line) Packaged Products Out of Balance: Populates data when Output Product by Packaging Production Orders (Lines 25, 26) not equal Produced (WIP) Raw Material type component. Note: The addition of water and other liquids is not calculated. Additions of water and other liquids in ECP should be expressed by Production Orders
Line 8 - Total additions to inventory, plus beer on hand: The sum of Lines: 1 - 6
Removals from Beer Inventory
Line 10 - Beer removed for consumption or sale including beer removed tax determined for consumption or sale in a tavern on brewery premises: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through:
an Invoice using Customer with TTBTaxCode: Tavern on Brewery Premises, or
an Invoice using Customer with TTBTaxCode: Tavern on Brewery Premises, or
a negative PurchaseTrans using Vendors with TTBTaxCode: Tavern on Brewery Premises
Line 11 - Beer removed without payment of tax as outlined under Subpart L of 27 CFR part 25: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode:
Export
Used as Supplies
Research and Development
Transfer in Bond
Unfit for Sale
Laboratory Samples
Transfer to Distillery
+ Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an negative Purchase Transaction using Vendor with TTBTaxCode: Removed Without Payment of Tax to Other Brewery
Line 12 - Beer consumed on premises: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Consumed on Premise
Line 13 - Beer destroyed at brewery: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Destroyed
Line 14 - Losses, including theft: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Loss.
Line 15 - Physical inventory disclosed a shortage: Sum of Product with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled written into inventory on an Invoice using Customer with TTBTaxCode: Overage or Shortage
Line 16 - (not a standard BRO line): Populates data in situations where the BBLs consumed and received on a repackaging Production Order do not match.
Line 17 - Total amount of beer on hand at end of quarter: Sum of Inventory on given end date of all Brands.TTB Category: Beer and Products with Product Type.TTBProcessType: Produced, Canned, Racked, or Bottled
Line 19 - Total Beer: The Sum of Lines 10 - 17
Part 2 - Cereal Beverage Summary
Line 1 - Produced: Sum of Products with Brands.TTB Category: Cereal Beverage - Below 0.5% ABV and ProductType.TTBProcessType: Produced brought into inventory through a Production
Line 2 - Removed: Sum of Products with Brands.TTB Category: Cereal Beverage - Below 0.5% ABV and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled, removed from inventory through an Invoice
Line 3 - Loss and Wastage: Sum of Products with Brands.TTB Category: Cereal Beverage - Below 0.5% ABV and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Loss
Line 4 - Received: Sum of Products with Brands.TTB Category: Cereal Beverage - Below 0.5% ABV and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled brought into inventory on a Purchase with positive NumUnits using Vendors with TTBTaxCode: Received in Bond
Line 6 - Total on hand at end of period: Sum of Inventory on given end date of all Brands.TTB Category: Cereal Beverage - Below 0.5% ABV and Products with Product Type.TTBProcessType: Produced, Canned, Racked, or Bottled