Troubleshoot AP Automation with Purchasing

AP Automation with Purchasing is generally available. Contact your account manager or Channel Executive to add AP Automation to your company if it isn't already.

After your company is enabled at the backend, read Set up AP Automation with Purchasingto learn how to configure your setup.

If you upload a supplier document, see it in Analyzing state in the list, and then it disappears, this means that the Supplier is set to always create AP AP purchase invoices from automated transactions.

Solution: You can find the transaction on the AP purchase invoices list. If you no longer want transactions from this supplier to be created as AP AP purchase invoices, learn how to remove the setting.

If AI/ML makes an incorrect prediction, you can change the transaction definition.

When you select Change to, the transaction definitions that appear in the list are those mapped for your entity, in the Purchasing configuration.

This can happen when the PO purchase invoice matches a source transaction that is mapped to a target transaction definition with restrictions.

Typically, this means that the transaction definition was created at the top level with some restrictions and your configuration does not override this mapping at the entity level.

For example, say you create a target transaction definition that is restricted for the Western region entity. When you set up the transaction definition mapping in the Purchasing configuration, if you do not provide specific mapping for the Western region entity, the entity inherits the mapping configuration from the top level.

When you later upload a supplier document that matches the source document mapping for the top level, Sage Intacct cannot create the PO purchase invoice using the target transaction that you mapped to the source. Instead, Intacct uses the PO-SYS Auto default transaction definition.

Learn how to update the transaction definition in this situation.

To change the transaction definition, the following must be true.

• The transaction must be in a draft state.
• The transaction must be created as an automated draft, not a manual draft.
• You must be in edit mode.

SYS-PO Automation is a placeholder transaction definition used by the Sage Intacct.

For transactions in a draft state, SYS-PO Automation indicates that you need update the transaction definition and the source match before you edit and post the transaction. Learn how to change the transaction definition.

For transactions in an Analyzing state, the placeholder only appears during transaction analysis and you can ignore it. Sage Intacct updates the transaction type when analysis is complete and the draft is created.

Depending on the configuration you chose during setup, Sage Intacct populates the draft PO purchase invoice either using AI/ML predictions or line items from the source purchasing transaction.

If you joined the Early Adopter program for line-level matching, AI/ML compares the PO purchase invoice with the source transaction and predicts matches. Lines that AI/ML determines are a near match are flagged in the Exception column, so that you can compare the item's quantity and price against the supplier document.

If you do not have line-level matching enabled, the draft PO purchase invoice is populated with line items from the source purchasing transaction. If the supplier invoiced you for different quantities or prices, or if they added additional items, you need to make corrections to the entries before you post.

This can happen in the following circumstance:

• AI/ML detects a purchase order number in the supplier document that can be matched to a source transaction.
• AI/ML cannot confidently match the line items in the supplier document to the source transaction.

In this case, rather than give you questionable data as a match, AI/ML leaves the line items empty.

To identify the line items that you need to add, refer to the supplier document attached to the PO purchase invoice.

Collapsing all line items into a single summarized total in Purchasing can impact inventory reporting. When using this feature, to optimize for AI accuracy and inventory reporting, we suggest only making changes to the predicted lines instead of deleting and adding rows.

After you create a new supplier, Sage Intacct updates the machine learning model with this information within 24 hours.

If you upload or email purchasing documents for the supplier before the daily update occurs, Intacct might not be able to match the supplier. However, when you submit new transactions on subsequent days, Intacct is much more likely to make an accurate match.

If your transaction was created using a transaction definition that has Allow edit of supplier set to Never, you cannot correct the supplier match made by AI/ML.

Typically, when you post a transaction after making corrections, AI/ML learns from your changes and uses that information to make better predictions in the future. However, if your configuration does not allow you to change the supplier, AI/ML has no updated information to use for supplier match predictions.

Solution: Your options are as follows.

• Delete the draft and create the transaction manually, without using automation.
• If you do not require Allow edit of supplier to be set to Never, change the setting to Always or Except converted document.
  
  Remove the transaction definition from the configuration before you can change the settings. You can restore the mapping after you save your changes.

Supplier match accuracy is impacted by two factors:

• How long you have been using automated transaction matching
• The quality of your supplier data

Time is a factor because Intacct uses machine learning to determine the most likely supplier record match for the PO purchase invoices you submit. To make predictions, machine learning observes your transactions patterns over time and uses that information to build a model.

This means that in the beginning, Intacct will not know the best predictions to make. As you continue to use the automated transaction matching, the predictions will improve. Given the many factors that can affect matches, such as the quality of scans and suppliers with similar names, you probably will not see 100% accuracy for supplier matching. However, you should notice a significant improvement over time.

The quality of your supplier data matters because if you have multiple supplier records with the same supplier name and the same address, Intacct does not know which supplier record to match. This, too, improves over time as machine learning determines which record you want.

When AP Automation with Purchasing is enabled, Smart Rules and Smart Events do not run on draft transactions until you submit or post.

