Financial Elementz includes a Payables Transaction import which can be used to load the following transaction types into Payables Management:
- Finance Charge
- Misc. Charge
- Credit Memo
The import uses an Excel spreadsheet as the data source, which the user can select at runtime, but the format of the file needs to be defined in advance; the import supports the creation of multiple import definitions so that, if required, each supplier providing invoices electronically could do so including different columns and in a different order.
The format I will use is shown below:
As you can see, the Doc Type is using the numeric identifier for the document types listed above; I’ve not included all of the supported fields on the file such as Currency ID or the Analytical Accounting information.
To create the import definition, open the Payables Transaction Import window ()Purchasing area page » Transactions » Financial Elementz » Payables Transaction Import[/gmenu], enter the new Definition ID and tab from the field; when prompted, click Yes to create the new definition:
Enter the Description, First Row (containing data after the header row(s)) and the Excel column letter into the relevant field to complete the mapping:
The fields in bold in the above screenshot are mandatory and must be supplied; not all of the columns needs to be entered and the mapping does not need to be in the same order as the excel spreadsheet. With the mapping complete, click Save to save the definition. With that done the definition is available for all users with access to the Payables transaction Import window to use.