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