Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
Options
How to create a process only report to create Posted sales invoices data explicitly?
Ashu8
Member Posts: 14
Accidentally we got our posted invoices deleted how to explicitly enter data in Sales invoice header and sales invoice line by a process only report?
0
Answers
No. Printed must have a value in Sales Invoice Header: No.=XXXXX. It cannot be zero or empty.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
You need a developer license, to create the object that does the job.
Then, you either have to set the Permissions Property, or run the object with the developer license.
But likely it is more usefull to restore your SQL database to a point in time just before the delete happened and then copy the data of the relevant tables using SQL.
Check the OnDelete trigger (including any subscriptions) of any table you restore in order to collect the set of relevant tables.
Unless any OnDelete trigger modifies data that remained in the database after the delete is done, it is save to restore posted data in this way. Just make sure you don't forget any tables.