Before start reading" GST Setup User Guide", you might need to understand:-
| What is | Definitions | Remarks |
|---|---|---|
| Real (Category Type) | Refer to Assets/ Liability/ Equity | Will be processed for c/f & b/f over next accounting periods Will NOT be processed for P&L |
| Temp (Category Type) | Refer to Revenue / Expenses | Will be processed during P&L generation |
...
GST Setup
1. GL Category
Accounting > Maintenance > Configuration > GL Category Maintenance > Create
...
3. Select Source Fields: ITEM_CODE, NAME, STATUS, ITEM_TYPE1, SERIALIZED, GLCODE, TAX_OPTION, TAX_RATE, TAX_CODE, TAX_TYPE, TAX_RATE_OUTPUT, TAX_CODE_OUTPUT, TAX_TYPE_OUTPUT then click Add to Target Fields, click "Export"
4. Update field information:
TAX_OPTION: ENABLED
TAX_RATE: 6 or 0
TAX_CODE: TX,NR,IM,IS,BL,ZP,EP,OP,TX-E43,TX-N43,TX-RE,GP,ATMS,ISRV,AJP
TAX_TYPE: GST-MY INPUT
TAX_RATE_OUTPUT: 6 or 0
TAX_CODE_OUTPUT: SR,ZRL,ZRE,DS,DS-ISRV,OS,ES,ES43,ESN43,RS,GS,AJS
TA X_TYPE_OUTPUT: GST-MY OUTPUT
5. Save file as: CSV (Comma delimited)
...
- Insert 2 column
- Use formula “PRICE_LIST”*1.06
- Copy the formula column to new column, Paste Special, only Values
- Copy header PRICE_LIST
- Delete Original PRICE_LIST & formula column
- Save file as: CSV (Comma delimited)
Upload the excel file to update the price
...