Sunday, March 19, 2017

Direction Asia 2017 - 23 & 24 March @ Bangkok

Hello Friends,

I am going to attain Direction Asia 2017 event at Bangkok 23-24 March.

The Directions conference in US and EMEA have been growing over the years - join this first Directions conference in ASIA ?
The Directions ASIA conference is  a must-attend event for any NAV person.
Now, you can already save the date for Directions ASIA 2017, which will be held on March 23 - 24 in Bangkok, Thailand.
Join your peers there to get ready for NAV2017, network and learn from other NAV people of the NAV focused event !!!

Location
Hilton Millenium
123, Charoen Nakhon Rd, Khlong Ton Sai, Khlong San, Bangkok 10600, Thailanda





















Following are the schedule that we will learn and i will share the related document and workshop soon.

Following are list of trailing/workshop topic for Technical Consultant
DYNAMICS NAV 2017 EXTENSIONS AND EVENTS, AN OVERVIEW
DYNAMICS NAV 2017, EXTENSIONS AND EVENTS, PRACTICAL EXAMPLES
DYNAMICS NAV 2017, EMBEDDED POWER BI
USING DESIGN PATTERNS IN PRACTICE
DYNAMICS NAV 2017, EXTENSIONS - HANDS ON 
DYNAMICS NAV2017, MODERN DEVELOPMENT EXPERIENCE AND IMPROVEMENT FOR DEVELOPERS
BAD HABITS OF NAV DEVELOPERS
DYNAMICS NAV 2017, IN OFFICE 365 EXPERIENCE
DYNAMICS NAV 2017, DYNAMICS 365 FOR SALES INTEGRATION AND IMPROVEMENT TO CRM IN NAV
DYNAMICS NAV 2017, USING EVENTS
DYNAMICS 365 FOR FINANCIALS APPS, APPSOURCE & SOLUTIONAPPS
SOURCE CONTROL
DESIGN PATTERNS
INTEGRATION / CONTROL EVENTS
DYNAMICS NAV 2017, EXTENSIONS - AN INTERACTIVE DISCUSSION


Following are list of trailing/workshop topic for Functional Consultant:
DYNAMICS NAV2017, APPLICATION ENHANCEMENTS
Dynamics NAV 2017, User Experience Improvements
DYNAMICS NAV 2017, APPLICATION IMPROVEMENTS IN FINANCIALS AND JOBS
DYNAMICS NAV 2017, EMBEDDED POWER BI
DYNAMICS 365 FOR FINANCIALS, THE BUSINESS OVERVIEW
DYNAMICS NAV2017 NOTIFICATIONS
DYNAMICS NAV 2017, APPLICATION IMPROVEMENTS - HANDS ON
DYNAMICS 365 FOR SALES, THE BUSINESS OVERVIEW
DYNAMICS 365, BUSINESS EDITION PRICING AND LICENSING, INTRODUCTION
DYNAMICS NAV2017 CORTANA INTELLIGENCE
DYNAMICS NAV 2017, IN OFFICE 365 EXPERIENCE
DYNAMICS NAV2017, DEMOS
DYNAMICS NAV 2017, EMBEDDED POWER BI - HANDS ON
STRATEGY Q&A WITH DYNAMICS SMB LEADERSHIP TEAM

Saturday, March 18, 2017

Change the Date Format in NAV 2016 Web Client to DD/MM/YYYY & Currency to Indian Format

Hello Friends,

This article explains how to change the date format in Microsoft Dynamics NAV web client.
I have tested this on Microsoft Dynamics NAV 2016

A Brief History - 
1. Microsoft Dynamics Windows Client supports the date format as per Client System Date Format. 

2. Server Processes Like NAS and Web services support Date Format as per Defined in the service tier.

But Navision web client does not correspond to either of these two settings for date format.
Show the date in default English US format as following:






















For NAV 2016 Web Client you can configure the Indian Date & Currency format from My Setting in web client.

Steps to configure date format in web client:
---------------------------------------------------------------

1) Login to your web client NAV 2016

2) GoTo MySetting option (Top Left Corner)




























3) Change the Region to "English (India)"































