Download the template to import transactions. The template includes an example line — remove these entries and add your own data for testing. Keep the following rules in mind when using the template:
No commas or semi-colons anywhere, including when formatting numbers.
Column A defines either the sales or purchase ledger (enter an S or P). Imports cannot be mixed ledgers.
Column R relates to a project you want that line of nominal analysis linking to.
Column S relates to the path to a document you want archiving against the transaction.
For Purchase ledger:
Column G relates to the 'Transaction Reference' box seen on PL transactions.
Column H relates to the 'Purchase Order Number' box seen on PL transactions.
Column I relates to the 'Their Reference' box seen on PL transactions.
For PL imports, the data will be grouped by TheirReference.
For Sales ledger:
Column G relates to the 'Transaction Reference' box seen on SL transactions.
Column H relates to the 'Sales Order Number' box seen on SL transactions.
Column I relates to the 'Their Reference' box seen on SL transactions.
For SL imports, the data will be grouped by OurReference.
When complete, save the spreadsheet in CSV format. Then follow these steps to set up the import:
Click System Admin, External Interfaces.
Click Interface Control Panel.
Right-click and select Create Record.
Create a new Interface Control Source ID with any name.
Set Bespoke Translations to Yes.
The **Using Set** field must say **STANDARD**.
The Import File Path Number field should have a path number entered as 251 as it is the Standard CSV Import path.
This path should point to the folder where the CSV file to be imported is to be found. Whatever you enter should end in a \ (slash).
The Re Name To Path Number can optionally also be populated. If so the file will be moved here after import.
Enter the file name to be imported in either the Sales Transaction or Purchase Transaction field. There can only be:
one ledger type per import.
one transaction type per import.
Data for multiple companies can be included in one import, separated by the CompanyCode in column P.
For multiple company imports an interface source with a Using Set of STANDARD must exist in each company. Remember that each InterfaceSourceID must be unique.
To actually use the import:
From the Interface Control Panel SourceID you have created, select the Manual Batches tab.
Right-click and select Import External Files.
Browse to the path of the file you wish to import, select the CSV File.
Right-click and select **Initiate Sales Transaction** or **Initiate Purchase Transaction**. If transactions are rejected, check all the settings above are correct.