Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

AR report which has invoice number and sales order number?

Posted on by Microsoft Employee

Trying to create a refreshable report with aging info (that part I have) but the end user wants the original sales order number on the report.  I'm using RM20101 to get the aging info.  What table would be good to use to add the sales order number?

*This post is locked for comments

  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: AR report which has invoice number and sales order number?

    Hi Deanne,

    I just want to make sure I am understanding this correctly, the user is wanting the Sales Order Number that the invoice Originated from is this correct?

    If that is correct you would want to look in the SOP30200 at the column ORIGNUMB.

    Please let me know if you have any additional questions!

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: AR report which has invoice number and sales order number?

    Hi Deanne,

    The sales order number is in the same table (RM20101). It's the DOCNMBR field.

    Kind regards,

    Leslie

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans