Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2010 - Tables for O...
Microsoft Dynamics GP (Archived)

GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

(0) ShareShare
ReportReport
Posted on by Preeti Sonambekar 1,245

Hi All,

It is regarding the Open Orders/Quotes. I have seen that If the tax details which are attached with the sales order, are deleted from ERP, then while posting the invoice it gives error that Tax group/Tax detail does not exist - unless the order is recalculated.

My utility cleans up tax groups / tax details from GP DB based upon some conditions and before doing that I want to create a simple report for the customer to give him details on all the open orders that he may have to recalculate as the details are going to be deleted.

Can you please tell me in which GP tables all the Open orders/quotes/invoices/returns/fulfillment orders are stored?

Thanks,

Preeti

 

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    Preeti,

    Ron Wilson has something that you can look at for Purchase Orders:  rldu.wordpress.com/.../sql-view-purchase-order-line-items.

  • Preeti Sonambekar Profile Picture
    Preeti Sonambekar 1,245 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    Thanks Frank Hamelly,  L Vail, & Victoria. All the information is really a big help to me.

    @@Victoria: I am looking into the above links and will get abck to you if I have any more questions. Do you have something similar for unposted purchase orders?

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    Preeti,

    You might find these helpful:

    List of commonly used SOP tables and associated information: victoriayudin.com/.../sop-tables

    SQL code that returns all SOP line items: victoriayudin.com/.../sql-view-with-all-sop-line-items

  • Preeti Sonambekar Profile Picture
    Preeti Sonambekar 1,245 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    Thanks again. The documents are really helpful. But again I have a question. you have mentioned that:

    00000 Master Tables

    10000 Work Tables

    20000 Open Tables

    etc etc

    Work Tables are for Unposted GL Transactions. And you suggested for Open Sales Transactions I should use:

    SOP10100 - Sales Transaction Work (header info)

    SOP10200 - Sales Transaction Amounts Work (line info)

    looking at 10 after SOP I know that its a work table, but next three digits could be anything. So is there any further classification on how to choose a particular table, like in above we are using SOP10100 and SOP10200. There are so many other tables starting from SOP10.... So how do I know which one I need to use?

    Also in my case where I want to have all open sales trasaction, are these the only 2 tables? I tried to find this information from GP Report Writer but its not very clear which report to select and which tables to select from a particular report for my purpose.

    Please guide me.

    Thanks,

    Preeti

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    Hi,

    I have an article on my blog that explains the table numbering convention used by GP. Check it out.

    dynamicsconfessions.blogspot.com/.../dynamics-gp-table-names.html

    Kind regards,

    Leslie

  • Preeti Sonambekar Profile Picture
    Preeti Sonambekar 1,245 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    Thank you so much. You are a great help.

    I could successfully get the development help file.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    You can download the GP2010 SDK (Software Development Kit) here - msdn.microsoft.com/.../bb467597

  • Preeti Sonambekar Profile Picture
    Preeti Sonambekar 1,245 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    Thank you so much. I will look into this. One more question - because it is hard to know from GP table names what information they might contain, is there any documentation which can explain what each GP table might be doing?

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: GP 2010 - Tables for Open orders/quotes/invoices/returns/fulfillment orders

    SOP10100 - Sales Transaction Work (header info)

    SOP10200 - Sales Transaction Amounts Work (line info)

    Hope this helps,

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans