Does anyone have any ideas that could help. We inadvertently deleted the partbin records in our E9 DB, we have a backup from last night but dont want to restore to that unless we really have to, can you restore a table or insert from another environment just that table?
3 Likes
First - if you have the hardware - I’d create a Dev environment (DB and appserver on the same server) and do all of the testing in that environment.
Best method would be DMT - if that PartBin process is available in E9’s DMT. You can use the backup database table as a source for the records you need. Pretty sure this method is actually doing inventory transactions. Once you do that, you’ll need to make some GL entries to undo the inventory expense entry that will be made - talk this through with your accounting team.
Best of Luck!!
1 Like
Just run the conversion to re-build PartBi from Part Tran. That should re-build any part bin records, that existed back even in E9
Its in the conversions program, In E9 in Server Admin Tools i Progress Land.
3 Likes
Hi Jose, thanks for this, i am just backing up our E9 Environment now to put it into a test environment and will see if that works. 
30 years of working with EPICOR and this is the first massive mistake i have made 
7 Likes
Thanks - I just found this - knew there was something, but got distracted after my first post…
Do we know what the number is in E9, struggling to find it
6430? But don’t quote me on that…
It’s also under the Upgrade/Mass Regen menu in 10/11
6430 Recalculate Part Onhand/Allocation summaries
1 Like
Sounds about right. I would try it wiht one part..
Looks like it is all or nothing on there
1 Like
Welp.. I’d say #YOLO but it ian’t my DB… There could be another one you can run if you find this file in your server (path may be slightly different)
C:\Program Files\Epicor Software\Epicor904\server\cv\cnvprogs.dcd
And open it with notepad and or send it here we can look through it.
After many long hours we are back up and running 
7 Likes
What did you do? Did that conversion work?
2 Likes
Unfortunately it did not. I had to load the backup from Sunday night Even that didnt go 100% as we tried to restore the full SQL backup and then the transaction logs but because the full backup was held on VEAM and the transaction logs were on a physical machine the SQL restore didnt work.
About 20 hours after it going pear shaped i manged to get all the transactions loaded/checked and signed off.
1 Like
One question though, we tried to restore the Overnight Backup and the transaction logs from the SQL Server but it wasnt having it using the Restore task. Is that because the main backup was on VM and the logs were on a physical?