GST Setup
...
Updated all information except Branch (Branch activate on 31 March after business hour)
- Recommendation: Retailer used INCLUSIVE TAX method
Item price include tax rate : EnableMostly used in Retail
When issue a tax invoice, the price enter is Amount Inclusive of GST
...
6% RM 84.91
Item price include tax rate : Disable
Mostly used in Distribution
...
When create the GRN, the price enter is Amount Excluding GST (cost price)
(Assuming received TAX Invoice)
e.g: RM 1000
System Calculation:
...
GST 6%: RM 60
Grand Total: RM 1060
~ Notes:
4. Activation GST Code
Accounting > Maintenance > Configuration > List Tax Config
...
3. Select Source Fields: ITEM_CODE, NAME, STATUS, ITEM_TYPE1, SERIALIZED, 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
...
EMP Output Tax Configuration: Item Price include tax rate : Enable
Customer Maintenance: Tax Option: Exclude Tax
...
Please download the attachment for reference.
GST flow_v2.pdf
GST code_2015.v2code
https://drive.google.com/open?id=1bhhLHzvq6pOgI4H7lj9fK8ipNjMH-W3F5ANe7GgBk3A&authuser=0
GST Flow
https://drive.google.com/open?id=1HS-rb8gAyI6sLho_yzbjQY5EVmiXj9gktz6FWafC32Y&authuser=0