4) Sing Out & Log In again. It will now show you DD-MM-YYYY format






















========================================================================
Same way if you want to change date format + currency format in web service & NAS than you can configure it from NAV Service as following.

Issue is that system showing date in (mm-dd-yyyy) & currency in US format when it is run from web client or NAS Job Queue:













Default it is shows in US format because Service Language Default Set to (en-US)


















Now just change the Service Language value to (en-IN) and restart the service
Service Default Time Zone = India Standard Time

















Now the date format & currency format come to Indian format in reports (run from NAS & Web Client)











That's it.
Done

I hope it will help to some one.
Thank you for reading.

Keep Sharing....Keep Growing....

Wednesday, March 15, 2017

Archive NAV Version Download Link (NAV 1.0 to NAV 2009R2 All Version)

Hello Friends,

Many time we need to download any old version of NAV for upgrade estimate or other reason and it is very difficult for search it on Partner Source account.

So, that i want to share the link of partner source page where you can find all detail about old version and download link for that.


​This page includes databases for Navision Financials 1.00 through Microsoft Dynamics NAV 2009 R2. The databases can be used in the upgrade process to upgrade earlier versions of Microsoft Dynamics NAV to the latest version of Microsoft Dynamics NAV

https://mbs.microsoft.com/partnersource/northamerica/deployment/downloads/service-packs/databasearchiveformicrosoftnavisionna



























I hope it will be helpful for someone.

Thank you for reading.

Keep Sharing...Keep Growing...

Friday, March 10, 2017

GST Manual (White Paper) for Microsoft Dynamics NAV 2016

Hello Friends,

GST Patch Released for Dynamics NAV !!!
Read the following blog for more detail - GST Patch Microsoft Dynamics NAV

Microsoft has release GST Manual (White Paper) for NAV 2016 India Version.
Thank you for GST India Team.

Download Link (GST Manual NAV 2016) - https://1drv.ms/b/s!An8nhANnLJmtiUaATocyh_T5XoT2

You need to update customer license to include new GST Object Permission.

​Government of India had envisaged a roadmap of Goods and Service Tax (GST) which was initially supposed to be implemented by 1st of April 2011 but now postponed to 1st July 2017. GST -- is a comprehensive tax levy on manufacture, sale and consumption of goods and services at a national level. ​​

The implementation of GST will lead to the abolition of other taxes such as octroi, Central Sales Tax, State-level sales tax, entry tax, stamp duty, telecom license fees, turnover tax, tax on consumption or sale of electricity, taxes on transportation of goods and services, et cetera, thus avoiding multiple layers of taxation​ that currently exist in India.

This would have a major impact on the product given that a design change is warranted in the taxation structure.

Overview

GST overview:​​​

a. Proposed GST:
    • Goods and Service Tax (GST) is an indirect tax levied on supply of goods or services or both.

    • It is a destination/consumption based tax levy which is payable in the state in which the goods and services are consumed.

    • It is levied and collected on value addition at each stage of production or distribution process (all points in supply chain).

    • The supplier can avail credit on input tax credit paid on procurement of goods or services.


​​b. Components of GST:
​​Compon​​​entLevied by​ Applicable o​n

Central GST (CGST)

Centre

Intra-state supply of goods or services in India.

State GST (SGST)

States

Intra-state supply of goods or services in India

Integrated GST (I​GST)

Centre

Inter-state supply of goods or services, Exports and Imports.


c. Goods outside Gamut of GST:
    • ​​Petroleum products and Alcohol for human consumption are proposed to be kept out of purview of GST. Petroleum products will be brought into GST ​network at a later stage.​

    • Central Excise duty will continue on petroleum products. States will continue to impose sales tax on sale within the state on petroleum products and alcohol for human consumption.

    • Tobacco products will be subject to Excise duty along with GST.


​ 

Top

Reference Information​




If a customer has customizations in any objects involved in this regulatory feature, they might require your special attention.

Licensing

