You’re offline. This is a read only version of the page.
150
Dear Expert,
I try to do some transaction in Inventory movement and when select the serial number it will
show the msg. "The value 'FGL230440U7' in field 'Serial number' is not found in the related table 'Serial numbers'."
as screen below.
I'm not sure what I do something wrong or something need to do for this
Could anyone give advice for me.
Thank you in advance.
PrasitP.
*This post is locked for comments
Hi PrasitP,
In addition to what Andre mentioned above, also find out how someone may have deleted the data. Either through AX or SQL. Verify if you can delete serial number after transaction is posted, if yes, you need to get some work done there to make sure this doesn't happen again.
Thanks,
Satish Panwar
Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
Hi Prasit,
Also the On-hand is presenting information from the InventDim table, not the InventSerial. You have to find out why the table is empty. Probably, you can check some backups to see if the table was filled at a certain moment. A developer would be able to recreate records based on the InventDim and InventSum tables.
Dear Both,
Thank you for your reply, As I checked the InventSerial table is empty.
But I can see this the serial number in Inventory transaction or Inventory On-hand as below
I'm not sure may be something wrong in the setup of Tracking Dimension or other.
Could you please advise me how to check and correct it.
Thank you.
PrasitP.
Hi PrasitP,
As Andre mentioned, first check if record exist in the InventSerial table. If not found, create record in this table and it should work for you. In addition, try to find out why the record may have been deleted in first place. Use same serial number and the item number for it to work.
Thanks,
Satish Panwar
Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
Hi Prasit,
The value which is presented on the form is a serial number stored in the InventDim table. This has a relation with the InventSerial (Serial numbers) table. Can you check if the record itself is still available in the InventSerial table?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (