Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 296 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Upgrade from 3.60 to NAV2009 - VAT Entry records required/
rsaritzky
Member Posts: 469
Hi,
I'm upgrading from 3.60 to NAV2009. Currently. the "VAT Entry" table has 3.7 million records that are 0.00 and aren't used for anything. "VAT in use" on the G/L Setup record is not checked. We are in the US and don't do any kind of tax processing whatsoever - no Sales Tax, no VAT, nothing.
I'm wondering if it's safe to delete all the records in the VAT Entry table prior to migrating the data. Any opinions?
I'm upgrading from 3.60 to NAV2009. Currently. the "VAT Entry" table has 3.7 million records that are 0.00 and aren't used for anything. "VAT in use" on the G/L Setup record is not checked. We are in the US and don't do any kind of tax processing whatsoever - no Sales Tax, no VAT, nothing.
I'm wondering if it's safe to delete all the records in the VAT Entry table prior to migrating the data. Any opinions?
Ron
0
Comments
As far as deleting the data before the upgrade? May I ask why?
To make sure if it's safe or not, is to look at upgrade step 1 and 2 when upgrading from 3.6 to 3.7 or 4.0 and then to 2009.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
But this table contains only records with 0.00 - there's no benefit from having this data at all. Nothing is reported from it. In fact, I've always wondered if you tell Setup that no VAT exists why it insists on creating empty VAT Entry records.
>As far as deleting the data before the upgrade? May I ask why?
3.7 million records takes quite awhile to go through the data migration step and about 10gb of disk space. If I delete the records prior to the data upgrade step, it saves 1-2 hours of processing time.
>To make sure if it's safe or not, is to look at upgrade step 1 and 2 when upgrading from 3.6 to 3.7 or 4.0 and then to 2009.
If you're talking about Step 1 in the "Upgrading the database" from 3.60 to 3.70, Step 1 is not required if you are on 3.60. The upgrade documentation says "You must only carry out this step in the upgrade procedure if you are upgrading from
Navision Financials 2.00" There's no reference to VAT Entry records in the upgrade documentation.
Thanks for the reply.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
As he said , I suggest to go through the migrations steps. And migrating directly from 3.6 to 2009 is not advisable. Migrate to 3.7 or 4.0 and then go for 2009.
Though I am not clear about the VAt Entry, Normally, the entry tables will have a register table, in which Nav maintains the relationship of the entries between other entry tables. I recommend you to think from this point too before finalising your decisions.
Regards,
Raveendran.BS