Technical Information

As an order moves through the process from shopping cart or quote to invoice various statuses are maintained.

  • Shopping cart
    • Estimate transaction with AvaTax
    • Sales tax recorded in BDCarts.Tax
  • Quote
    • Estimate transaction with AvaTax
    • Sales tax recorded in OEOrdHdr_sql.sls_tax_amt_1
  • Order Acknowledgement
    • Estimate transaction with AvaTax
    • Sales tax recorded in OEOrdHdr_sql.sls_tax_amt_1
  • Order Invoiced
    • Post new transaction to AvaTax
    • Sales tax recorded in OEOrdHdr_sql.sls_tax_amt_1
    • BDInvoiceSupport.TaxProcessingStatus set to 2
    • Canadian invoices will record tax detail to SYTaxTrx_sql
  • Commit Sales Tax (after order is posted)
    • Commit existing transaction at AvaTax
    • BDInvoiceSupport.TaxProcessingStatus set to 3