Boy when a programmer screws up they can really make a mess of your data files. A recent program update really screw-up my inventory files. I went from 45K in retail inventory to 750K. It all because he was recalculating the stock movements. Now I got deleted items going all the way back to 2014. And his cure would be even worst possibly so I am manually redoing my inventory. Even then I having to run an error correction as it throws even more errors. Programmer and I have been at this for over a week now. Going back and forth. First he tried blaming it on my network since I had been using Wifi but I switched 6 month ago to hardwired version. After about 4 days he finally admitted it was his screw-up as other reports started coming in.
He got me to send my stock movement file to him and he found that over half of my stock movement records got deleted by his subroutine. Some were incoming but most were outgoing.
But at least we got it figured out now so it is just a matter taking long time finding all the screwed up stock movement records. For me it just a major pain redoing the physical inventory that I just completed back February. Now I got to do all again, this time while running the shop at full steam otherwise.