Throughout the implementation phase, clients are mostly busy with delivering precise and accurate opening balances, without paying considerable attention to other essential details such as: Item-Site Assignment master file. They usually request to assign the item to all sites (regardless of which sites the item is physically assigned to). Later on, deleting this assignment could be one of the riskiest things you could imagine.
An inventory transaction is recorded primarily in the following four tables, which are;
- IV30300 | Inventory Transaction Amount History
- IV10200 | Inventory Purchase Receipt Work
- IV10201 | Inventory Purchase Receipt Details
- SEE30303 | Historical Inventory Trial Balance
On the Item-Site assignment window (Cards > Inventory > Quantities/Site), deleting the Item-Site assignment delete all associated records in both tables (IV10200, IV10201), leaving only (IV30300, SEE30303). Which means, you will lose the following reports:
- Smart List > Inventory Transactions
- Purchase Receipt Inquiry
- Purchase Receipt Report
Below, is a view on the tables on how the records associated with the Item-Site “delete” will be deleted from the Purchase Receipt Layers Work and Details.
Before delete, there are records associated with the item-site assignment:
After deleting the assignment, the records will be completely deleted from IV10200 and IV10201 as shown below.
Mahmoud M. AlSaadi