Skip to content

Avalara - Tax Queue

Release Date: 4/28/23
Updated: 1/26/24
 
Version: 8.6 and Above

The tax queue application is designed to capture all of the tax transactions processed through Customer Order Processing to prepare them to be committed through the AvaTax Service. This new application is available under System Utilities-> Avalara/Vertex Interface -> Processing-> Tax Queue with the following options:


Processing

Review Tax Queue – This application shows a list of the transactions in the queue to be processed. A reconciliation status will show which transactions failed calculation and were estimated using a combined tax rate from the Avalara Zip Tax File (AVZIPTAX).

Review Tax History - This application shows the batches of transactions that have been successfully committed using the AvaTax service. Drill downs are available to the individual invoices posted in each batch.

Print 


Tax Commit Edit List -  The Tax Commit Edit List shows the list of transactions to be committed to Avalara using the AvaTax Service.

Commit Tax TransactionPosting Invoices to Accounts Receivable does not communicate with Avalara to commit the transaction. This is to avoid a crash in invoice posting if the application is unable to communicate with Avalara. Instead, the invoice posting application posts the tax transactions to the new Avalara Tax Queue file (AVTAXQUE). The Commit Tax Transactions application commits the transaction to Avalara in a separate step and can be scheduled through deferred processing after invoice posting has completed.

Tax Reconciliation ReportThe Tax Reconciliation Report shows all of the committed tax transactions that occurred during a specific time period. The report has the option to only show transactions where there is a discrepancy between the estimated tax amount and the actual calculated tax amount.

Uncommitted Tax Override Report - This report shows all non-invoiced and invoiced but unposted orders that used the Avalara override tax code ON030000. This situation can occur if the Avalara portal is configured to run Streamlined Sales Tax (SST) but the customer's exemption certificate has not been added to the Avalara portal. If the override code has been sent with the order, the "Used TaxCd ON030000" option will be checked in the _AVATAXSNAPSHOT attribute and an event will be triggered to notify the user of the situation. This event should be monitored and the situation remedied since the use of the override code can trigger an audit at the state level.

Committed Tax Override Report - This report shows all posted invoices that used the Avalara override tax code ON030000. This situation can occur if the Avalara portal is configured to run Streamlined Sales Tax (SST) but the customer's exemption certificate has not been added to the Avalara portal. If the override code has been sent with the order, the "Used TaxCd ON030000" option will be checked in the _AVATAXSNAPSHOT attribute and an event will be triggered to notify the user of the situation. This event should be monitored and the situation remedied since the use of the override code can trigger an audit at the state level.

CLS


Feedback and Knowledge Base