how to assign NumberSequenceId = 0 in (NumberSeuquenceReference) table through x++ code for a particular company

(0) Share

Report

Posted on by Community Member

Hi,

Please let me know how could I assign NumberSequenceId = 0 in (NumberSeuquenceReference) table through x++ code for a particular company lets say I have company (207) .

Regards,

Mania

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 303,976 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Mania,

Can you indicate the reason why you want to do this? It is not a normal request. To be able to get the company context, you have to link the NumberSequenceTable with the NumberSequenceScope table which has this information.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Vilmos,

Thanks for your reply. Because The client is having a job by running which again the number sequences will get assigned properly to their respective parameters. However the job will not update number sequence if there is a value already exists.

So for that client wants me to assign 0 to NumberSequenceId , so that he can run the job

Please let me know how could I do that using x++ code

Regards,

Mania

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please use the below job to update numbersequenceId to zero on numberSequenceTable for a given company. With this update you are removing reference to table NumberSequenceTable. Please test it on your test machine before you go further.

static void NumberSequence(Args _args)

{

NumberSequenceTable numberSequenceTable;

NumberSequenceReference numberSequenceReference;

NumberSequenceScope numberSequenceScope;

NumberSequenceDatatype numberSequenceDatatype;

DataArea dataArea;

while select numberSequenceReference

// where numberSequenceReference.RecId == 123 // To operate on specific record

join numberSequenceScope

where numberSequenceScope.RecId == numberSequenceReference.NumberSequenceScope

join dataArea

where dataArea.id == numberSequenceScope.DataArea

&& dataArea.isVirtual == 0 //eliminates virtual company

&& numberSequenceScope.DataArea == "XYZ" // Specify company here

join numberSequenceTable

where numberSequenceTable.RecId == numberSequenceReference.NumberSequenceId

&& numberSequenceTable.NumberSequenceScope == numberSequenceScope.RecId

join numberSequenceDatatype // Holds Id of the EDT

where numberSequenceDatatype.RecId == numberSequenceReference.NumberSequenceDatatype;

{

ttsBegin;

numberSequenceReference.selectForUpdate(true);

numberSequenceReference.NumberSequenceId = 0;

numberSequenceReference.update();

ttsCommit;

}

}

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No