Minimum Version Required: 25.03
Steps
Steps to Create Report
1. Select Location and Date Range
2. Select Product Type
3. Select Report Types
4. Click Create Text
5. Excel file will download when the report has finished
Fields And Definitions
For each invoice, a heading record must exist, the characters should be arranged as follows:
Column A: Invoice Date (Format: MM/DD/YYYY)
Column B: Invoice Number (50 Alpha/Numeric characters or less)
Column C: ABLE Number (leading zeros to complete field for 6 numeric characters, less than 7 digits)
Column D: Customer Name (50 Alpha/Numeric characters or less)
Column E: Invoice Total (Decimal Number)
Each line of the invoice must have a detail record, the characters sould be arranged as follows:
Column F: Product type (B(eer), W(ine) or S(pirit))
Column G: Product Description (50 Alpha/Numeric characters or less) should be descriptive enough to determine the size and ounces of the package
Column H: Unit of Measure (50 characters or less, Product Type of B will be Case or Keg, Product Type of W or S will be the size of bottle/can in Liters: ex - 750ml would be 0.75)
Column I: Quantity sold (Whole Numbers, Leading zeros to complete field for 4 numeric characters)
Best Practices
State Contact
Susan McTiernan
Auditor - Oklahoma Tax Commission
409 NE 28th
PO Box 269054
Oklahoma City, OK 73126-8054
(405) 521-3530