Upon adopting EMP for the first time, users will need to bring forward any outstanding balances from suppliers’ accounts from the previous accounting system.
This function only allows users to enter the amount, whereas, Upload Supplier Listing only imports the existing supplier information
Method 1: Upload excel file
- User upload template file settings
1. Template file deliminitar on Save in Pipe (|) format
2. Must follow the format, with EOR
3. Upload the file without header
- fill in information in excel format (refer Upload Supplier Invoice_Opening.xlsx (16.6 kB))
Notes:
| Field Name | Remarks |
|---|---|
| Branch Code | Refer to Control Panel > Developer > Branch Listing > Branch Code |
| Supplier ID | Refer to system supplier account PKID (auto-generated) |
| Reference # | Outstanding Invoice number |
| Remarks | |
| GL Dimension ID (Header) | Leave it Empty if no data |
| GL Dimension Code (Header) | Leave it Empty if no data |
| SINV Date | follow outstanding invoice date (before start Wavelet Txn; date format: YYYY-MM-DD) |
| Due Date | Leave it Empty if no data |
| GL Short Hand | purchases |
| Item Reference No | Outstanding Invoice number |
| Item Remarks | |
| GL Dimension ID (Item) | Leave it Empty if no data |
| GL Dimension Code (Item) | Leave it Empty if no data |
| Debit | Invoice outstanding Amount (AMOUNT INCLUSIVE OF GST) |
| Tax Code | for GST Code (TX, NR, BL, OP, IM) |
| Tax Type | GST-MY INPUT |
| Tax Rate | 0 or 0.06 |
| String | Record Terminator - Must Key IN EOR |
Example:
| Example | Debit | TAX_CODE | TAX_RATE | Result | Supplier Outstanding Invoice Amount | Tax amount | Remarks |
|---|---|---|---|---|---|---|---|
| E01 | 530 | TX | 0.06 | 530 | 30 | Use this method if the full outstanding amount all TX code | |
| E02 | 1000 | IM | 0 | 1000 | 0.00 | Use this method if the full outstanding amount is IM code | |
| E03 | 1000 | TX | 1000 | 56.60 | System record Tax Amount 56.60 | ||
| E04 | 530 | 530 | 0.00 | Empty all the GST infor, to record the outstanding invoice before 1 April 2015 |
Menu Path: Supplier > Supplier Invoice > Upload Supplier Invoice
- Save in csv. file
Open Office: CSV file filter settings:
1) Field Deliminater: |
2) Text Deliminater: blank
(Use the | character to separate columns).
Method 2: Add manually
Menu Path: Supplier > Maintenance > Supplier Invoice > Supplier Invoice Create
- Select a Branch and click ‘Change Branch’.
- Click ‘Supplier’ to search and click Submit.
- Other Details
- Enter Old Reference number – from previous accounting software
- Remarks
- Date – date before EMP is adopted or follow the previous GRN date
- Outstanding amount – The amount outstanding can be obtained from your old system’s Outstanding Creditors for individual suppliers.
- Add GL Code : Select GL Code: purchases
- Opening balances can only be entered one by one for each supplier.
- Please make sure that after adding up the outstanding supplier invoices, the total equals to the Accounts Payable in Balance Sheet as at that the date before EMP was used.
STEP 2
CLEAR One Time Supplier Outstanding Amount
1.Create Supplier Invoice
Menu Path: Supplier > Credit Memo > Create
Data:
Supplier : 1 One Time Supplier
Date: before financial year
Remarks: Clear Opening Outstanding
GL code: Purchases
Credit: total outstanding amount
Tax Code: blank
2. Contra Supplier Credit Memo with Supplier Invoice
Menu Path: Supplier > Credit Memo > Credit Memo Contra
3.Remove journal created from CM
Menu Path: Accoutning > Maintenance > Configuration > Set Opening Balance
