web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

link between invoices client details

(0) ShareShare
ReportReport
Posted on by

I can not understand the link between the invoices table SOP30300 with the client details

Thanks

sergio

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bill Campbell Profile Picture
    12 on at
    RE: link between invoices client details

    Sergio, are you talking about how to know what record in SOP30300 is linked to the client master table?

    The only way to link the two tables is by going back to the SOP30200 where the SOPNUMBE is the link between the two tables.

    In the SOP30200 the Customer ID / Name and other details are found there.

    Hope this is what you are looking for.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: link between invoices client details

    Sergio,

    Your question is not very clear. Can you be more specific about your requirement?

    As said by Mr.Bill, the only link between the SOP30200(Header table) & SOP30300(Line Table) is SOPNUMBE and they are history tables, when the Invoice is posted, this tables inserts the records from the SOP10100 (Header table) & SOP10200 (Line Table).

  • Community Member Profile Picture
    on at
    RE: link between invoices client details

    thanks, the information was helpful

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans