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 |
...
- This function transfers the amount owed to / owed by the customer
- The opening balances are best brought forward immediately after the EMP is adopted.
- Make sure that you have already imported the customer code first. Refer to Importing Supplier Account
Method 1: UPLOAD FUNCTION
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).
...
- Follow the Step 1 - 4 on UPLOAD SUPPLIER 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 or Follow the GRN date
Method 2: Manual Supplier Invoice
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 Please follow the steps on Create Supplier Invoice
- Enter the Old Reference number – from previous accounting software
- Remarks
- Date – date before EMP is adopted or follow the previous Key In Date BEFORE FIRST EMP FINANCIAL YEAR or Follow the GRN date
- Key in the Outstanding amount – The amount outstanding can be obtained from your old system’s Outstanding Creditors for individual suppliers.
- Add Add GL Code : Select GL Code: purchasespurchases
Notes:
- Opening balances can only need be entered entered one by one for each supplier.customer
- 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.
FINAL STEP:
- After Supplier Invoice before first EMP financial Year created, there are two steps need to be done
Step 1: Create Supplier Credit Memo
Menu Path: Supplier > Credit Memo > Credit Memo Contra
- After Supplier CM created → please contra with the Supplier Invoice from One Time Supplier
Step 2: Remove Journal Transactions
Menu Path: Accounting > Maintenance > Configuration > Set Opening Balance
Related Wiki Pages:
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|