Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : STD3pRY1NKhLBXBdencMLk
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Product receipt - Numb...
Finance | Project Operations, Human Resources, ...
Suggested answer

Product receipt - Number seq

Like (1) ShareShare
ReportReport
Posted on 26 Mar 2024 05:43:30 by Community member 23

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.

 
 
 
 
 
  • AndrĂ© Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,406 Super User 2025 Season 1 on 01 Apr 2024 at 21:52:26
    Product receipt - Number seq
    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? 
  • Community member Profile Picture
    Community member 23 on 27 Mar 2024 at 03:46:23
    Product receipt - Number seq
    I debugged the standard code, but no value was assigned to that field."
  • AndrĂ© Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,406 Super User 2025 Season 1 on 26 Mar 2024 at 20:46:54
    Product receipt - Number seq
    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. 
  • Community member Profile Picture
    Community member 23 on 26 Mar 2024 at 18:43:59
    Product receipt - Number seq

    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.

  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 20,260 Super User 2025 Season 1 on 26 Mar 2024 at 14:05:32
    Product receipt - Number seq
    Hi,
     
    can you share with us all steps ?
     
    BR,
    Mohamed Amine MAHMOUDI
  • Community member Profile Picture
    Community member 23 on 26 Mar 2024 at 13:46:07
    Product receipt - Number seq
    I tried both scenarios insert method and create method. it's not working
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 20,260 Super User 2025 Season 1 on 26 Mar 2024 at 12:44:25
    Product receipt - Number seq
    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
  • Suggested answer
    Rachit Profile Picture
    Rachit 4,015 User Group Leader on 26 Mar 2024 at 12:14:25
    Product receipt - Number seq
    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.
  • Community member Profile Picture
    Community member 23 on 26 Mar 2024 at 12:09:39
    Product receipt - Number seq
    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;
        }
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 20,260 Super User 2025 Season 1 on 26 Mar 2024 at 08:01:16
    Product receipt - Number seq
    Hi,
     
    can you share with us the code ?
     
    Best regards,
    Mohamed Amine MAHMOUDI

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,406 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans