...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
This function only allows users to enter the amount, whereas, Upload Supplier Listing only imports the existing supplier information
...
- 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
Data
...
Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code"
...
Refer to system supplier account PKID (auto-generated)
...
Example:
...
- 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
- Select a Branch and click ‘Change Branch’.
- Click ‘Supplier’ to search and click Submit.
- Other Details
- Enter Please follow the steps on Create Supplier Invoice
- Enter the Old Reference number – from previous accounting software
- Remarks
- Date – date before EMP is adopted or follow the previous 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 Add GL Code : Select GL Code: purchasespurchases
Notes:
- Opening balances can only need be entered entered one by one for each supplier.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.
STEP 2
CLEAR One Time Supplier Outstanding Amount
1.Create Supplier Invoice
Menu Path: Supplier > Credit Memo > Create
Data:
Supplier : 1 One Time Supplier
Date: before financial year
Remarks: Clear Opening Outstanding
GL code: Purchases
Credit: total outstanding amount
Tax Code: blank
2. Contra Supplier Credit Memo with Supplier Invoice
...
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
3.Remove journal created from CM
...
- 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
