Finance | Project Operations, Human Resources, ...

Product receipt - Number seq

(1) Share

Report

Posted on by DP-27040853-0

Hi All,

I'm currently working on generating a custom number sequence for product receipt in purchase orders.

I've mapped the number sequence into the NUM field in PURCHPARMTABLE, but unfortunately, it's not functioning as expected. During debugging, I consistently receive a number sequence value, but it's not populating the NUM field.

If anyone has insights or suggestions on resolving this issue, I'd greatly appreciate your assistance.

Thank you.

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

can you share with us the code ?

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
DP-27040853-0 23 on at

Like (0)

Report
Copy link

Link copied!

This is the code I wrote in PURCHPARMTABLE. While debugging, I confirmed that I am receiving the value of the number sequence. However, it is not being displayed in the PURCHEDITLINES form.

public void initValue()
{
Num num;
NumberSeq numberSeq;
numberSeq = numberSeq::newGetNum(purchparameters::numRefproductReceipt());
num = numberSeq.num();
numberSeq.used();

next initValue();
this.Num = num;
}

Was this reply helpful? Yes No
Suggested answer

Rachit 4,015 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Probably your value assignment is getting reset by any standard logic and you will need to debug the process to find it out. Alternatively, you also try extending the insert method of the table.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Try to override the create method on datasource on your form

public void create(boolean _append = false) { super(_append); yourtable.Num= NumberSeq::newGetNum(purchparameters::numRefproductReceipt()).num();; }

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
DP-27040853-0 23 on at

Like (0)

Report
Copy link

Link copied!

I tried both scenarios insert method and create method. it's not working

Was this reply helpful? Yes No
Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

can you share with us all steps ?

BR,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
DP-27040853-0 23 on at

Like (0)

Report
Copy link

Link copied!

The user doesn't want to manually enter values in the Product Receipt, so they requested a custom number sequence for that purpose.

I created a custom number sequence and successfully tested it by assigning the number sequence value to a string variable.

However, the issue arises when tracking the Product Receipt field in the PURCHEDITLINES form, which is mapped to the NUM field in PURCHPARMTABLE.

Although I attempted to assign the number sequence value to the NUM field using methods such as initvalue(), create(), and insert(), the Product Receipt field continues to have a null value.

I'm unsure where the mistake lies in this process.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,846 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Did you check the comment from Rachit? He mentioned that the value might have been overwritten after the number sequence value was set to the NumberSeqTable.Num field in your code extension.

Was this reply helpful? Yes No
DP-27040853-0 23 on at

Like (0)

Report
Copy link

Link copied!

I debugged the standard code, but no value was assigned to that field."

Was this reply helpful? Yes No
André Arnaud de Cal... 306,846 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

So you mean to say that the num variable did get a value assigned, but in the same method this.Num was not getting the same value?

Was this reply helpful? Yes No