How AP Automation populates draft AP supplier invoices
AP Automation populates draft AP supplier invoices using data supplied by the source document, the supplier record, and Artificial Intelligence/Machine Learning (AI/ML).
Data sources for fields in the draft AP supplier invoice
To create an automated draft AP supplier invoice, AP Automation uses AI/ML to gather information intelligently, from multiple sources:
- Artificial Intelligence and Machine Learning (AI/ML) predictions
- The supplier information record
- The source AP supplier invoice document
- Your configuration and company settings
To begin with, AI/ML uses predictions to match the AP supplier invoice to the correct supplier. This allows Sage Intacct to use information from the supplier record to fill in the pay to and return to addresses, the term, and payment priority. The term is used to calculate the due date.
AI/ML also extracts information from the AP supplier invoice document that you upload or email. The AP supplier invoice date, AP supplier invoice number, transaction currency, line item amounts, and memos, all come from the source AP supplier invoice.
For fields such as GL account, Location, Department, and Project, AI/ML predicts the values based on your historical patterns.
Finally, your configuration and company settings determine the GL posting date and currency exchange rate information.
When information is not available
Sometimes, AI/ML cannot extract field information from the usual source. In this case, AI/ML either uses an alternate source, if available, or leaves the field empty.
For example, if you did not define the term in the supplier information record, AI/ML cannot use the term to calculate the due date. In that case, AI/ML attempts to extract the due date from the AP supplier invoice document. If the due date is not readily available in the document you emailed or uploaded, Sage Intacct leaves the field empty.
For details of alternate sources of data, refer to the table that follows.
Field details
| AP supplier invoice field | Source |
|---|---|
|
Date |
The AP supplier invoice date from the source AP supplier invoice. If Intacct cannot extract the date from the AP supplier invoice, it uses the system date at the time the AP supplier invoice was processed. |
|
GL posting date |
Determined by the summary frequency configured for your company:
|
|
Supplier |
AI prediction of the best match from your list of Suppliers. If AI cannot match the supplier name with confidence, this field is left empty. The AP supplier invoice is flagged with a Resolve import exception (Supplier not found) in the AP supplier invoices list.
|
|
Pay to |
The Pay-to contact information from the matching supplier information page. |
|
Return to |
The Return to contact information from the matching supplier information page. |
|
AP supplier invoice number |
The AP supplier invoice number from the source AP supplier invoice. |
|
Reference number |
This field is left empty. |
|
Description |
This field is left empty. |
|
Term |
The Term defined on the Payment information tab of the supplier information page. If you did not define a term for the supplier, the field is empty. |
|
Attachment |
The AP supplier invoice image that you or the supplier provided. |
|
Due date |
The due date is populated as follows:
|
|
Payment priority |
If a payment priority is defined on the Payment information tab of the supplier information page, that priority is used. Otherwise, this field is empty. |
|
Transaction has tax implications |
This option is selected when the predicted location has an assigned tax solution. |
|
Tax solution |
The tax solution is populated based on the predicted location. |
|
Inclusive tax |
This option is selected when the previous AP supplier invoice for the supplier had inclusive tax in the line entries. |
|
Transaction currency |
For multi-currency companies, the transaction currency is the currency as shown on the source AP supplier invoice. If it cannot be predicted from the source AP supplier invoice, the transaction currency is the base currency of the location for this AP supplier invoice. For AP supplier invoices submitted at the top level in a multi-currency company, the system uses, in order:
|
|
Exchange rate type |
If your company uses custom exchange rate types, Intacct uses your default Exchange rate type. Alternatively, if your company hasn't defined any custom exchange rate types, the Intacct daily rate is used. |
|
Exchange rate date |
The AP supplier invoice date. |
|
Exchange rate |
The current exchange rate that your company set for this currency. |
| Entries | |
|
Account |
Populated based on AI/ML predictions. If AI/ML cannot confidently predict a value, this field is empty. Corrections you make to Account are fed back to the ML system when you post the AP supplier invoice. Your corrections are used to improve future predictions. |
|
Account label |
This field is empty. |
|
Amount |
The source AP supplier invoice. If your settings are to generate each AP supplier invoice with a single line that summarizes the total, this amount represents the total of all line items shown on the source AP supplier invoice. If your settings are to generate each AP supplier invoice with all line items and associated amounts, this amount represents a single line item shown on the source AP supplier invoice. |
|
Department |
Populated based on AI/ML predictions. If AI/ML cannot confidently predict a value, this field is empty. Corrections you make to Department are fed back to the ML system when you post the AP supplier invoice. |
|
Location |
Populated based on AI/ML predictions. If AI/ML cannot confidently predict a value, this field is empty. Corrections you make to Location are fed back to the ML system when you post the AP supplier invoice. |
|
Project |
Populated based on AI/ML predictions. If AI/ML cannot confidently predict a value, this field is empty. Corrections you make to Project are fed back to the ML system when you post the AP supplier invoice. |
|
Transaction tax |
Populated based on AI/ML predictions when the source AP supplier invoice has tax information in the line entries. If tax information is not in the line entries, then this field will show an allocated tax amount based on the tax total for the transaction. If there are multiple tax rates in a transaction, verify each line for correctness. The AI might combine the two tax rates into one and allocate the total tax amount to each line.
If AI/ML cannot predict the line item tax, Transaction tax is left empty for individual lines. Learn more about tax handling in AP Automation. |
|
Memo |
The line item description from the source AP supplier invoice, if you chose to generate each AP supplier invoice with all line items and associated amounts. If your settings are to generate each AP supplier invoice with a single line that summarizes the total, this field is empty. |
|
AP Account |
If an AP account is defined on the Additional information tab of the supplier record, that GL override account is used to populate this field. Otherwise, this field is empty. |
|
Other dimension values |
Other dimension values will be empty. You can enter other dimension values before posting the AP supplier invoice. |
|
1099 |
The supplier information page. |