Finding Invoices from Sales Orders

[Richard1473]

I am writing an aspx web page that displays invoices and invoice status, paid or not paid, by customer. The invoices that are displayed will be driven by customer number and/or by sales order. I've been successfully in searching customers, but have been unable to locate sales orders by customer and linking sales orders to invoices. Is there a direct link between sales orders and invoices or is there another or better way to find one from the other?

Richard

 

[jazgeek]

original order number is the field on the invoice that will link you back to the sales order.

keep in mind, you may have multiple invoices for a single sales order.

-----------
and they wonder why they call it Great Pains!

jaz

 

[IvoryJoe]

Use the Master Number

 

[Richard1473]

Thanks for the response! What tables contain the data I am interested in?

 

[Alcar]

Richard,

you can find that in Greatplains. Log on and go to Tools-->Resource Descriptions--->Tables

Have fun!

Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.

 

[jymm]

I really like the table reference that is on this site - granted you have to sign up and log on, but I have never gotten spammed from them

http://www.dynamicaccounting.net/Downloads/tabid/119/Default.aspx

some other cool things on that page too - take a look there.