Dynamics Navision 2013 R2 Indian Version.

Hi All,

Could anyone please explain me how VAT is working on Indian Version. I could see VAT in sales invoice line but there is no entry in VAT entry table or I can’t see any values in nominal codes of VAT. It is working fine with UK version. This is the example from sales invoice line table Amount is 400, amount including VAT is 450 and VAT% is 12.5. Please help me.

timestamp Document No_ Line No_ Sell-to Customer No_ Type No_ Location Code Posting Group Shipment Date Description Description 2 Unit of Measure Quantity Unit Price Unit Cost (LCY) VAT _ Line Discount _ Line Discount Amount Amount Amount Including VAT Allow Invoice Disc_ Gross Weight Net Weight Units per Parcel Unit Volume Appl_-to Item Entry Shortcut Dimension 1 Code Shortcut Dimension 2 Code Customer Price Group Job No_ Work Type Code Shipment No_ Shipment Line No_ Bill-to Customer No_ Inv_ Discount Amount Drop Shipment Gen_ Bus_ Posting Group Gen_ Prod_ Posting Group VAT Calculation Type Transaction Type Transport Method Attached to Line No_ Exit Point Area Transaction Specification Tax Area Code Tax Liable Tax Group Code VAT Clause Code VAT Bus_ Posting Group VAT Prod_ Posting Group Blanket Order No_ Blanket Order Line No_ VAT Base Amount Unit Cost System-Created Entry Line Amount VAT Difference VAT Identifier IC Partner Ref_ Type IC Partner Reference Prepayment Line IC Partner Code Posting Date Dimension Set ID Job Task No_ Job Contract Entry No_ Variant Code Bin Code Qty_ per Unit of Measure Unit of Measure Code Quantity (Base) FA Posting Date Depreciation Book Code Depr_ until FA Posting Date Duplicate in Depreciation Book Use Duplication List Responsibility Center Cross-Reference No_ Unit of Measure (Cross Ref_) Cross-Reference Type Cross-Reference Type No_ Item Category Code Nonstock Purchasing Code Product Group Code Appl_-from Item Entry Return Reason Code Allow Line Disc_ Customer Disc_ Group Tax Amount Excise Bus_ Posting Group Excise Prod_ Posting Group Excise Amount Amount Including Excise Excise Base Amount Excise Accounting Type Excise Base Quantity Tax _ Amount Including Tax Amount Added to Excise Base Amount Added to Tax Base Tax Base Amount Surcharge _ Surcharge Amount Concessional Code Assessee Code TDS_TCS _ Bal_ TDS_TCS Including SHECESS Claim Deferred Excise Capital Item BED Amount AED(GSI) Amount SED Amount SAED Amount CESS Amount NCCD Amount eCess Amount Form Code Form No_ State TDS_TCS Amount Amount To Customer Charges To Customer TDS_TCS Base Amount Surcharge Base Amount Service Tax Group Service Tax Base Service Tax Amount Service Tax Registration No_ eCESS _ on TDS_TCS eCESS on TDS_TCS Amount Total TDS_TCS Incl_ SHE CESS Per Contract Service Tax eCess Amount ADET Amount AED(TTA) Amount Free Supply ADE Amount Assessable Value VAT Type SHE Cess Amount Service Tax SHE Cess Amount Direct Debit To PLA _ RG TCS Nature of Collection TCS Type Standard Deduction _ Standard Deduction Amount Supplementary Source Document Type Source Document No_ ADC VAT Amount CIF Amount BCD Amount CVD Process Carried Out Identification Mark Re-Dispatch Return Rcpt line No_ Qty_ to be Re-Dispatched Return Re-Dispatch Rcpt_ No_ SHE Cess _ on TDS_TCS SHE Cess on TDS_TCS Amount MRP Price MRP Abatement _ PIT Structure Price Inclusive of Tax Unit Price Incl_ of Tax Amount To Customer UPIT UPIT Rounding Inserted Custom eCess Amount Custom SHECess Amount Excise Effective Rate
0x0000000000111647 SI1000 10000 CUST1 2 PRODUCT1 GUWAHATI FINISHED 2015-07-22 00:00:00.000 Product 1 Pack 10.00000000000000000000 40.00000000000000000000 0.00000000000000000000 12.50000000000000000000 0.00000000000000000000 0.00000000000000000000 400.00000000000000000000 450.00000000000000000000 1 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0 0 CUST1 0.00000000000000000000 0 NATIONAL RETAIL 0 0 0 STD NATIONAL VAT12.5 0 400.00000000000000000000 0.00000000000000000000 0 400.00000000000000000000 0.00000000000000000000 VAT12.5 0 0 2015-07-22 00:00:00.000 0 0 1.00000000000000000000 PACK 10.00000000000000000000 1753-01-01 00:00:00.000 0 0 0 0 0 1 0.00000000000000000000 GEN 2403.15 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0 0.00000000000000000000 0.00000000000000000000 400.00000000000000000000 0.00000000000000000000 0.00000000000000000000 400.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0 0 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 400.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 AS111 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0 0.00000000000000000000 0.00000000000000000000 0 0.00000000000000000000 0.00000000000000000000 0 0 0.00000000000000000000 0.00000000000000000000 0 0 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0 0 0 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000 0 0.00000000000000000000 0 0.00000000000000000000 0.00000000000000000000 0 0.00000000000000000000 0.00000000000000000000 0.00000000000000000000

Hi,

Indian VAT not work like other countries

You need to look at the Structures,VAT Setup for calculating the VAT