Safe to update values in Sales Invoice Header table?
kalapossu
Member Posts: 5
Hello,
I would like to run a few SQL updates to Sales Invoice Header. The fields have no "financial relevance", i.e. they do not affect postings or some such (think e.g. of the "No_ Printed" column). I assume this is safe to do (I know NAV has the Object Tracking table that contains timestamps and doing an update to Sales Invoice Header will update the rows timestamp - but NAV doesn't seem to make any updates to object tracking when e.g. No_ Printed is incremented).
Thank you all!
I would like to run a few SQL updates to Sales Invoice Header. The fields have no "financial relevance", i.e. they do not affect postings or some such (think e.g. of the "No_ Printed" column). I assume this is safe to do (I know NAV has the Object Tracking table that contains timestamps and doing an update to Sales Invoice Header will update the rows timestamp - but NAV doesn't seem to make any updates to object tracking when e.g. No_ Printed is incremented).
Thank you all!
0
Comments
-
Hi,
navision code is stored into objects.
I would do it but first, I would backup database.
If you want to check what navision does with the field you want to update go to object designer and check table and form(s) of that field.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
