To import transactions, please download the template .
The template has an example line added to help you. Please remove these entries and use details specific to your company for your testing.
A few rules to bear in mind when using this template:
No Commas or semi colons anywhere, including when formatting numbers
Column A defines either sales or purchase ledger (enter an S or P) Import 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 and to a location easy to upload from.
To use this template you must navigate from your toolbar to:
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. Your transactions will import, if transactions are rejected ensure all of the above settings are correct