Our Fixed Asset table (table 5600) contains about 1,038 records whose primary key ("No." field) appears to contain invalid or hidden characters at the database level. These records are visible when listing the table but cannot be opened, edited, repaired, or deleted through the application. As a result, the Fixed Asset list page no longer displays at all, and the Fixed Asset module is effectively unusable in Production.
I would look at using the Table Data Editor tool that is free to use. It can be risky using this tool but it will let you look at the table for fixed assets and see what it casuing issues: Table Data Editor for Business Central
You can also turn off the data validation for the fixed asset table and then look at those records, change the No. if needed or even delete them (only do this if there is no activity against them).
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
3,214
