Upload Invoice > Customer/Debtor Opening

Owned by l (Unlicensed)
Last updated: 2017-Aug-24 by Jia Pei Chan
2 min read

Menu Path: Trading > Sales > Upload Invoice

Opening Account Receivable

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. There are two method to upload invoice.

  • Method 1: Upload excel file within this function
  • Method 2: Upload manually within Customer module

Method 1: Upload excel file 

  • Click on 'Upload Customer Invoice User Guide' to get the user guide. The Upload Invoice screen is used to bring in a list of Customers Invoices into the Wavelet ERP System;

    • This word file will guide user how to upload invoice step by step

  • Click on the “Upload Customer Invoice Template” link as shown below to download the template;

  • Click ''Download template file'' to download;

  • Key in in the Customer Invoice details that you wish to bring into the system into the template. Kindly refer to Appendix section if unclear on the data format.

  • After fill in the information, you may then upload the Customers Invoice by following steps below

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

Method 2: add manually 


Private & Confidential