The following objects have been added through this update. Licensing refresh is required.
T​​ypeN​o.NamePermissions
Table Data16400GST Registration Nos.RIMD-
Table Data16401GST Accounting PeriodRIMD-
Table Data16402GST Accounting Sub PeriodRIMD-
Table Data16403GST Claim Seto​ffRIMD-
Table Data16404GST GroupRIMD-
Table Data16405GST ComponentRIMD-
Table Data16406GST Posting SetupRIMD-
Table Data16407GST ConfigurationRIMD-
Table Data16408GST SetupRIMD-
Table Data16411HSN/SACRIMD-
Table Data16412Detailed GST Entry BufferRIMD-
Table Data16418GST Ledger EntryRIMD-
Table Data16419Detailed GST Ledger EntryRIMD-
Table Data16420GST Posting BufferRIMD-
Table Data16421GST Calculation BufferRIMD-
Table Data16422Adv. GST Calculation BufferRIMD-
Table Data16423GST Application BufferRIMD-
Table Data16424GST Liability LineRIMD-
Table Data16425Posted GST Liability LineRIMD-
Table Data16426e-Commerce Merchant IdRIMD-
Table Data16429GST Recon. MappingRIMD-
Table Data16430GST Reconciliation LinesRIMD-
Table Data16431Periodic GSTR-2A DataRIMD-
Table Data16432Posted GST ReconciliationRIMD-
Table Data16433GST ReconciliationRIMD-
Table Data16434GST Credit Adjustment JournalRIMD-
Table Data16435Invoice Adjustment JournalRIMD-
Table Data16436GST Payment BufferRIMD-
Table Description16400GST Registration Nos.R-MDX
Table Description16401GST Accounting PeriodR-MDX
Table Description16402GST Accounting Sub PeriodR-MDX
Table Description16403GST Claim SetoffR-MDX
Table Description16404GST GroupR-MDX
Table Description16405GST ComponentR-MDX
Table Description16406GST Posting SetupR-MDX
Table Description16407GST ConfigurationR-MDX
Table Description16408GST SetupR-MDX
Table Description16411HSN/SACR-MDX
Table Description16412Detailed GST Entry BufferR-MDX
Table Description16418GST Ledger EntryR-MDX
Table Description16419Detailed GST Ledger EntryR-MDX
Table Description16420GST Posting BufferR-MDX
Table Description16421GST Calculation BufferR-MDX
Table Description16422Adv. GST Calculation BufferR-MDX
Table Description16423GST Application BufferR-MDX
Table Description16424GST Liability LineR-MDX
Table Description16425Posted GST Liability LineR-MDX
Table Description16426e-Commerce Merchant IdR-MDX
Table Description16429GST Recon. MappingR-MDX
Table Description16430GST Reconciliation LinesR-MDX
Table Description16431Periodic GSTR-2A DataR-MDX
Table Description16432Posted GST ReconciliationR-MDX
Table Description16433GST ReconciliationR-MDX
Table Description16434GST Credit Adjustment JournalR-MDX
Table Description16435Invoice Adjustment JournalR-MDX
Table Description16436GST Payment BufferR-MDX
Report16400Create GST YearR-MDX
Report16401Create Default GST SetupR-MDX
Report16402GSTR-1R-MDX
Report16403GSTR-2R-MDX
Code Unit16401GST ManagementR-MDX
Code Unit16402GST Fiscal Year-CloseR-MDX
Code Unit16403GST Application ManagementR-MDX
Code Unit16404GST Returns ManagementR-MDX
Code Unit16405GST Input Tax CreditR-MDX
XML & Menu16401Periodic GSTR-2A Data16401
Page16401Periodic GSTR-2A DataR-MDX
Page16400GST Registration Nos.R-MDX
Page16401GST Accounting PeriodR-MDX
Page16402GST Accounting Sub PeriodR-MDX
Page16403GST Claim SetoffR-MDX
Page16404GST GroupR-MDX
Page16405GST ComponentR-MDX
Page16406GST Posting SetupR-MDX
Page16407GST ConfigurationR-MDX
Page16408GST SetupR-MDX
Page16411HSN/SACR-MDX
Page16412Detailed GST Entry BufferR-MDX
Page16413GST Ledger Entry PreviewR-MDX
Page16414Detailed GST Ledger Entry PrevR-MDX
Page16415Invoice Adjustment JournalR-MDX
Page16418GST Ledger EntryR-MDX
Page16419Detailed GST Ledger EntryR-MDX
Page16420Create GST LiabilityR-MDX
Page16421GST Liability LineR-MDX
Page16422Posted GST LiabilityR-MDX
Page16423e-Commerce Merchant IdR-MDX
Page16426GST Component Mapping Recon.R-MDX
Page16427GST Reconciliation LinesR-MDX
Page16428Periodic GSTR-2A DataR-MDX
Page16429Posted GST ReconciliationR-MDX
Page16430GST ReconciliationR-MDX
Page16431GST Reconciliation ListR-MDX
Page16432GST Recon. Field MappingR-MDX
Page16433GST Credit Adjustment JournalR-MDX
Page16434Pay GSTR-MDX
Page16435GST PaymentR-MDX
Page16436Update Invoice DetailsR-MDX​
​ 

