Skip to Content
Former Member
Aug 21, 2017 at 02:06 PM

populate SO Cust Ref to Line UDF



First of all this community has been filled with useful answers but I have one that have been unable to find. This is my first actual question I am reaching out to the community for.

So for our needs on a sales order we would like to copy the header customer ref line and copy it to a Sales order Line UDF. I initially thought I could do a formatted search query and trigger it when each line items part was put in. Formatted search query below.

SELECT T0.[NumAtCard] FROM ORDR T0 where T0.[DocNum] = $[8.1.1]

Then it dawned on me that since the Sales order has not been added as of yet there is nothing for the query to pull.

Is it be possible the information being entered in on a Sales order is in a temp table until its actually added or might there be a different way to accomplish what we are looking to do?

We are using SAP B1 9.1 PL3 and are running on windows server with SQL Mgmt Studio 2011.