- 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 excel file- fill in information in excel format (refer file attached: Upload Customer Opening Balance = Upload Invoice)
Notes:
1. BRANCH CODE: Refer to Control Panel > Developer > Branch Listing > Branch Code
2. CUSTOMER ID: Refer to system customer account PKID (auto-generated)
7. SALESMAN: follow Invoice Salesman, the name as USER NAME in system
3. INVOICE DATE: follow outstanding invoice date (before start Wavelet Txn, date format: YYYY-MM-DD)
6. REFERENCE: Outstanding Invoice number
4. ITEM CODE: OPENING-BALANCE (Makesure that item type is "Service Type" and MA cost = RM 0) - 9. UNIT PRICE: Follow Invoice outstanding price (AMOUNT INCLUSIVE OF GST)
5. ITEM QTY: 1
10.TAX CODE: Compulsory, for GST Code (SR, ZRL, ZRE, DS, OS, ES, AJS,......)
8. TERMS: invoice TERMS
11. TAX_AMT (IF TAX_AMT is not specified, system will automatically calculate the GST amount based on Tax Code provided. In the event Tax Code is not available in the system ..... )
12. TAX_RATE
- save in csv. file
CSV file filter settings:
1) Field Deliminater: |
2) Text Deliminater: blank
(Use the | character to separate columns).
- Trading > Sales > Upload Invoice
Method 2: add manually
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’.
Enter :
- 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
- After importing the customer records, you can resume to this function as the customer records will already exist in the system, allowing user to ‘Select Customer’.
- 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
- Remove Journal Transaction before financial year (Invoice journal created above)
** Report checking:
Customer > Query/Report > Historical AR Balance
Customer > Tasks > AR
Trading > Sales > Invoice Listing*
Related
cust-op-bal.jpg (56 kB) 
Upload Invoice.jpg (253.3 kB)
Upload invoice_save.jpg (202.4 kB)
upload inv_success.jpg (56.5 kB)
remove jtxn.jpg (140.3 kB)