Dynamics GP Inventory Orphaned Site OD and Item Records

(0) Share

Report

Posted on by Community Member

Working with a customer who has orphaned items and site ID’s set-up that where created in what appears to be a file import or using some other tool that does not validate INV set-up. I first discovered the orphaned items and deleted those. Then discovered the Site ID’s. Tried to delete. Cannot delete site ID because items are associated. Looked through all of the IV tables and I cannot find an association. Ran Check Links. Check Links added orphaned items back into Inventory. I could delete them again but I’d wind up in the same loop. Plus anytime the customer runs check links those orphaned items will reappear.

Does anyone know how I can determine what item is tied to those orphaned Site ID’s, or how I can remove all records associated with the orphanes?

I thought about deleting the SiteID in SQL IV40700 after I delete the items, but I’m not certain that would resolve the problem either.

Thanks,

Donnette

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Tim W 2,925 on at

Like (0)

Report

You need to look at the records in the IV00102 table as that holds item quantity site information. I would delete the items from the bogus sites in that table (delete IV00102 where LOCNCODE = 'xxxxxx') then try and delete the site again through the interface. If they still wont delete then GP must do a secondary check of transactions posted to sites but I'm pretty sure this is how I have fixed similar.

Best

Tim

Was this reply helpful? Yes No