Top
​ 

Objects

The following objects have​ been added/modified through this release:
Typ​​eNo.NameAdded/Modified
TAB14LocationModified
TAB15G/L AccountModified
TAB17G/L EntryModified
TAB18CustomerModified
TAB21Cust. Ledger EntryModified
TAB23VendorModified
TAB25Vendor Ledger EntryModified
TAB27ItemModified
TAB32Item Ledger EntryModified
TAB36Sales HeaderModified
TAB37Sales LineModified
TAB38Purchase HeaderModified
TAB39Purchase LineModified
TAB45G/L RegisterModified
TAB79Company InformationModified
TAB81Gen. Journal LineModified
TAB83Item Journal LineModified
TAB98General Ledger SetupModified
TAB110Sales Shipment HeaderModified
TAB111Sales Shipment LineModified
TAB112Sales Invoice HeaderModified
TAB113Sales Invoice LineModified
TAB114Sales Cr.Memo HeaderModified
TAB115Sales Cr.Memo LineModified
TAB120Purch. Rcpt. HeaderModified
TAB121Purch. Rcpt. LineModified
TAB122Purch. Inv. HeaderModified
TAB123Purch. Inv. LineModified
TAB124Purch. Cr. Memo Hdr.Modified
TAB125Purch. Cr. Memo LineModified
TAB156ResourceModified
TAB179Reversal EntryModified
TAB222Ship-to AddressModified
TAB242Source Code SetupModified
TAB311Sales & Receivables SetupModified
TAB312Purchases & Payables SetupModified
TAB313Inventory SetupModified
TAB5107Sales Header ArchiveModified
TAB5108Sales Line ArchiveModified
TAB5109Purchase Header ArchiveModified
TAB5110Purchase Line ArchiveModified
TAB5600Fixed AssetModified
TAB5741Transfer LineModified
TAB5745Transfer Shipment LineModified
TAB5747Transfer Receipt LineModified
TAB5800Item ChargeModified
TAB5900Service HeaderModified
TAB5902Service LineModified
TAB5905Service CostModified
TAB5911Service Mgt. SetupModified
TAB5990Service Shipment HeaderModified
TAB5991Service Shipment LineModified
TAB5992Service Invoice HeaderModified
TAB5993Service Invoice LineModified
TAB5994Service Cr.Memo HeaderModified
TAB5995Service Cr.Memo LineModified
TAB6650Return Shipment HeaderModified
TAB6651Return Shipment LineModified
TAB6660Return Receipt HeaderModified
TAB6661Return Receipt LineModified
TAB13715Transfer BufferModified
TAB13717Applied Delivery ChallanModified
TAB13758Str Order Archive DetailsModified
TAB13760Posted Structure Order DetailsModified
TAB13762StateModified
TAB13793Structure DetailsModified
TAB13794Structure Order DetailsModified
TAB13795Structure Order Line DetailsModified
TAB13798Posted Str Order Line DetailsModified
TAB13799Str Order Line Archive DetailsModified
TAB16321Sub Order Component ListModified
TAB16323Delivery Challan HeaderModified
TAB16324Delivery Challan LineModified
TAB16400GST Registration Nos.Added
TAB16401GST Accounting PeriodAdded
TAB16402GST Accounting Sub PeriodAdded
TAB16403GST Claim SetoffAdded
TAB16404GST GroupAdded
TAB16405GST ComponentAdded
TAB16406GST Posting SetupAdded
TAB16407GST ConfigurationAdded
TAB16408GST SetupAdded
TAB16411HSN/SACAdded
TAB16412Detailed GST Entry BufferAdded
TAB16418GST Ledger EntryAdded
TAB16419Detailed GST Ledger EntryAdded
TAB16420GST Posting BufferAdded
TAB16421GST Calculation BufferAdded
TAB16422Adv. GST Calculation BufferAdded
TAB16423GST Application BufferAdded
TAB16424GST Liability LineAdded
TAB16425Posted GST Liability LineAdded
TAB16426e-Commerce Merchant IdAdded
TAB16429GST Recon. MappingAdded
TAB16430GST Reconcilation LinesAdded
TAB16431Periodic GSTR-2A DataAdded
TAB16432Posted GST ReconciliationAdded
TAB16433GST ReconcilationAdded
TAB16434GST Credit Adjustment JournalAdded
TAB16435Invoice Adjustment JournalAdded
TAB16436GST Payment BufferAdded
REP2General Journal - TestModified
REP202Sales Document - TestModified
REP204Sales - QuoteModified
REP205Order ConfirmationModified
REP206Sales - InvoiceModified
REP207Sales - Credit MemoModified
REP210Blanket Sales OrderModified
REP215Archived Sales QuoteModified
REP216Archived Sales OrderModified
REP292Copy Sales DocumentModified
REP402Purchase Document - TestModified
REP404Purchase - QuoteModified
REP405OrderModified
REP406Purchase - InvoiceModified
REP407Purchase - Credit MemoModified
REP410Blanket Purchase OrderModified
REP415Archived Purchase QuoteModified
REP416Archived Purchase OrderModified
REP417Arch.Purch. Return OrderModified
REP418Arch. Sales Return OrderModified
REP5900Service OrderModified
REP5902Service QuoteModified
REP5911Service - InvoiceModified
REP5915Service Document - TestModified
REP6631Return Order ConfirmationModified
REP6641Return OrderModified
REP16400Create GST YearAdded
REP16401Create Default GST SetupAdded
REP16402GSTR-1Added
REP16403GSTR-2Added
COD11Gen. Jnl.-Check LineModified
COD12Gen. Jnl.-Post LineModified
COD17Gen. Jnl.-Post ReverseModified
COD19Gen. Jnl.-Post PreviewModified
COD22Item Jnl.-Post LineModified
COD42CaptionManagementModified
COD64Sales-Get ShipmentModified
COD80Sales-PostModified
COD90Purch.-PostModified
COD101Cust. Entry-SetAppl.IDModified
COD103Cust. Entry-EditModified
COD111Vend. Entry-SetAppl.IDModified
COD113Vend. Entry-EditModified
COD225Gen. Jnl.-ApplyModified
COD226CustEntry-Apply Posted EntriesModified
COD227VendEntry-Apply Posted EntriesModified
COD333Req. Wksh.-Make OrderModified
COD5704TransferOrder-Post ShipmentModified
COD5705TransferOrder-Post ReceiptModified
COD5805Item Charge Assgnt. (Purch.)Modified
COD5807Item Charge Assgnt. (Sales)Modified
COD5986Serv-Amounts Mgt.Modified
COD5987Serv-Posting Journals Mgt.Modified
COD5988Serv-Documents Mgt.Modified
COD6620Copy Document Mgt.Modified
COD6638Sales-Get Return ReceiptsModified
COD16360Subcontracting PostModified
COD16401GST ManagementAdded
COD16402GST Fiscal Year-CloseAdded
COD16403GST Application ManagementAdded
COD16404GST Returns ManagementAdded
COD16405GST Input Tax CreditAdded
XML Port16401Periodic GSTR-2A DataAdded
Menu Suite1010Dept - MBSModified
Menu Suite1030Dept - CountryModified
PAG1Company InformationModified
PAG17G/L Account CardModified
PAG20General Ledger EntriesModified
PAG21Customer CardModified
PAG25Customer Ledger EntriesModified
PAG26Vendor CardModified
PAG29Vendor Ledger EntriesModified
PAG30Item CardModified
PAG39General JournalModified
PAG41Sales QuoteModified
PAG42Sales OrderModified
PAG43Sales InvoiceModified
PAG44Sales Credit MemoModified
PAG46Sales Order SubformModified
PAG47Sales Invoice SubformModified
PAG49Purchase QuoteModified
PAG50Purchase OrderModified
PAG51Purchase InvoiceModified
PAG52Purchase Credit MemoModified
PAG54Purchase Order SubformModified
PAG55Purch. Invoice SubformModified
PAG76Resource CardModified
PAG95Sales Quote SubformModified
PAG96Sales Cr. Memo SubformModified
PAG97Purchase Quote SubformModified
PAG98Purch. Cr. Memo SubformModified
PAG116G/L RegistersModified
PAG118General Ledger SetupModified
PAG130Posted Sales ShipmentModified
PAG132Posted Sales InvoiceModified
PAG134Posted Sales Credit MemoModified
PAG135Posted Sales Cr. Memo SubformModified
PAG136Posted Purchase ReceiptModified
PAG137Posted Purchase Rcpt. SubformModified
PAG138Posted Purchase InvoiceModified
PAG139Posted Purch. Invoice SubformModified
PAG140Posted Purchase Credit MemoModified
PAG141Posted Purch. Cr. Memo SubformModified
PAG143Posted Sales InvoicesModified
PAG144Posted Sales Credit MemosModified
PAG160Sales StatisticsModified
PAG161Purchase StatisticsModified
PAG232Apply Customer EntriesModified
PAG233Apply Vendor EntriesModified
PAG253Sales JournalModified
PAG254Purchase JournalModified
PAG256Payment JournalModified
PAG279Source Code SetupModified
PAG300Ship-to AddressModified
PAG344NavigateModified
PAG397Sales Invoice StatisticsModified
PAG398Sales Credit Memo StatisticsModified
PAG400Purchase Invoice StatisticsModified
PAG401Purch. Credit Memo StatisticsModified
PAG402Sales Order StatisticsModified
PAG403Purchase Order StatisticsModified
PAG459Sales & Receivables SetupModified
PAG460Purchases & Payables SetupModified
PAG461Inventory SetupModified
PAG507Blanket Sales OrderModified
PAG508Blanket Sales Order SubformModified
PAG509Blanket Purchase OrderModified
PAG510Blanket Purchase Order SubformModified
PAG1305Mini Sales Invoice SubformModified
PAG1308Mini Posted Sales Inv. SubformModified
PAG1320Mini Sales Cr.Memo SubformModified
PAG1323Mini Pst.Sales Cr.Memo SubformModified
PAG1325Mini Sales Quote SubformModified
PAG1355Mini Purch. Invoice SubformModified
PAG1358Mini Posted Purch. Inv. SubfrmModified
PAG1370Mini Purch. Cr.Memo SubformModified
PAG1373Mini Pst.Purch.Cr.Memo SubformModified
PAG5165Purchase Quote Archive SubformModified
PAG5167Purchase Order ArchiveModified
PAG5168Purchase Order Archive SubformModified
PAG5600Fixed Asset CardModified
PAG5703Location CardModified
PAG5741Transfer Order SubformModified
PAG5744Posted Transfer Shpt. SubformModified
PAG5746Posted Transfer Rcpt. SubformModified
PAG5800Item ChargesModified
PAG5805Item Charge Assignment (Purch)Modified
PAG5814Item Charge Assignment (Sales)Modified
PAG5900Service OrderModified
PAG5905Service LinesModified
PAG5910Service CostsModified
PAG5914Service Order StatisticsModified
PAG5919Service Mgt. SetupModified
PAG5933Service InvoiceModified
PAG5934Service Invoice SubformModified
PAG5935Service Credit MemoModified
PAG5936Service Credit Memo SubformModified
PAG5964Service QuoteModified
PAG5966Service Quote LinesModified
PAG5971Posted Service Credit MemosModified
PAG5972Posted Service Credit MemoModified
PAG5973Posted Serv. Cr. Memo SubformModified
PAG5975Posted Service ShipmentModified
PAG5977Posted Service InvoicesModified
PAG5978Posted Service InvoiceModified
PAG5979Posted Service Invoice SubformModified
PAG6030Service StatisticsModified
PAG6033Service Invoice StatisticsModified
PAG6034Service Credit Memo StatisticsModified
PAG6630Sales Return OrderModified
PAG6631Sales Return Order SubformModified
PAG6640Purchase Return OrderModified
PAG6641Purchase Return Order SubformModified
PAG6645Purchase Return Order Arc SubformModified
PAG6650Posted Return ShipmentModified
PAG6651Posted Return Shipment SubformModified
PAG6660Posted Return ReceiptModified
PAG13789StatesModified
PAG16303Structure DetailsModified
PAG16305Structure Order DetailsModified
PAG16306Structure Order Line DetailsModified
PAG16308Posted Structure Order DetailsModified
PAG16309Posted Str Order Line DetailsModified
PAG16321Sub Order ComponentsModified
PAG16325Delivery ChallanModified
PAG16326Delivery Challan SubformModified
PAG16327Delivery Challan ListModified
PAG16340Subcontracting Order SubformModified
PAG16400GST Registration Nos.Added
PAG16401GST Accounting PeriodAdded
PAG16402GST Accounting Sub PeriodAdded
PAG16403GST Claim SetoffAdded
PAG16404GST GroupAdded
PAG16405GST ComponentAdded
PAG16406GST Posting SetupAdded
PAG16407GST ConfigurationAdded
PAG16408GST SetupAdded
PAG16411HSN/SACAdded
PAG16412Detailed GST Entry BufferAdded
PAG16413GST Ledger Entry PreviewAdded
PAG16414Detailed GST Ledger Entry PrevAdded
PAG16415Invoice Adjustment JournalAdded
PAG16418GST Ledger EntryAdded
PAG16419Detailed GST Ledger EntryAdded
PAG16420Create GST LiabilityAdded
PAG16421GST Liability LineAdded
PAG16422Posted GST LiabilityAdded
PAG16423e-Commerce Merchant IdAdded
PAG16426GST Component Mapping Recon.Added
PAG16427GST Reconciliation LinesAdded
PAG16428Periodic GSTR-2A DataAdded
PAG16429Posted GST ReconciliationAdded
PAG16430GST ReconciliationAdded
PAG16431GST Reconciliation ListAdded
PAG16432GST Recon. Field MappingAdded
PAG16433GST Credit Adjustment JournalAdded
PAG16434Pay GSTAdded
PAG16435GST PaymentAdded
PAG16436Update Invoice DetailsAdded
PAG16442Delivery Challan LineModified
PAG16569Bank Receipt VoucherModified
PAG16570Contra VoucherModified
PAG16571Journal VoucherModified
PAG16576Cash Payment VoucherModified
PAG16577Bank Payment VoucherModified
PAG16579Cash Receipt VoucherModified
​ 


