End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
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 and Operations TechTalks | Customer Engagement TechTalks | Talent 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