Wednesday, August 16, 2017

Create a CSV file via an XMLport with no field delimiter

Hello Friends,

When you try to enter a blank in the field "FieldDelimiter" it keeps defaulting to <">








It turns out that unlike most other NAV fields, you can validly enter text between the < >

If you enter <None> it works!
ValueDescription
<None>There is no FieldEndDelimiter
<NewLine>Any combination of CR and LF characters
<CR/LF>CR followed by LF
<CR>CR alone
<LF>LF alone
<TAB>Tabulator alone
Other stringsThe literal string entered

GSTR offline tool except the CSV file with no deliminator in data.

Sunday, August 6, 2017

Comparison between NAV 2017 and Dynamics 365 for Financials

Dynamics 365 for Financials is a newly launched product by Microsoft which is fully based on Cloud. The product is developed keeping Microsoft Dynamics Navision as base. Following is the list of differences which could be identified when compared to Microsoft Dynamics NAV 2017.
  1. User Interface
    D365 for Financials – It is a web based application hosted on Cloud. There is no Client Installation Required. It can be used from Web Browser, Mobile Application and Tablet Application.



NAV 2017 – NAV 2017 can be installed either on On-premises server or on Azure. NAV 2017 can be used from Windows client as well as from Web Browser, Mobile Application and Tablet Application. The feel and look of web browser of NAV 2017 as well as of D365 for financials is same.





























  1. Modules/Departments
    As compared to NAV 2017, D365 for financials does not provide modules and their respective functionalities with respect to Production, Warehouse, Human Resource & Service.
  2. Finance Module
    As compared to NAV 2017, D365 for financials does not provide functionalities with reference to Finance Module like Intercompany transactions.
  3. Sales & Marketing Module
    Following is the list of features which are missing from D365 for Financials regarding Sales & Marketing Module:
    1. Item Charge
    2. Shipment Methods
    3. Shipping Agents
  4. Item Functionality
    As compared to NAV 2017, D365 for financials does not supports Lot Tracking, Locations & its related functionality.
  5. Purchase Module
    Following is the list of features which are missing from D365 for Financials with reference to Purchase Module:
    1. Purchase Quote
    2. Item Charge
  6. Administration
    From administration point of view following are the features which are not present in D365 for financials:
    1. Links- To attach documents
    2. Notes – For adding information and notifying users.
    3. Comments – For adding any comment/text for extra information.
  7. Development
    Any customization in D365 for financials would be only through Extensions while NAV supports development through extensions as well as by touching the base code.

Conclusion

D365 for financials is a very good product for Small and medium size enterprises. The features mentioned above which are missing, Microsoft in their future release will incorporate it into D365 for financials.