Page Comparison

GST Setup

...

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

Image Modified

5. Save file as: CSV (Comma delimited)

...

1. Insert 2 column
2. Use formula “PRICE_LIST”*1.06
3. Copy the formula column to new column, Paste Special, only Values
4. Copy header PRICE_LIST
5. Delete Original PRICE_LIST & formula column
6. Save file as: CSV (Comma delimited)
   
   

Image Modified

Upload the excel file to update the price

...

Customer Maintenance: Tax Option: Exclude Tax

13.  Rounding Adjustment (Sales, GRN, SINV and PV transaction)Please download the attachment for reference. 

Related:

GST code

https://drive.google.com/open?id=1bhhLHzvq6pOgI4H7lj9fK8ipNjMH-W3F5ANe7GgBk3A&authuser=0

GST Flow

Please download the attachment for reference. 

https://drive.google.com/open?id=1HS-rb8gAyI6sLho_yzbjQY5EVmiXj9gktz6FWafC32Y&authuser=0

...