- Remove Journal Transaction before financial year (Invoice journal created above)
en 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
Method 2: Add manually
Method 1: Upload excel file Upload File Sample
GO Trading > Sale > Upload invoice
Upload Customer Invoice User Guide
The Upload Invoice screen is used to bring in a list of Customers Invoices into the Wavelet ERP System.
Click on the “Upload Customer Invoice Template” link as shown below to download the template.
Attached with the ''Upload Customer Invoice Template'': Upload_Customer_Invoice_User_Guide (1).doc' .This word file will guide user how to upload invoice step by step.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.
Appendix
No
Field Name
Data Type
Remarks
1
BRANCH_CODE
String with Maximum (50) Characters
Compulsory
2
CUSTOMER_ID
Integer
Compulsory
3
INVOICE_DATE
String in the following format (yyyy-mm-dd)
Compulsory
4
ITEM_CODE
String with Maximum (100) Characters
Compulsory
5
ITEM_QTY
Integer
Compulsory
6
REFERENCE
String with Maximum (100) Characters
Compulsory
7
SALESMAN
String with Maximum (100) Characters
Compulsory
8
UNIT_PRICE
Floating Point Number
Compulsory
9
BATCH_NUMBER
String
Compulsory if item is Batch Expiry Item
10
EXPIRY_DATE
String in the following format (yyyy-mm-dd)
Compulsory if item is Batch Expiry Item
11
ITEM_SERIAL
String
Compulsory if item is serialized
12
GL_DIMENSION_CODE
String with Maximum (50) Characters
13
GL_DIMENSION_ID
Integer
14
GUID_CODE
String with Maximum (50) Characters
15
ITEM_NAME
String with Maximum (1000) Characters
16
ITEM_REMARKS
String with Maximum (3000) Characters
17
REMARKS
String with Maximum (300) Characters
18
SUPPLIER_ID
Integer
19
TERMS
Integer
20
UNIT_DISCOUNT
Floating Point Number
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
- 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’.
- For negative amount (sales return / refund), remember to use a credit memo instead to create a debit note for the customer.
- 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.
- Please read Opening Stock / AR / AP.