NAV to SQL conversion date problem

pmusu
pmusu Member Posts: 55
edited 2009-09-28 in NAV/Navision Classic Client
Hi,

We are currently in the process of converting from NAV database to NAV SQL.
We are encountering problems with the dates. E.g. Posting Date is 01/01/0009.

The question is the following:
Is there a way to loop all the tables in Navision, check all date fields in that table, and check entries of the table to see if dates are less than a certain date e.g. 31/12/1980.

Thanks in advance.

Comments

  • JedrzejT
    JedrzejT Member Posts: 267
    You have tool to check fields for wrong values in migrate.fob
    I dont remeber exactly , but i think this finds date with very low year.
    If not you can modify this tool a little for your needs
  • pmusu
    pmusu Member Posts: 55
    JedrzejT wrote:
    You have tool to check fields for wrong values in migrate.fob
    I dont remeber exactly , but i think this finds date with very low year.
    If not you can modify this tool a little for your needs

    Thanks for the response.
    Could you please tell me where this file is located, or from where I could download this FOB.

    Thanks
  • JedrzejT
    JedrzejT Member Posts: 267
    Go to partnersource and search for "Microsoft SQL Server Migration Tool for Microsoft Dynamics NAV"
  • David_Singleton
    David_Singleton Member Posts: 5,479
    In all honesty, if you don;t know this then you should not be doing this conversion. contact your partner and get help from them.
    David Singleton
  • kine
    kine Member Posts: 12,562
    David Singleton wrote:
    In all honesty, if you don;t know this then you should not be doing this conversion. contact your partner and get help from them.

    The SQL migration is work for your partner, becuase even if you will have the tool for checking the dates, you will not be able to change the date in posted entries.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories