Finance | Project Operations, Human Resources, ...

The Vendor cannot be deleted.

(0) Share

Report

Posted on by TonyAx

570

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

I have the same question (0)

All responses (6)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: The Vendor cannot be deleted.

Hello Tony,

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

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Michal Krejza on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
TonyAx 570 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

OsmanIstanbul 2,818 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No