With the Payables Transaction Import definition created, we can now use it to import some transactions. I have the template populated with two lines, both of which are for the same invoice.
The import will group together header fields which are the same so that the tax and distributions are included on the same transaction. In this case, I have two sets of tax and two distributions going to different accounts. The integration will create me a single tax entry as the Tax Details are the same and two separate PURCH distribution rows.
The Doc Type field should be set to one of the following numeric identifiers:
- Finance Charge
- Misc. Charge
- Credit Memo
Once the data has been prepared, open the Payables Transaction Import window () and select the required Definition ID.
Enter the Batch Number (if the batch doesn’t exist, you’ll be prompted to create it) and use the browse button to select the file to import.
Click the Redisplay button on the action pane to load the file and display the invoices to be created:
The chevrons at the end can be clicked to fold open the scrolling window and view any error messages produced; the expansion button next to the Document Number can be used to preview the tax and account distributions to be created.
When ready, click the Process button to create the invoices (any showing an error will be ignored). Once the import is complete, a dialog will be displayed showing the number of transactions successfully created:
The transactions will now be in Microsoft Dynamics GP on the selected batch ready for processing as normal: