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

debit

DEBIT) 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.

Method 1: Upload excel file

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 Name

Remarks

BRANCH_CODE

Refer to Control Panel > Developer > Branch Listing > Branch Code

CUSTOMER_ID

Refer to system customer account PKID (auto-generated)

SALESMAN

follow Invoice Salesman, the name as USER NAME in system (Refer to Control Panel > System Admin > Manage User > User Listing)

INVOICE_DATE

follow outstanding invoice date (before start Wavelet Txn, date format:

YYYY-MM-DD

)

REFERENCE

Outstanding Invoice number/reference

ITEM_CODE

OPENING-BALANCE (make sure that item type is "Service Type" and

MA cost = RM 0)

UNIT_PRICE

Invoice outstanding Amount (AMOUNT INCLUSIVE OF GST)

ITEM QTY

1

TAX CODE

Compulsory, 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

TERMS

invoice 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_RATE

0 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:

Example

UNIT_PRICE

TAX_CODE

TAX_AMT

TAX_RATE

Result

Customer Outstanding Invoice Amount

Tax amount

Remarks

E01

530

SR

530

30

Use this method if the full outstanding amount all SR code

E02

530

ZRE

530

0.00

Use this method if the full outstanding amount is ZRE code

E03

530.60

SR

30.60

530.60

30.60

System record Tax Amount 30.60

E04

530

0.00

Empty all the GST infor, to record the outstanding invoice before 1 April 2015

EMP Cofig.:Output Tax

Inclusive

Exclusive

EMP Cofig.:Five Cent Concept

Disable

Enable

Disable

Amount before Tax

0.83

0.85

0.90

0.88

Tax Amount

0.05

Amount After Tax

0.88

0.90

0.95

0.93

Journal: generalSales

0.83

0.88

Journal: rounding

nil

0.02

nil

* 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 : Make 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

Image Removed

Image Removed

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

Method 2: add manually

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

Method 2: Manual Customer Invoice

Menu Path: Customer > Maintenance > Opening Balance

Image Added

old reference number from the previous system (if necessary)

remarks, date – date before EMP is adopted

salesman

outstanding amount balance –

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

Enter :

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

.

Then, click ‘Add Invoice’.

Click ‘Reset’ or ‘Reset Form’ if needed.

)
Key In Date → BEFORE FIRST EMP FINANCIAL YEAR
Click "ADD INVOICE"
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’.

Image Removed

For negative amount

"CONFIRM and SAVE"

Image Added

Notes:

For Credit amount (sales return / refund), remember to use a

credit memo

Credit Memo instead to create a debit note for the customer.

Debit: cashDiscount RM XXX
Credit: accReceivable RM XXX

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

need be entered one by one for each customer

.Lastly:

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 code

Remove 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*

cust-op-bal.jpg (56 kB) Image Removed Ratna Rozana, 2012-08-01 06:33 AM

Upload Invoice.jpg (253.3 kB) Image Removed Jia Pei Chan, 2013-06-23 04:54 PM

Upload invoice_save.jpg (202.4 kB) Image Removed Jia Pei Chan, 2013-06-23 04:54 PM

upload inv_success.jpg (56.5 kB) Image Removed Jia Pei Chan, 2013-06-23 04:54 PM

remove jtxn.jpg (140.3 kB) Image Removed Jia Pei Chan, 2013-06-23 04:54 PM

...

Wiki Pages:

Panel

Search Results

spacekey	WMS
maxLimit	5
query	Customer Opening Balance
type	page

Also available in: PDF HTML TXT

Version	Old Version 19	New Version Current
Changes made by	Jia Pei Chan	Gracia Surialim
Saved on	2016-Aug-05	2019-Jan-25

Page Comparison

Versions Compared

Key

Method 1: UPLOAD FUNCTION

Method 2: Manual Customer Invoice

FINAL STEP: Remove Journal Transactions