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
Hello Tony,
Did you have any 'luck' so far with the deletion of your vendor?
Best regards,
Ludwig
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.
Hi,
Do you have a vendor findim that automatically got created? If so, have you tried deleting this findim value?
Best regards,
Ludwig
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
Hi,
did you check all financial dimension tables related? especially DimensionAttributeValueCombination and DimensionAttributeValueSetItem? if the vendor exists on these tables, remove it.
Regards.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156