Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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.
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?
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.
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.
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.
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.
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.
Business Applications communities