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;
- Attached with the ' Download template file:UploadInvoiceTemplate2015-02-09.csv'. This excel file contains upload file format as below:
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
- Go to Customer > Maintenance > Opening Balance