Serial number stock reconciliation issue

[Sanath_Udayawansa2]

ERPNext v12.16.1
The scenario here is, We have 40 Nos in stock balance report.
But 30 active serials numbers
We need to adjust this to 12 serials available.
What I have done is just go to stock reconciliation and put 12 serials there and try to submit.

Then I got the error.

[Suresh_Thakor]

Hi, Please check Serial and Batch No in Edit Mode of Line Item,

There are 2 more Serial No could be available greater than Quantity.

[Sanath_Udayawansa2]

The thing is I can see 30 active serials on the serial, but I can see 40 QTY in stock balance and i need to adjust to 12 nos.

So I put 12 serials in this stock reconciliation.

then here I got this error.

[Sanath_Udayawansa2]

I am using 12.16.1 and I have noticed that this serial and qty different issue has resolved in this release. but seems to be no.

Let me know what you think.

[Suresh_Thakor]

Hope this will help !

Positive Stock Adjustment

Hi, For non-serialized and non-batched inventory you can use Stock Reconciliation. For Serialized Items or Batched Items use Stock Entry purpose: Material Receipt and update the extra quantities. You can use an appropriate Adjustment account. In the Stock Reconciliation, you have to use the full quantity, not just the extra quantity. Hope this helps. Thanks Jay

[MartinHBramwell]

Suresh,

Are you aware of any way for a raw material stock item serial number to be transferred to the finished good stock item after a production run?

[Suresh_Thakor]

@MartinHBramwell, can you explain in details with example?

[MartinHBramwell]

Yes, of course. Thanks!

How to connect sub-assembly serial numbers with finished item serial numbers

Definitely looking for suggestions for this. In our case, we have serial numbered containers with a shelf-life we need to monitor. They are deep cleaned and reused, so they pass through manufacturing many times. From what I can see so far, manufacturing subsumes all raw materials. Serial numbered items are simply marked as “Delivered” and cease to be available for any use in ERPNext.

[Sanath_Udayawansa2]

The scenario here is, We have 40 Nos in stock balance report.
But 30 active serials numbers
We need to adjust this to 12 serials available.
What I have done is just go to stock reconciliation and put 12 serials there and try to submit.

Then I got the error.

[JayRam]

I don’t understand your problem completely. Here’s what I understand:

1. You are trying to do reconciliation of a serialized item.
2. You have 40 Nos of this item in the stock balance report
3. 30 active serials - this is what I don’t understand. What do you mean by "Active’ Serials? Plus how come you are saying stock balance is showing 40, however you have only 30 serial numbers? There is something wrong.
4. Now you want to adjust the stock of these serialized items to 12?
5. Make a Stock Reconciliation (I was wrong earlier, with Ver 12 you can use Stock Reconciliation document to correct the stock of Serialized items and batched items) say 12 Nos is the Stock of this serialized items and provide the 12 serial numbers that are in stock.

It should go through.

Thanks

Jay