Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
TimSimkins 5/20/2014 3:55:12 PM

Billing email address table

I would like to go into our history for all closed orders and update the Notifications Email Billing field that is pulled from the main customer address.

the reason is I need to update orders with the email address that are in history for a specific customer to make it easier for our accounting people to email orders that are in RETURNS. I need to do am update statement to that field but I don't know where the table is to do it. I tried SOP30100 and SOP30200 and there is no billing address column. If someone can point me the way I would really appreciate that.




Version: GP 10
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables