Posted by: IS | April 19, 2013

GP Manufacturing Order to Sales Order link

One of those days. Took me an age to find the relevant table. Eventually copped on to myself and reached out to a pal in the US who didn’t even have to look at Resource Descriptions to tell me. For those in the same boat – here’s the answer.

When you create a newDynamics GP Manufacturing Order based on a Sales Order the link information is stored in table IS010001 (ICONrol Sales Order Line). Remember that each sales item line on a sales order will create an individual manufacturing order to make that product. So this table also stores the sales order line item sequence number.

A quick query (where ???? is the manufacturing order number) would look something like:


Additionally table WO010032 (Manufacture Order Master) may contain the Sales Order number in the DSCRIPTN field – if users haven’t overwritten the Description field when the manufacturing order is created.

Hopefully save someone some time!


  1. […] Ian Grieve delivers a SQL Query around GP Manufacturing Order to Sales Order link […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: