web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error on deleting fixe...
Microsoft Dynamics AX (Archived)

Error on deleting fixed asset after deleting transaction using SysDatabaseTransDelete class

(0) ShareShare
ReportReport
Posted on by Asif Kunimmal 90

Dear All,

I am trying to delete fixed asset from the fixed asset master after running the class SysDatabaseTransDelete.

Error msg "A financial dimension value is based on the FA1 record and has been used on a  transaction. You cannot delete the FA1 record"

Thanks

Asif

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Asif Kunimmal,

    Has any transaction been recorded for this fixed asset?

    Can you check whether you can identify a default financial dimension Setting at the value model of this fixed asset?

    Best regards,

    Ludwig

  • Asif Kunimmal Profile Picture
    Asif Kunimmal 90 on at

    Hi Ludwig,

    All transactions are deleted after executing SysDatabaseTransDelete class. Fixed asset still open & value model of this item has department & cost center dimension.

    I deleted value model from this item & tried to delete FA but still same error.

    Thanks

    Asif

  • Suggested answer
    Asif Kunimmal Profile Picture
    Asif Kunimmal 90 on at

    Thanks Ludwig,

    I deleted the entry from DimesionAttributeLevelValue table for the fixed asset id & deleted now.

    Thanks

    Asif

Under review

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans