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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Getting daily sales
Microsoft Dynamics GP (Archived)

Getting daily sales

(0) ShareShare
ReportReport
Posted on by juanmanuelsanchez 230

Hi all ! I need to know from wich table I should get the daily sales (SQL). Info like: QTY, Price, Client,Date,porduct number, location code and country.

 If you only tell me the tables I can find the fields no prob :)

Is there anything about this table that I should know? does it changes depending on the year? or all the records are stored within the same database table?

 Thanks a lot.

 Juan Manuel

*This post is locked for comments

I have the same question (0)
  • K Day Profile Picture
    K Day 7,365 on at

     Sales Order Header Work (Unposted) SOP10100, Line is SOP10200

    Historical Orders - Header SOP30200 and line SOP30300

     

  • Hossam Fathy Profile Picture
    Hossam Fathy 2,611 on at

     you can use smart list ( Sales Line Items or Sales Transactions ).

  • juanmanuelsanchez Profile Picture
    juanmanuelsanchez 230 on at

    sorry but Im very new to Dynamics and what Im doing is writting a program that uses Dynamics tables to query some info.

     I have looked into SOP10100 and all the info seems to be there, but I dont understand what you mean by LINE SOP10200?

    Thanks!

  • Hossam Fathy Profile Picture
    Hossam Fathy 2,611 on at

    In the invoice there are many sold items called lines so In SOP10200 you will find the invoice details.

  • K Day Profile Picture
    K Day 7,365 on at

    Header information pertains to the entire transaction, such as Customer Info, Payment Terms, Freight Amount, etc..

    Line Information is the One-to-Many relationship to the header.  For example, I may have a sales order where I sell 10 Units of Product A to my customer.  The next sales order may have 10 Units of Item A, 10 Units of Item B, and 20 Units of item C.

    The join on these 2 tables is SOPNUMBER and SOPTYPE

    The line Table will contain the QTY, Price, Item, etc...  THe header will contain who it was sold to and the rest.  Play around with it and you will figure it out.  It is always helpful to go into the front end and look at a transaction in GP Sales Order Windows and compare it against what you see in SQL.  That also helps figure out what the somewhat Cryptic Field Names in SQL refer to.

  • juanmanuelsanchez Profile Picture
    juanmanuelsanchez 230 on at

    thanks I get it now :)

     You were all really helpfull !

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans