• When migrating to EMP, this function is needed to transfer the opening balance (

• DEBIT) to EMP.
• This

• function transfers the amount owed to / owed by the customer.
• The opening balances are best brought forward immediately after the EMP is adopted.

User upload template file settings
1. Template file deliminitar can be selected in different formats.
2. Template file headers can be customized based on need.
3. Upload the file with header

fill in information in excel format (refer Upload Customer Opening Template)
Notes:

Field NameRemarksBRANCH_CODERefer to Control Panel > Developer > Branch Listing > Branch CodeCUSTOMER_IDRefer to system customer account PKID (auto-generated)SALESMANfollow Invoice Salesman, the name as USER NAME in system (Refer to Control Panel > System Admin > Manage User > User Listing)INVOICE_DATEfollow outstanding invoice date (before start Wavelet Txn, date format: YYYY-MM-DD)REFERENCEOutstanding Invoice number/referenceITEM_CODEOPENING-BALANCE (make sure that item type is "Service Type" and MA cost = RM 0)UNIT_PRICEInvoice outstanding Amount (AMOUNT INCLUSIVE OF GST)ITEM QTY1TAX CODECompulsory, for GST Code (SR, ZRL, ZRE, DS, OS, ES, AJS), if no gst amount recored, please leave EMPTY, system will prompt "Error Message", please click "Continue" to proceed (Refer to TERMSinvoice terms (Optional)TAX_AMT(IF TAX_AMT is not specified, system will automatically calculate the GST amount based on Tax Code provided. In the event Tax Code is not available in the system, system give the error message)TAX_RATE0 or 0.06

Important Notes: If the EMP OUTPUT TAX Configuration is Exclusive method, the UNIT_PRICE also Exclusive; This upload also checking the "Five Cent Concept" Configuration

Example:

ExampleUNIT_PRICETAX_CODETAX_AMTTAX_RATEResultCustomer Outstanding Invoice AmountTax amountRemarksE01530SR53030Use this method if the full outstanding amount all SR codeE02530ZRE5300.00Use this method if the full outstanding amount is ZRE codeE03530.60SR30.60530.6030.60System record Tax Amount 30.60E045305300.00Empty all the GST infor, to record the outstanding invoice before 1 April 2015EMP Cofig.:Output TaxInclusiveInclusiveExclusiveExclusiveEMP Cofig.:Five Cent ConceptDisableEnableEnableDisableAmount before Tax0.830.850.900.88Tax Amount0.050.050.050.05Amount After Tax0.880.900.950.93Journal: generalSales0.830.830.880.88Journal: roundingnil0.020.02nil

* Highlight in PINK is the default configuration

Save in csv. file 
M.Excel : CSV (Comma Delimited)
Image Removed
 or
• Open Office: CSV file filter settings:
  1) Field Deliminater: |
  2) Text Deliminater: blank
  (Use the | character to separate columns).
• Menu Path : Trading > Sales > Upload Invoice
  Image Removed
  Image RemovedMake sure that you have already imported the customer code first. Refer to Importing Customer Records

Method 1: UPLOAD FUNCTION

Menu Path: Trading > Sales > Upload Invoice

• Follow the Step 1 - 4 on UPLOAD INVOICE
• Advisable to use OPEN OFFICE when fill up the data and separate the file into multiple CSV file to shorten the upload time consume
• Please make sure the date on Upload Template is BEFORE FIRST EMP FINANCIAL YEAR

Sample of Error Message:

Error 1: "The following item do not have TAX_CODE. If you wish to continue, click Continue. System will update without further verification"

Image Removed

Image Removed

Image Removed

Image Removed

Image Added

Image Added

• If this situation happen, please verify and correct the error eg: in the above case, put the correct TAX_CODE in the file
• After editing the file, please reupload the file

Image Added

• If this situation happen, please verify and correct the error eg: in the above case, put the correct Date Format in the file
• After editing the file, please reupload the file

Image Added

• If this situation happen, please verify and correct the error eg: in the above case, put the correct Word Format in the file
• After editing the file, please reupload the file

1. Select a branch and click ‘Change Branch’.
2. Search a customer name under ‘Billing Account’ by clicking ‘Select Customer’.

Enter :

1. Key In Old Reference Number from previous system, Remarks, Salesman and Outstanding Balance Amount (The amount outstanding can be obtained from your old system’s Outstanding Debtors for individual customers

1. )
2. Key In Date → BEFORE FIRST EMP FINANCIAL YEAR
3. Click "ADD INVOICE"
4. A ‘List of Outstanding Documents to be Settled’ will show the opening balance at the bottom.
5. Click

Image Removed

1. "CONFIRM and SAVE"

Image Added

Notes:

• For negative amount (sales return / refund), remember to use a credit memoCredit Memo instead to create a debit note for the customer.

Debit: cashDiscount RM XXX
Credit: accReceivable RM XXX

• Opening balances can only need be entered one by one for each customer.

FINAL STEP: Remove Journal Transactions

Menu Path: Accounting > Maintenance > Configuration > Set Opening Balance

Image Added

• Remove Journal Transaction before financial year (Invoice journal created above)
• Perform Stock Adjustment to item OPENING-BALANCE to off-set the negative (-) quantity and inactive the codeRemove Journal Transaction before financial year (Invoice journal created above)
  Menu Path: Accounting > Maintenance > Configuration > Set Opening Balance : Select & Set company > click "Yes, remove the transaction below"

Image Removed

** Report checking:

Customer > Query/Report > Historical AR Balance 
Customer > Tasks > AR 
Trading > Sales > Invoice Listing*

*