Setup​

1.        New Setup fields added in existing Tables
Tab​​leField​ Description
Company InformationGST Registration No.Type: Code 15
General Ledger Setup

GST Rounding PrecisionType: Decimal
GST Rounding Type
Type: Option
Options are Nearest, Up, Down
Purch. A/C for Job Work Liab.Type: Code 20
IGST Payable A/c in ImportType: Code 20
GST Recon. TolaranceType: Decimal
StateState Code for GST Reg. No.Type: Code 2
Structure DetailsTypeType: Option
Inc. GST in TDS BaseType: Boolean
GST Dependence Type
Type: Option
Options are –  , Bill-to Address, Ship-to Address, Location Address
Sales & Receivable SetupPosted Inv. Nos. (Exempt)Type: Code 10
Posted Cr. Memo Nos. (Exempt)Type: Code 10
Posted Inv. No. (Export)Type: Code 10
Posted Cr. Memo No. (Export)Type: Code 10
Posted Inv. No. (Supp)Type: Code 10
Posted Cr. Memo No. (Supp)Type: Code 10
Posted Inv. No. (Debit Note)Type: Code 10
Posted Inv. No. (Non-GST)Type: Code 10
Posted Cr. Memo No. (Non-GST)Type: Code 10


2.        New Setup Tables:

  • GST Registration No. table
 Fi​eldDescr​iption
