What is the best way to check Number Sequence already setup ?

(0) Share

Report

Posted on by VoltesDev

Hi guys,

I have created a new Number Sequence for AR module and now shows correctly and nicely in AR parameters Tab Number Sequence. May I know what is the best way to check (in X code) that the number sequence is already set up ?

Usually I'm just using it with this command :

numberSeqNewOrder = NumberSeq::newGetNum(CustParameters::numRef_My_OrderNumber());
numberSeqNewOrder.used();

SalesTable.My_OrderNumber = numberSeqNewOrder.num();

This works fine, if the setup has no done actually there is a system error saying "A number sequence has not been set up for the reference Order number in the area Accounts receivable." but I currently I need to check first before it is being retrieved. Is there an existing method for us just to check first, lets say if it is return false, I can use it to not even start my process, because actually those code above is in the middle of some process.

Thanks,

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

VoltesDev on at

Like (0)

Report
RE: What is the best way to check Number Sequence already setup ?

Hi Ergun,

Yes, the EDT already being setup, also I have filled in the parameter after it.

Anyway, I found out the correct way to do it. Like below:

NumberSequenceReference numberSeqRef = CustParameters::numRef_My_OrderNumber(); if (numberSeqRef.NumberSequenceId) { }

So it turns out I need to "hold" the numberSeqRef first in my own local variable. Cannot use the previous way of code.

Thanks again for helping to the right path.

Thanks

Was this reply helpful? Yes No
ergun sahin 8,822 Moderator on at

Like (1)

Report

RE: What is the best way to check Number Sequence already setup ?

There are two point you must be looked.

1.is there any reference to your EDT at Selected Number Seq (at parameters)

2.Scope of Number Seq

Was this reply helpful? Yes No
VoltesDev on at

Like (0)

Report
RE: What is the best way to check Number Sequence already setup ?

What is actually the return of "CustParameters::numRef_My_OrderNumber()". Understood that this is a custom method but this is exactly with the same statement like the standard only with my own EDT.

Reason is I tried to use like this :

if (CustParameters::numRef_My_OrderNumber().NumberSequenceId) { . . . } else { throw Error(strFmt("@SYS53911", "Order", "@SYS107971")); }

Not sure why this is always bring me to False condition, while I debug this, the NumberSequenceId always 0 although I have setup the number sequence in AR parameter.

For the method in that CustParameters as mentioned is written to be something like this :

[ExtensionOf(tableStr(CustParameters))] final class My_CustParameters_Extension { client server static NumberSequenceReference numRef_My_OrderNumber() { return NumberSeqReference::findReference(extendedTypeNum(My_OrderNumber)); } }

Thanks,

thanks,

Was this reply helpful? Yes No
VoltesDev on at

Like (0)

Report

RE: What is the best way to check Number Sequence already setup ?

It works, thank you

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,822 Moderator on at

Like (1)

Report
RE: What is the best way to check Number Sequence already setup ?

CustParameters::numRef_My_OrderNumber()

Was this reply helpful? Yes No
VoltesDev on at

Like (0)

Report

RE: What is the best way to check Number Sequence already setup ?

Hi Sourav,

Noted with thanks. However this is manual checking and I understand as you are mentioned it is from functional POV. I might need from the technical POV, as I need to write some code, but currently I have no idea what to write.

Anyway thanks again.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: What is the best way to check Number Sequence already setup ?

Hi VoltesDev,

From functional perspective we can say.. there is a references section available in the number sequence which needs to set in order to validate the correct area the sequence is to be used for.

If this is not set, you might get such issue.

Now.. this is not mandatory to set in all cases. Sequences which needs to be set in the parameter level, for those.. this references section is mandatory.

Regards,
Sourav

Was this reply helpful? Yes No