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

(0) Share

Report

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

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

SOP10100 - Sales Transaction Work (header info)

SOP10200 - Sales Transaction Amounts Work (line info)

Hope this helps,

Was this reply helpful? Yes No
Preeti Sonambekar 1,245 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Preeti Sonambekar 1,245 on at

Like (0)

Report

Thank you so much. You are a great help.

I could successfully get the development help file.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Preeti Sonambekar 1,245 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Preeti Sonambekar 1,245 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Preeti,

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

Was this reply helpful? Yes No