Microsoft Dynamics AX (Archived)

Msg. The value 'xxxx' in field 'Serial number' is not found in the related table 'Serial numbers'.

(0) Share

Report

Posted on by PrasitP.

152

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

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PrasitP. 152 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No