Finance | Project Operations, Human Resources, ...

Renaming primary field (Vendor ID) issue

(0) Share

Report

Posted on by Sampada B

Hi there,

I was trying to rename the vendor account in "All Vendors" from UI using Options--> Record info--> "Rename" button from D365 F&O.

The vendor account got renamed successfully and is visible in UI . But when I am trying to create "Vendor payment journal" for this newly renamed vendor , I am getting below error : Vendor "XX" doesn't exist.

There is no custom code involved in this.

Please let me know if anyone has any suggestions.

Appreciate your help !

Thanks,

Sampada

I have the same question (0)

All responses (12)

Answers (0)

Sort by

AnithaEswaran 2,032 on at

Like (0)

Report
Copy link

Link copied!

Hi Sampada,

Are you trying to create the payment journal immediately after this change?

This action might take time as mentioned in the form option.

Was this reply helpful? Yes No
Sampada B 10 on at

Like (0)

Report
Copy link

Link copied!

Yes. I waited for hours before creating the Payment journal, but no luck.

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report
Copy link

Link copied!

Have you tried restarting the service ?

Can you check if the table relation is defined in Payment journal ? I remember, table relation is not defined, such updates are skipped.

Was this reply helpful? Yes No
Sampada B 10 on at

Like (0)

Report
Copy link

Link copied!

Anita,

Service restart was tried and there was no luck. There is already table relation as per standard.

Actually it is trying to find the original vendor account in LedgerTrans table --> findvendTable() when I am trying to create the journal with the renamed vendor account. Some how the new renamed account is not getting referenced hence even the error message says "original vendor account doesn't exist".

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Sampada B,

Try full DB synchronization.

Thanks,

Girish S.

Was this reply helpful? Yes No
Deepak Agarwal 8,989 on at

Like (1)

Report
Copy link

Link copied!

Try to reset your user usages data and full DB synch.

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report
Copy link

Link copied!

Hi Sampada,

If you have access to SQL, can you check if the new vendor account is present?

Was this reply helpful? Yes No
Sampada B 10 on at

Like (0)

Report
Copy link

Link copied!

Anita,

Yes. Its present . I am able to create purchase order with the new renamed account where as Payment journal is only giving this issue.

Was this reply helpful? Yes No
Sampada B 10 on at

Like (0)

Report
Copy link

Link copied!

Girish,

We have already tried full db. sync and that didn't resolve the issue.

Deepak,

Tried with "Reset usage data" , but no luck.

Thanks,

Sampada

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are you saying you have an open balance in the previously named vendor and you trying to use the new account?

Can you try creating a payment journal without any invoices marked? if working then you may have to create a payment journal and then mark the same for settlement manually.

Was this reply helpful? Yes No