Here are the answers to some of our frequently asked questions about transactions.
What is a transaction?
in AvaTax are modeled after a document (invoice, credit memo, or return) with one or more lines.
A transaction is a record of the:
- Document and line details needed to process a transaction
- Results of the transaction, including taxes, sourcing information, and tax codes
- AvaTax records the history of each transaction for use in liability worksheets and reports.
What is the line limit for a document?
The number of lines on a transaction is limited to 15,000. This refers to the number of unique lines as defined by Line No and not the quantity of items.
How can I view all lines in a document?
You can change the number of lines displayed per page by changing the number in the Lines Per Page drop-down.
To change the page, click one of the following:
- : Click to go to the next page.
- : Click to go to the previous page.
- : Click to go to the first page.
- : Click to go to the last page.
How do I import with tax included?
When importingwith tax included, AvaTax still extracts the tax and distributes it to the appropriate jurisdictions. It is necessary to use the proper process code and specify tax is included:
- Use process code 3: New transaction with tax calculation.
- Tax included (column AI): Enter 1.
How do I resolve address validation errors?
errors can prevent tax calculation and invoicing as well as be symptomatic of more complex issues; therefore, it is important to thoroughly investigate address validation errors.The following steps should be used as a guide for determining if the address simply isn't validating in the database or if there is a broader issue at play.
What are the different transaction document types?
|6||Inventory transfer order|
|7||Inventory transfer invoice|
|8||Reverse Charge order|
|9||Reverse Charge invoice|
What does the adjusted document symbol indicate?
The adjusted document symbol indicates a transaction has been adjusted. The adjustment reason appears on the document tab of the transaction.
What does the locked document symbol indicate?
The locked document symbol indicates ais locked and can no longer be committed, voided or adjusted. Approving a locks all the documents on that worksheet.
What are document, tax calculation, and status dates?
- Document date: The date of the document. This is used to determine the period in which the document falls. It is also the default tax calculation date unless specified otherwise.
- Tax Calculation Date: The date of tax calculation. This can be adjusted independently of the document date on the Admin Console and is particularly useful when backdating the tax calculation date to account for a change in rate between invoice and credit memo.
- Status Date: The status date is the date of the last modification to the transaction. It has no bearing on which period the transaction falls into, nor on the tax calculation date.
Where does the batch code come from?
AvaTax assigns a batch code to each group of imported. The batch code cannot be edited.
What are the different transaction document statuses?
Acan have one of three document statuses as listed in this topic.
- Committed documents have been successfully posted to the general ledger. Committed documents are displayed by default in AvaTax reports.
- Uncommitted documents are generally invoices, credit memos, or returns that have been saved but not posted. They can also be transactions that have an error, causing them to fail to move to a committed status. Uncommitted documents aren't displayed by default in AvaTax reports. Use Show Advanced filtering options in reconcile and export reports to filter for uncommitted documents.
- Voided documents have been canceled or voided. Documents aren't displayed by default in AvaTax reports. Use Show Advanced filtering options in reconcile and export reports to filter for voided documents.
How do I adjust a locked transaction?
A transaction is locked when we file a return associated with that transaction. In order to adjust the transaction, you need to create a credit memo and a corrected transaction. Credit memos should only be created in the Admin Console when the following criteria is met:
- The credit is already reconciled with your customer
- The credit has not been created in the Admin Console
In such circumstances, it is appropriate and safe to create a credit in the Admin Console as a document in the Admin Console will not create a document in your accounting system. To create a credit memo, follow these steps:
- On the Transactions tab, click New.
- On the Document tab, fill out all required fields:
- Origin/Destination Addresses
- Document Code
- Customer/Vendor Code
- Document Date
- On the Lines tab, click Add New Line. You must add at least one line.
- In the Amount field, type the dollar amount as a negative number.
- Click Add.
- On the left, click Calculate Tax.
- Click Save as Uncommitted or Save as Committed.
What do I do with uncommitted transactions?
If you see a in the Admin Console with a status of uncommitted, it is usually caused by an invoice, credit memo, return, or other transaction document in your accounting system that is saved, but not posted. An uncommitted status might also be caused by a transaction that for some reason didn't process correctly.
To change the status of an uncommitted transaction, you can:
Uncommitted transactions are not displayed automaticall in AvaTax reports.
How do I resolve the error message "company code mismatch"?
- Case (upper/lower case)