Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

  • 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 

 

  1. 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.

  2. 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:


  3. 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

     

  4. 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


 

 

  • No labels

Private & Confidential