Page Comparison

GST Setup

...

• Updated all information except Branch (Branch activate on 31 March after business hour)

• Recommendation: Retailer used INCLUSIVE TAX method 

Image RemovedImage Added  

• Item price include tax rate :  Enable

...

6%                RM 84.91

Image RemovedImage Added

• Item price include tax rate :  Disable

• Mostly used in Distribution

...

Grand Total: RM  1590

** Appendix

Image RemovedImage Added

3.3: Purchase (Input Tax)

• Updated all information except Branch (Branch activate on 31 March after business hour)

Image RemovedImage Added

• Item price include tax rate : Disable

...

5.1 Inventory > Item > Add Item

Image RemovedImage Added

5.2 Inventory > Item > Edit Item

Image RemovedImage Added

5.3 Export Item and Import Method

...

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

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

...