How to create a process only report to create Posted sales invoices data explicitly?

Ashu8

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?

RockWithNAV

Standard NAV will allow you to delete if No Printed is not 0 or else you will end up with this error

No. Printed must have a value in Sales Invoice Header: No.=XXXXX. It cannot be zero or empty.

vaprog

Ashu8 wrote: »

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?

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.