Please ensure all data meets the required format before importing to avoid errors.
Important Notes
All dates must be in DD/MM/YYYY format.
For Payment to Supplier / Receipt from Customer:
Open Item Creditor/Debtor → Bill Age = 11
Non-Open Item Creditor/Debtor → Bill Age = 0
bperiod and vperiod must match the fperiod.
Remove the first line in the Excel file before importing.
Step 1: Perform Setup
Go to Periodic > Export/Import > E.I. Housekeeping.
Set the Sub-Directory for ***9.CSV.
Click Exit after completing the setup.
Step 2: Import from CSV
Go to Periodic > Export/Import > Import from CSV File.
Select 1. IMPORT FROM ………….
Click OK.
Fill in all required details.
Click Verify and ensure:
Transactions to be imported are correct.
Transactions already in the batch are correct.
Click Import.
Click Yes when prompted “Are you sure?”
Click Yes again to confirm.
Step 3: Export from CSV
Go to Periodic > Export/Import > Export from CSV File.
Select 1. COPY GLPOST.DBF TO ………….
Click OK.
Click Yes when the system prompts “Are you sure?”
Click Yes again to confirm.