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
Menu Path: Supplier > Supplier Invoice > Upload Supplier Invoice
Data
| No | Field Name | Data Type | Remarks | Where to Find / Description | Sample Data |
|---|---|---|---|---|---|
| 1 | BRANCH_CODE | String with Maximum (50) Characters | Compulsory | Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code" | A Co.-B1 |
| 2 | DEBIT | Floating Point Number | Compulsory | 100.00 | |
| 3 | GL_SHORT_HAND | String with Maximum (50) Characters | Compulsory | relevant gl short hand, will be deleted | purchases |
| 4 | REFERENCE_NO | String with Maximum (100) Characters | Compulsory | Outstanding Invoice number | |
| 5 | SINV_DATE | String in the following format (yyyy-mm-dd) | Compulsory | follow outstanding invoice date | |
| 6 | SUPPLIER_ID | Integer | Compulsory | Refer to system supplier account PKID (auto-generated) | |
| 7 | DUE_DATE | String in the following format (yyyy-mm-dd) | |||
| 8 | GL_DIMENSION_CODE | String with Maximum (50) Characters | |||
| 9 | GL_DIMENSION_CODE_ITEM | String with Maximum (50) Characters | |||
| 10 | GL_DIMENSION_ID | Integer | |||
| 11 | GL_DIMENSION_ID_ITEM | Integer | |||
| 12 | ITEM_BRANCH | String with Maximum (50) Characters | |||
| 13 | ITEM_REFERENCE_NO | String with Maximum (100) Characters | |||
| 14 | ITEM_REMARKS | String with Maximum (300) Characters | |||
| 15 | REMARKS | String with Maximum (100) Characters | |||
| 16 | TAX_CODE | String with Maximum (100) Characters | for GST Code (TX, NR, BL, OP, IM) | ||
| 17 | TAX_RATE | GST-MY INPUT |
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 |
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
