Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

The Vendor cannot be deleted.

Posted on by 562

Hi All,

when I try to delete the vendor am getting below error .

A financial dimension value is based on the xxxxx record and has been used on a transaction. You cannot delete the xxxxx record

The Vendor xxxxx is used in one or more transactions of the following types: Ledger and cannot be deleted.

Tried:

We removed financial dimension for Vendor but still I can't able to remove.

Could you please share any solution

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The Vendor cannot be deleted.

    Hello Tony,

    Did you have any 'luck' so far with the deletion of your vendor?

    Best regards,

    Ludwig

  • Suggested answer
    RE: The Vendor cannot be deleted.

    Hi Tony,

    There's no automatic code to resolve this issue. You have to find the entry connected to this Vendor in the system. According to the error message "Ledger and cannot be deleted." it is some posted transaction. I would record a trace on deleting the entry and there you find where system stops.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The Vendor cannot be deleted.

    Hi,

    Do you have a vendor findim that automatically got created? If so, have you tried deleting this findim value?

    Best regards,

    Ludwig

  • TonyAx Profile Picture
    TonyAx 562 on at
    RE: The Vendor cannot be deleted.

    Hi Osman,

    Thanks for reply, There is no there is no transaction.

    For vendor financial dimension  is mapped in master ,I removed the dimension but not able to delete the vendor

    could pls share any code to resolve this

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,803 on at
    RE: The Vendor cannot be deleted.

    Hi,

    did you check all financial dimension tables related? especially DimensionAttributeValueCombination and DimensionAttributeValueSetItem? if the vendor exists on these tables, remove it.

    Regards.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The Vendor cannot be deleted.

    Hi,

    Do you still have some open journals, pending vendor invoices or purchase order records for this vendor created?

    Try deleting all of those 'pending' records and then try again to delete the vendor.

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans