...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
en Menu Path: Trading > Sales > Upload Invoice
| Panel |
|---|
Opening Account ReceivableWhen 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
...
GO Trading > Sale > Upload invoice
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.
...
Appendix
...
No
...
Field Name
...
Data Type
...
Remarks
...
1
...
BRANCH_CODE
...
String with Maximum (50) Characters
...
Compulsory
...
2
...
...
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
...
- Go to Customer > Maintenance > Opening Balance