...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
- 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:
...
- fill in information in excel format (refer file attached: Upload Customer Opening Balance = Upload Invoice)
Notes:
1. Branch: Actual Branch
2. Customer: Actual Customer/EMP Customer PKID
3. Date: follow outstanding invoice date (before start Wavelet Txn)
4. Item code: OPENING-BALANCE (Makesure that item type is "Service Type" and MA cost = RM 0)
5. Qty: 1
6. Reference: Old Invoice number
7. Price: Follow Invoice outstanding price
- 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
...
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
- 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)
Accounting > Maintenance > Configuration > Set Opening Balance : Select & Set company > click "Yes, remove the transaction below"
** 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)
Upload Customer Opening Balance.ods (13.2 kB)
Upload Customer Opening Balance.xls (20.5 kB)
...