How can I update the Vendor ID with new number seq by sql via code?

(0) Share

Report

Posted on by Harshal Jain

162

I want to update the vendor id across all the legal entities according to the custom number sequence defined. Can any one please share how one can fetch the number sequence of vendor ID via code?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Harshal, Please check below article. There is a method numRefVendAccount in VendParameters table.

community.dynamics.com/.../how-to-find-next-value-from-sequence-number-when-sequence-number-reference-not-in-parameter-table

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report
Copy link

Link copied!
sequence = NumberSeq::newGetNum( NumberSeqReference::findReference(extendedTypeNum(VendAccount))); info(sequence.num());

Hi Mohit,

I have used the following code to generate the number sequence, but its returning blank. Any suggestions?

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!
Please check if number sequence for vendor account is setup in Account payable parameters.

Check the number sequence is setup properly, please try this code and debug where its failing. Also, please check if number sequence is working correctly when vendor is created manually from All vendors form.

_sequence = NumberSeq::newGetNum( VendParameters::numRefVendAccount());

Was this reply helpful? Yes No