State CodeType: Code 10
CodeType: Code 15
DescriptionType: Text 30

  • GST Accounting Period table 
Fiel​d​ Desc​ription
Starting DateType: Date
Ending DateType: Date
Year ClosedType: Boolean

  • GST Accounting Sub-Period table 
Fi​el​dDescription
Accounting Period Starting DateType: Date
Starting DateType: Date
NameType: Text 10
New Financial YearType: Boolean
Due Date for Outward Supplies Returns (GSTR-1)Type: Date
Due Date for Inward Supplies Returns (GSTR-2)Type: Date
Due Date for Monthly returns (GSTR-3)Type: Date
Due Date for Input Service DistributorType: Date
Due Date for TDSType: Date
GST Payment Due DateType: Date
Date LockedType: Boolean
ClosedType: Boolean
 ​
  • GST Component table
FieldDescription
C​​odeType: Code 10
DescriptionType: Text 50
GST Jurisdiction
Type: Option

Options are Intrastate, Interstate
Include BaseType: Boolean
Formula
Type: Code 250
Dropdown to Component table
If any component is selected then it shall calculate on the value of the component selected.
Calculation OrderType: Integer
Report ViewType: Integer

  • GST Group table
Fie​​ldDescription
CodeType: Code 10
DescriptionType: Text 250
GST Group Type
Type: Option
Options are Goods, Service
GST Place Of Supply
Type: Option
Options are  (Blank) ,Bill-to Address, Ship-to Address, Location Address

  • GST Posting Setup table
