How to update the Next value of Number Sequence using OData

(0) Share

Report

Posted on by Carlo333

Hi,

I'am trying to update the Number Sequence "Next" value using OData

var sequence = context.SequenceTables.Where(x => x.NumberSequenceCode == "Inve_184" && x.Company == "USMF").Select(e=> e);

DataServiceCollection<SequenceTable> dscSequence = new DataServiceCollection<SequenceTable>(sequence);

foreach(var i in dscSequence)
{
i.Next = i.Next + 1;
context.UpdateObject(i);
}
context.SaveChanges(SaveChangesOptions.PostOnlySetProperties);

It throws an error that I can't update it when the Number Sequence is "In Use"

Is there any way to update the Next value via OData or REST API?

Regards,

John Carlo

I have the same question (0)

All responses (5)

Answers (1)

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

Hi John,

Why do you want to change the Next value? What is your business requirement?

Was this reply helpful? Yes No
Carlo333 10 on at

Like (0)

Report

Hi André,

We are trying to automate Inventory Adjustment Journal header and Lines Import.

First thing is we need an inventory adjustment journal, but after creating an inventory adjustment journal via OData. it won't increment the "Next" value of the number sequence associated with it.

We want to create an Inventory adjustment Journal via OData at the same time the number sequence should increment so we can still manually create the journal if needed which right now throws an error "Journal already exist" because the number sequence didn't Sync or increment when we use OData

Regards,

John Carlo

Was this reply helpful? Yes No
Verified answer

huijij 19,811 on at

Like (1)

Report

Hi Sir,

The NumberSeqRecordFieldHandler class enableNumberSequenceControlForField will generate the value of the field we pass in the parameters with the next value from the sequence we select.

You can try it in combination with OData:

e.g.

Hope it help you.

regards

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

It seems that you're trying tio mask a bug rather than fixing it.

How are you assinging the number from number sequence? If it's done correctly, the number sequence will be updated, as in all cases in the whole system where number sequences are used. Don't you actually assign the number by yourself, instead of using the number sequence framework.

And by the way, please use Insert > Insert Code (in the rich formatting view) to paste source code to the forum.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Carlo,

Please explain how you are retrieving and set the number sequence value. Have you tried leaving the journalID field empty? I think it should then allocate a new journal number during the insert action.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to update the Next value of Number Sequence using OData

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to update the Next value of Number Sequence using OData

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates