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!
Question
Need to assign lot/serial attributes without receiving product
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.