Material/Serial Nbr is "Stuck" in a storage location and can not be moved

[Former Member]

We have a situation created by my customers which has lead to a situation I have never seen before. A material/serial nbr. that is in our Returns location that can not be transfered, issued, removed, or anything via ANY MIGO movement type combination.

This is what happend:

- Customer return processed. Material ABC, Batch XYZ with Serial Nbr. 123 brought into our "RT" StoreLoc.

- Clerk processed MIGO to do a Stock Transfer of this material to another StoreLoc. (PS). He entered in the material ABC, batch XYZ, and a bad serial number 1233. He used a 453 Movement type.

- After realizing his mistake, he processed MIGO again and processed a GI Xfer posting with a 972 movement type to get rid of the bad material/serial nbr. he had just moved to the PS StoreLoc.

- Then he tried to redo the Stock Transfer using a 453 Movement type for the material ABC, batch XYZ, and the good serial nbr. 123, but, he gets a "Deficit of BA Ret.blocked prev. 1.000 EA " error message.

- At this point, he contacts me to ask what can be done.

No matter what we try to do, we can not access this part/serial nbr. combo to move it or issue it or whatever. It is like a ghost now. You can see the serial number via IQ03, but you can not do anything with this part/serial nbr.

Help! Do I need to write an ABAP to physically delete this material/serial nbr from its batch?

[Former Member]

Complete

[Former Member]

Hi,

First of all, I would assume you used customized movement type 972 to 'get rid of' your material ID with wrong serial number 1233 at PS storage location. If this is the case, then this posting did not return the stock quantity from PS to your RT storage location and that why when you tried to make another posting (with correct serial number 123), an error message was popped up as you simply do not have available stock. The solution in this case are -

1) Cancel the posting that you made previously with movement type 972. This cancellation will help return your stock (though with wrong serial number 1233) to PS storage location;

2) Cancel the posting that you have posted to move your stock back from PS to RT (again with wrong serial number). This steps ensure the stock quantity '1' is available at RT storage location;

3) Make another stock transfer (with correct movement type 453 and serial number 123) from RT;

4) Delete the serial master record 1233 so that it can no longer be used.

Cheers,

HT

[Former Member]

HT,

I tried to do the return of the bad serial number back to the RT location from the PS locaton (using a 454 movement code) and I get an error: "Deficit of BA Unrestricted-use 1.000 EA"

Its looking like I am you-know-what out of luck to fix this problem.

All I can think of doing is set the delete flag on the bad serial number material, set the delete flag on the good serial number material, and do a 501 Goods receipt for this material with a new serial number and have our warehouse staff re-serial number this part.

[Former Member]

Hi,

Yes, I can say you are really ''unlucky'' man on earth at present. My detailed process did not take into account the fact that your material item has already been consumed (with the wrong serial number) at RT storage location and that's why you could not be able to complete this particular step. Anyhow, if you have already delete all related records, then any further suggestion might not work, I am afraid.

Cheers,

HT

[Former Member]

May I suggest the following:

First, check MMBE and make sure that the quantity of materials match the number of serial numbers in your storage locations. What I suspect is that the IM count does not match the serial number count that you have in the storage locations.

I am not sure what your 972 movement does because that number suggests that it is a custom movement.

What is the status of your serial number? If you are trying to move it within the SLOC then it should be ESTO. If it is not, then you could just change the status manually to ESTO assuming of course that your return storage location in MMBE and serial nummber count in your storage location will match after you make the change.

[Former Member]

MMBE shows one unit less than the number of serial numbers in the SLOC. (qty 8 vs. 9 serial nbrs).

The "stuck" part (with the good ser. nbr) in SLOC RT shows up in the ser. nbr list with a status of EDEL ELOK ESTO so it looks like the system still thinks it is assigned to the delivery note. The Return delivery was completely processed and posted.

The 972 movement type is a Phy. Inv. Goods Issue adj. code for fixing the inventory totals.

What is the transaction to manually alter the Serial number Statuses? I didn't know you could do that.