News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Re-use a previously de...

Finance | Project Operations, Human Resources, ...

Answered

Re-use a previously deleted number sequence value

(1) Share

Report

Report

Posted on by Jason0810M

Hello,

I have a scenario where I have added a custom field EDT XXXValue in the CustTransOpen table which is associated to a number sequence reference.

It should generate a new number sequence reference (e.g. 00001) whenever there are marked for transactions (i.e. records of SpecTrans).

However, if all marked records are unmarked (i.e. no spec trans association to the CustTransOpen) then the field value should be set to empty.

If the user wish to remark records, the value 00001 should be reused (if this value is not used in any CustTransOpen).

I have tried retrieving the value 00001 in the logic of spec trans delete and check if there are any CustTransOpen.XXXValue==00001.

If there are no existing records, then I am calling the logic NumberSeq::releaseNumber(numbersequenceID, 00001).

It is not working though.

Anyone knows how this could be done

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Jason0810M on at

Like (0)

Report

Re-use a previously deleted number sequence value

Hello Andre,

The business need is that a custom number sequence field needs to be added on CustTrans/VendTrans when doing settlement.

All custTrans/vendtrans within same settlement logic needs to be filled with that number sequence (e.g. 0001).

However, the field needs to be cleared if all the concerned settlements are cancelled.

Therefore, the value 0001 is not being used anymore.

If ever a new settlement is performed, the value 0001 should be available to be used again.

I have managed to do it.

I had set the numseq to Continuous and what was missing was setting the parameter _makeDecisionlater=true in the method NumberSeq::newGetNum when generating the number sequence.

This fixed my issue.
André Arnaud de Cal... 291,684 Super User 2024 Season 2 on at

Like (0)

Report

Re-use a previously deleted number sequence value

HI Jason,

Can you tell what exact business requirement you try to solve with the new field and the number sequence? What is the added value for the organization?

Anyway, did you setup the number sequence itself to have the field Continuous enabled?

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,414 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans