Dynamics Community Forum Thread Details

Transaction Status from Inventory items screen ( 10.250.00) and transfer procedure

A) status change:

1) Need your help to understand what processes would change the Transaction Status from active to inactive?

2) When an inventory item has Available Q'ty >0, why system is still allowing user to change the status to be inactive?

3) if we wanted to change the status back to active status, can I just run a query to update

inventory.tranStatusCode= 'AC' ? any other table that needs to be updated as well?

B) transfer site :

4) If an inventory is transferred from A site to B site permanently, what is the proper procedure to handle this scenario beside processing 'Transfers'?

5) following Q4, when it is done, the default or last Site should be updated from procedure 4, right? if not, how can we update the site ID to be B?

6) would like to run a report that has inactive status that has available q'ty >0 and site id=B. What table and field names should I get it from?

Thanks for your help!

A.1) About the status, please think about a contaminated item, an exploding Ford Pinto model or a product for which you got a recall notice from the manufacturer. Please also consider that "Active" and "Inactive" are not the only options. You can set the "NP" non purchase option as well. The Transaction status may well be a temporary thing: the item is on hold until the problem with it gets solved. In a more cynic approach, the item might be put on hold because is reserved to your boss's brother in law and will be put back on Active when the right purchase order is received.

A.2) Again, think about the Ford Pinto: having Qty >0 is not enough reason not to inactivate it.

A.3) This is correct, setting 'AC' is the right approach.

B.4) I don't think there is a "lockout" option for an item in order to prevent some item-site combinations, if that's what you are thinking. Additional procedures depends on whether you are a manufacturing operation, a distribution company or just a raw materials warehouse. I mean, you should perform a checklist consisting of:

- Open purchase order already set on site A.

- Open work orders already set on site A.

- Open sale orders already set on site A.

- Planned orders already set on site A.

B.5) You are right about the default site ID. But please consider changing default site only affects further transactions. The already open orders remain unchanged.

B.6) The std reports should be enough. The conditions should be ItemSite.QtyOnHand > 0 and Inventory.TranStatusCode <> 'AC'

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)