Guys I just made a mistake.
I deleted a bunch of old items thinking Navision wouldn't let me delete any item with ledger entries. Now I realise I was wrong. I deleted about 266 items that had ledger entries.
Because I often report off the ledger entry & value entry tables, I would really like to restore this data.
I have all info in a backup database.
Is it possible to restore all information from these items as if I had not deleted them?
Thanks so much for the help!
0
Comments
Now you can do only one thing that insert the ledger enters manually with the same no. very carefully. If you follow any other process that may have some other impacts.
So what you need to do is restore the back in a separate database. copy and past the items that you want to restore. Then write a routine to fill the item not in value entry and item ledger entry.
You can still run your reports on the ledger. it just that the item will be blank.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Basically, if you run your reports based on item will not match the reports based on customers if the item ledger has blank item numbers on the item ledger.
It's okay so long as the customers understand the consequences.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
http://www.BiloBeauty.com
http://www.autismspeaks.org
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Create a simple report on the item ledger entry, Group this by "Item No.", give this report any table permissions required.
Create a function in the report called CheckItem with a local variables, Item type Record, Value Entry type record, and any other tables like Item unit of Measure etc:, and on the group header or footer call the function after the standard code.
Add code to insert the units of measure from the values in the Item Ledger, or value entry, also from the item ledger you may be able to get the dimensions, and other static information.
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com
Items as required
All Default Dimensions for Table 27 Item
Tables you would need to export all records for.
Item Unit Of Measure
And if required
Item Bill of Materials
Purchase and Sales Prices
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com
Yes I deleted using F4.
Thanks for all the help everyone!