Page Comparison

When shifting to EMP for the first time from your previous accounting system, this function is needed to transfer the opening balance (debit / credit) to EMP. This is very different from Upload Customer List because instead of transferring customer details such as company name, address and contact number, this function transfers the amount owed to / owed by the customer. The opening balances are best brought forward immediately after the EMP is adopted.

Method 1: Upload excel file

• 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
  
  
  Image Modified

• Customer > Maintenance > Opening Balance
• Select a branch and click ‘Change Branch’.
• Search a customer name under ‘Billing Account’ by clicking ‘Select Customer’.

Enter :

• old reference number from the previous system (if necessary)
• remarks, date – date before EMP is adopted
• salesman
• outstanding amount balance – The amount outstanding can be obtained from your old system’s Outstanding Debtors for individual customers.

• Then, click ‘Add Invoice’.
• Click ‘Reset’ or ‘Reset Form’ if needed.
• A ‘List of Outstanding Documents to be Settled’ will show the opening balance at the bottom.
• Click ‘Remove’ to delete the transaction.
• Finally, click ‘Confirm and Save’.

Image Modified

• For negative 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 can only be entered one by one for each customer.

• 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"

Image Modified

** Report checking:

Customer > Query/Report > Historical AR Balance 
Customer > Tasks > AR 
Trading > Sales > Invoice Listing*

• Related: Opening Stock / AR / AP.*