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

Ashu8
Ashu8 Member Posts: 14
in NAV/Navision Classic Client
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?

Answers

  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    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.

    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • vaprog
    vaprog Member Posts: 1,163
    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.

Categories