Field​​Description
State Code
Type: Code 10
Dropdown from State table
GST Component Code
Type: Code 10
Dropdown from GST Component table
Receivables Account
Type: Code 20
Dropdown to G/L Account table
Payable
Type: Code 20
Dropdown to G/L Account table
Receivables Account (Interim)
Type: Code 20
Dropdown to G/L Account table
Payables Account (Interim)
Type: Code 20
Dropdown to G/L Account table
Expenses Account
Type: Code 20
Dropdown to G/L Account table
Refund Account
Type: Code 20
Dropdown to G/L Account table

  • GST Claim Setoff table
Fiel​​dDescription
GST Component
Type: Code 10
Lookup to GST Component
Priority
Type: Integer
User will manually update the number
Set Off Component
Type: Code 10
Lookup to GST Component

  • GST Configuration table
Fiel​​dDescription
Type
Type: Options
Option are Vendor, Customer
Dispatch / Receiving State Code
Type: Code 10
Dropdown from State table
Customer / Vendor State Code
Type: Code 10
Dropdown from State table
GST Jurisdiction
Type: Option
Options are  Intrastate, Interstate This field shall be auto updated, Intrastate shall be updated if Dispatch / Receiving State Code field value and Customer / Vendor State Code field is same else Interstate. If any one state code is blank then Interstate shall be updated.
GST % Sate Code
Type: Code 10
Dropdown from State table

  • GST Details table
Field​​Description
GST % State Code
Type: Code 10
Dropdown from State table
GST Group Code
Type: Code 20
Dropdown from GST Group table
GST Component Code
Type: Code 10
Dropdown from GST Component table
Effective Date
Type: Date
User needs to mention the Effective date
GST Component %
Type: Decimal
User needs to mention the GST percentage
Include BaseType: Boolean
Formula
Type: Code 250
Dropdown to GST Component table
GST Jurisdiction
Type: Option
Options are: Intrastate, Interstate
Calculation OrderType: Integer


Official Link : https://mbs.microsoft.com/partnersource/global/deployment/downloads/tax-
regulatory-updates/nav2016gstindia

Thank you for reading.

I will update more detail about GST very soon.

Keep Sharing....Keep Growing ....