Opening Account Receivable
- When migrating to EMP, this function is needed to transfer the opening balance (DEBIT) to EMP.
- 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 Customer Records
Method 1: UPLOAD FUNCTION
Menu Path: Trading > Sales > Upload Invoice
- Follow the Step 1 - 4 on UPLOAD 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
Sample of Error Message:
"The following item do not have TAX_CODE. If you wish to continue, click Continue. System will update without further verification"
- If this situation happen, please verify and correct the error eg: in the above case, put the correct TAX_CODE in the file
- After editing the file, please reupload the file
- If this situation happen, please verify and correct the error eg: in the above case, put the correct Date Format in the file
- After editing the file, please reupload the file
- If this situation happen, please verify and correct the error eg: in the above case, put the correct Word Format in the file
- After editing the file, please reupload the file
Method 2: Manual Customer Invoice
Menu Path: Customer > Maintenance > Opening Balance
- Select a branch and click ‘Change Branch’.
- Search a customer name under ‘Billing Account’ by clicking ‘Select Customer’.
- Key In Old Reference Number from previous system, Remarks, Salesman and Outstanding Balance Amount (The amount outstanding can be obtained from your old system’s Outstanding Debtors for individual customers)
- Key In Date → BEFORE FIRST EMP FINANCIAL YEAR
- Click "ADD INVOICE"
- A ‘List of Outstanding Documents to be Settled’ will show the opening balance at the bottom.
- Click "CONFIRM and SAVE"
Notes:
- For Credit amount (sales return / refund), remember to use a Credit Memo instead to create a debit note for the customer.
Debit: cashDiscount RM XXX
Credit: accReceivable RM XXX
- Opening balances need be entered one by one for each customer
FINAL STEP: Remove Journal Transactions
Menu Path: Accounting > Maintenance > Configuration > Set Opening Balance
- Remove Journal Transaction before financial year (Invoice journal created above)
- Perform Stock Adjustment to item OPENING-BALANCE to off-set the negative (-) quantity and inactive the code
** Report checking:
Customer > Query/Report > Historical AR Balance
Customer > Tasks > AR
Trading > Sales > Invoice Listing*
Related Wiki Pages:
Found 5 search result(s) for Customer Opening Balance.
Private & Confidential