Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

INV_SERIAL_NUMBERS does not show some serial numbers

edited Mar 27, 2021 9:23AM in Reporting and Analytics for SCM 1 comment

Content

Dear ,

I have items serial numbers in which i have transaction id in INV_MATERIAL_TXNS which is join to INV_SERIAL_NUMBERS > LAST_TRANSACTION_ID
it is showing correct serials number but some of them are showing null. means items have created and there transaction id is also shows in INV_MATERIAL_TXNS
but not shows in INV_SERIAL_NUMBERS > LAST_TRANSACTION_ID. Through this i cant see some transactions serial number.
Could you please help me why this is happen?

I want to check my GRN have which serial number so how can create a query for this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!