Versions Compared

Version Old Version 6 New Version 7
Changes made by

Jia Pei Chan

Jia Pei Chan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Upon adopting EMP for the first time, users will need to bring forward any outstanding balances from suppliers’ accounts from the previous accounting system.

...

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

...

Menu Path: Supplier > Supplier Invoice > Upload Supplier Invoice

Image Added

Data

Tax Code
NoField NameData TypeRemarksWhere to Find / DescriptionSample Data
1BRANCH_CODEString with Maximum (50) CharactersCompulsory

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


A Co.-B1
2DEBITFloating Point NumberCompulsory


100.00
3GL_SHORT_HANDString with Maximum (50) CharactersCompulsoryrelevant gl short hand, will be deleted purchases
4REFERENCE_NOString with Maximum (100) CharactersCompulsory Outstanding Invoice number
5SINV_DATEString in the following format (yyyy-mm-dd)Compulsoryfollow outstanding invoice date 
6SUPPLIER_IDIntegerCompulsory

Refer to system supplier account PKID (auto-generated)

Reference #Outstanding Invoice numberRemarks GL Dimension ID (Header)Leave it Empty if no dataGL Dimension Code (Header)Leave it Empty if no dataSINV Datefollow outstanding invoice date (before start Wavelet Txn; date format: YYYY-MM-DD)Due DateLeave it Empty if no dataGL Short HandpurchasesItem Reference NoOutstanding Invoice numberItem Remarks GL Dimension ID (Item)Leave it Empty if no dataGL Dimension Code (Item)Leave it Empty if no dataDebitInvoice outstanding Amount (AMOUNT INCLUSIVE OF GST) 

7DUE_DATEString in the following format (yyyy-mm-dd)


8GL_DIMENSION_CODEString with Maximum (50) Characters


9GL_DIMENSION_CODE_ITEMString with Maximum (50) Characters


10GL_DIMENSION_IDInteger


11GL_DIMENSION_ID_ITEMInteger


12ITEM_BRANCHString with Maximum (50) Characters
 
13ITEM_REFERENCE_NOString with Maximum (100) Characters


14ITEM_REMARKSString with Maximum (300) Characters


15REMARKSString with Maximum (100) Characters


16TAX_CODEString with Maximum (100) Characters
for GST Code (TX, NR, BL, OP, IM)
Tax Type

17TAX_RATE

GST-MY INPUT
Tax Rate0 or 0.06StringRecord Terminator - Must Key IN EOR


Example:

ExampleDebitTAX_CODETAX_RATEResultSupplier Outstanding Invoice AmountTax amountRemarks
E01530TX 0.06 53030Use this method if the full outstanding amount all TX code
E021000IM 0 10000.00Use this method if the full outstanding amount is IM code
E031000TX  100056.60System record Tax Amount 56.60
E04530   5300.00Empty all the GST infor, to record the outstanding invoice before 1 April 2015

Menu Path: Supplier > Supplier Invoice > Upload Supplier Invoice

Image Removed

  • 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

...

1.Create Supplier Invoice  

 Menu Path: Supplier > Credit Memo > Create

Data:

Supplier : 1 One Time Supplier

...

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