This is true for any draft that you create in the Purchasing, Order Entry, or Inventory applications, even when the draft uses a transaction definition that is not mapped for automated transaction matching.

The Subtotals section does not appear when the supplier and all the items IDs are non-taxable.

When an uploaded document stays in the Analyzing state for more than 2 hours, Sage Intacct displays a Cancel link next to the PO purchase invoice, on the Automated transactions list.

You can allow Intacct to continue analyzing the file. Or, select Cancel to do the following:

• Stop analysis of the document.
• Create an empty draft transaction, with the document attached.

Once you cancel processing, you can enter transaction details directly, using the attached document as a reference.

If a PO purchase invoice has been matched to a source transaction, but you have not posted the PO purchase invoice, the source transaction status remains In Progress.

You can only convert a purchasing transaction that's Pending or Partially converted, which means that no other PO purchase invoice will be matched to that source transaction until you post the matched PO purchase invoice.

To resolve this, review and post the matched PO purchase invoice before uploading additional supplier documents that reference the same source purchasing transaction.

If you already uploaded the PO purchase invoices, post the matched PO purchase invoice and then manually select a Converted from transaction for the second PO purchase invoice.

PO purchase invoices created from documents that are emailed, rather than uploaded, are not associated with a user. As a result, they're shown in the audit trail as being created by the system.

The Upload and Refresh buttons appear on the Automated transactions page when you have Purchasing transactions: Add permissions.

If you're a user restricted to certain locations, you can upload documents at the entity level only.

Intacct reads attachments from the header of the email message, not the body. Email messages sent using Rich Text, a legacy format, add attachments as icons to the message body, instead of adding them to the message header. These attachments cannot be read by Intacct.

Solution: In your email application, make one of the following changes:

• Change your default message format to HTML.
• Change the format of the individual message to HTML when forwarding a PO purchase invoice.

When you delete an entity, the provisioned mailbox is deactivated. When you create a new entity, Intacct provisions a new email address with a unique address. To do this, Intacct appends _2 after the entity ID.

For example, say that your company ID is examplecorp and your entity ID is E100. Intacct provisions a mailbox for that entity with the address examplecorpe100@sagemail.com.

When you delete the NA entity, Intacct removes examplecorpe100@sagemail.com. When you create a new entity and give it the same entity ID of NA, Intacct provisions a new mailbox with the address examplecorpe100_2@sagemail.com.

If you repeat this process, deleting the entity and creating a new one with the same entity ID, Intacct provisions a new mailbox and increments the number, like this: examplecorpe100_3@sagemail.com.

When you deactivate an entity, Intacct does not delete the associated mailbox. If you or a vendor forwards PO purchase invoices to the mailbox, the system will create draft transactions, but you will not be able to take action on them while the entity is inactive.

Before deactivating an entity, notify any suppliers who regularly forward PO purchase invoices to the mailbox that the email address is no longer monitored.

See Inactivate or delete an entity for more information.

Import exceptions alerts you to issues found when the emailed or uploaded document was processed. For example, a duplicate PO purchase invoice or unreadable file.

In cases where Intacct cannot capture some or all of the PO purchase invoice information, you can fill in the details yourself, using the attachment as a reference. If the attachment is unreadable, submit a new file or ask the supplier to resend the PO purchase invoice.

When you edit or view a draft that has an import exception, a more detailed exception message appears. The import exception clears once you save, post, or submit the transaction.

Potential import exceptions are as follows:

To determine if an uploaded or emailed document is a duplicate, Sage Intacct compares the file you submit to previously uploaded and emailed files, for the same entity. The following are potential scenarios where a duplicate PO purchase invoice might not be identified as a duplicate:

• The file image is not identical to the previously submitted PO purchase invoice.

  If a PO purchase invoice was mistakenly scanned twice, and the scans are different, the system might not identify the duplicate.

• The duplicate files were submitted to different entities and not to the top level.

  If you uploaded the PO purchase invoice to 2 different entities, or emailed them to the addresses for two different entities, the system will not compare the PO purchase invoices.

• The duplicate documents were submitted simultaneously.

  If you submit a batch of PO purchase invoices that includes duplicates, the duplicates might be processed simultaneously. If the PO purchase invoices are analyzed at the same time, Sage Intacct will not have a completed draft to use for comparison. To avoid this situation, check your attachment list for duplicate file names before forwarding a batch of PO purchase invoices.

When you edit a transaction definition that you're currently using for AP Automation with Purchasing, you need to maintain the required settings. To learn more about these settings, read Modify transaction definitions for use with AP Automation with Purchasing.

Before you can delete a transaction definition that you are currently using for automated transaction matching, you need to remove it from the configuration. After you remove it, incoming PO purchase invoices can no longer be matched to existing source transactions that use the deleted transaction.

You cannot change the Can be created from value while a transaction definition that is being used for AP Automation with Purchasing. To change this field, you need to remove the transaction definition from the mapping table and save your configuration.