Hello All,
I wanted to know a way through which i could free the allocated inventory from orders.

1. I executed a query on the table tdinv150 to get the list of various orders for a given item.--To check for the quantities allocated.
2. For the sales orders i checked if the Order is still open (no delieveries maintained - tdsls045). If yes, then by deleting the respective SO line i found the allocated inventory count in Maintain item data also reduced.
3. I want to know how can i clean up the same for Purchase orders, Production orders and other orders.
This is what i tried
-------------------
1. I tried cancelling a released production order and was expecting the allocated inventory to be reduced, instead the inventory on order got reduced.But the particular record no longer appears in table tdinv150.
2. Tried to check if a receipt has been maintained for a PO in table tdpur045, if no tried to delete the correcsponding PO line. But this did not affect the allocated inventory.

i need to develop a session where in the user can check where all the inventory for a particular item is allocated and then clean it up.

Am i right on my approach?? please suugest me a way for this..

hi,

In ln u can find the all allocated inventories by item in Planned inventory transactions.
Regarding deleting those lines depends on th type of allocation,
Like as u tld in sales in production also u can nullify the qty required by negative issue of th item from prodcution order in Material to issue.
In warehouse order u need to delete th line if its created.

Regards,

Hi Smi9475
do u use LN ? or else?
maybe u can use :
outbound order line (which status is not shipped)
inbound orderline (which status is not putaway)

HI,
If you want to fix tdinv150 first then run the session "tdinv0250m000", this will fix the tdiv150 table. This session should be run in off hours.
This will fix the allocation and onorder fields in everywhere besised tdinv150.

I assumed you are refferring to soft allocations only.

Arvind