• This function transfers the amount owed to / owed by the customer
• The opening balances are best brought forward immediately after the EMP is adopted.
• Make sure that you have already imported the customer code first. Refer to Importing Supplier Account

Method 1: UPLOAD FUNCTION

Menu Path: Supplier > Supplier Invoice > Upload Supplier Invoice

• Follow the Step 1 - 4 on UPLOAD SUPPLIER INVOICE
• Advisable to use OPEN OFFICE when fill up the data and separate the file into multiple CSV file to shorten the upload time consume
• Please make sure the date on Upload Template is BEFORE FIRST EMP FINANCIAL YEAR or Follow the GRN date

Method 2: Manual Supplier Invoice

Menu Path: Supplier > Maintenance > Supplier Invoice > Supplier Invoice Create

• Please follow the steps on Create Supplier Invoice
• Enter the Old Reference number – from previous accounting software
• Key In Date BEFORE FIRST EMP FINANCIAL YEAR or Follow the GRN date
• Key in the Outstanding amount – The amount outstanding can be obtained from your old system’s Outstanding Creditors for individual suppliers.
• Add GL Code : purchases

Notes:

• Opening balances need be entered one by one for each customer
• Please make sure that after adding up the outstanding supplier invoices, the total equals to the Accounts Payable in Balance Sheet as at that the date before EMP was used.

FINAL STEP: 

• After Supplier Invoice before first EMP financial Year created, there are two steps need to be done

Step 1: Create Supplier Credit Memo

Menu Path: Supplier > Credit Memo > Credit Memo Contra

• After Supplier CM created → please contra with the Supplier Invoice from One Time Supplier

Step 2: Remove Journal Transactions

Menu Path: Accounting > Maintenance > Configuration > Set Opening Balance

Related Wiki Pages: