Skip to main content

Notifications

Announcements

No record found.

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

The Vendor cannot be deleted.

(0) ShareShare
ReportReport
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,810 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans