Pages

Monday, November 4, 2013

Delete Item Site Assignment

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:

before

After deleting the assignment, the records will be completely deleted from IV10200 and IV10201 as shown below.

delete

after

 

Best Regards,
Mahmoud M. AlSaadi

2 comments:

  1. Hi Mahmood, if the sites that are aimed to break links on are no longer used, would there still be any impact. The historical data would already be stored and if the sites aren't used they wouldn't be present in the 101/102 tables. Am I missing something here?

    ReplyDelete