Debtors Journal Transactions Import
Print / Import function
This function allows you to print existing debtor/customer journal transactions and import new journals to the system.
Import clone refers to loading an existing debtor from the system. All you need to do is make changes as per current journal.
Debtors Module >Activity > Debtors Transactions > Print /Import
.png)
Print option will take you to print the selected debtors transaction.
.png)
Import takes you to the option of bringing in data from a saved csv file
.png)
See the process of importing a debtor/ customer journal transaction into the system:
- Click Select
- Upload
- After, uploading the CSV file the import button will open allowing you to import the file into the system
- Once, complete click close
Important CSV File notes and format tips:
- The file must be saved as a CSV
- Don't put commas in your file
- Fields for values mostly require codes of those fields
- The date format must be 2020/01/01 YYYY/MM/DD
- The column headings can be left in the import file.
See the file Layout for CSV file:
|
1 |
AccountCode |
Required |
|
2 |
Date |
Required |
|
3 |
Reference |
Required |
|
4 |
Description |
Required |
|
5 |
Amount Inc Vat |
Required |
|
6 |
ExchangeRate |
Required (Default 1) |
|
7 |
Action |
Required |
|
8 |
TaxType |
|
|
9 |
AutoAllocate |
1/0 |
|
10 |
CheckZero |
1/0 |
|
11 |
Division |
|
|
12 |
Region |
|
|
13 |
GL Account |
Required |