Importing total amounts and total tax amounts in Dynamics 365 for Finance and Operations
Dynamics 365 Finance and Operations 10.0.16 introduced two new fields on the invoice header that allow AP automation providers to pass along the invoice total amount and the total sales tax amount. However, the standard mapping from Kofax AP Essentials to Dynamics 365 Finance & Operations does not import any amounts to the vendor invoice header. To import these new fields, you must create a new import job that contains the new fields in the uploaded zipped manifest.
- Download d365-import-data-template.zip file and extract its contents.
Vendor invoice header.xml in a text editor and add these fields to the
<IMPORTEDAMOUNT /> <IMPORTEDSALESTAX />
- Create a new ZIP file containing all the files previously unzipped, including the edited header manifest.
- Edit the existing import job in Dynamics, or create a new job using the newly created ZIP file.
AP Essentials Admin Center
target system settings, edit the
Custom field mapping setting to include the new fields. For example:
IMPORTEDAMOUNT="%InvoiceTotalVatIncludedAmount%";IMPORTEDSALESTAX="%InvoiceTotalVATAmount%";INVOICEDESCRIPTION="Sent from Kofax AP Essentials"