I need to be able to assign lot/serial attributes to stock items before actually receiving the item. My team is okay with generating the purchase receipt and filling in the lot/serial attributes on the PR and keeping it on hold until we actually receive the product, but ti looks like because we haven’t actually received the product the lot/serial attribute values don’t live in any particular table. Just confirming that this is true.
Or if anyone has any other ideas of procedures that would be great!
Solved
Need to assign lot/serial attributes without receiving product
Best answer by npetrosov31
Hello
I tried your case and lets see what happened:
- I created a PO Receipt with Serial item and put serial id which is not received yet:
- I put some test value in Attributes and tried to save it. After save the value was still there even after refreshing the page. This means that the value is somewhere in the database and I need to find where it is.
- I looked for the tables in the database schema and found this POReceiptItemLotSerialAttributesHeader table. It contained all the attributes inside but not the values. However there is also POReceiptItemLotSerialAttributesHeaderKvExt table, which already contained values:
-
Depending on how you want to use this values I can recommend you what to do, as this tables with KvExt at the end should not be used directly, they should be used through main tables.
+1Hello
I tried your case and lets see what happened:
- I created a PO Receipt with Serial item and put serial id which is not received yet:
- I put some test value in Attributes and tried to save it. After save the value was still there even after refreshing the page. This means that the value is somewhere in the database and I need to find where it is.
- I looked for the tables in the database schema and found this POReceiptItemLotSerialAttributesHeader table. It contained all the attributes inside but not the values. However there is also POReceiptItemLotSerialAttributesHeaderKvExt table, which already contained values:
-
Depending on how you want to use this values I can recommend you what to do, as this tables with KvExt at the end should not be used directly, they should be used through main tables.
Hello
I tried your case and lets see what happened:
- I created a PO Receipt with Serial item and put serial id which is not received yet:
- I put some test value in Attributes and tried to save it. After save the value was still there even after refreshing the page. This means that the value is somewhere in the database and I need to find where it is.
- I looked for the tables in the database schema and found this POReceiptItemLotSerialAttributesHeader table. It contained all the attributes inside but not the values. However there is also POReceiptItemLotSerialAttributesHeaderKvExt table, which already contained values:
-
Depending on how you want to use this values I can recommend you what to do, as this tables with KvExt at the end should not be used directly, they should be used through main tables.
Thank you!! I searched and searched for which DAC it may be kept in but had no luck. That is all I need thank you!
+1
This table does not exist as DAC, it exists only in the database, do you want to show the values on a GI or a report or somewhere else? There is a way to work with such tables, I can help with that
+1Found it! In 25R1 that data is kept in POReceiptItemLotSerialAttributesHeade
If I remember it correct you need to use it as ‘AttributeBATH’(Attribute[attribute name]) from the POReceiptItemLotSerialAttributesHeader table
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.