I am looking to create a SQL report which looks at CustomerCode/Name From SAP b1 sales order form... I am pulling the ordr table and the rdr1 table through an inner join.
My first parameter is $[$4.0.0] which successfully pulls Card code from the sales order from ordr
My next parameter is $[$38.0.0] and I want to pull item lines...
My goal is to check the current sales order to display the items on the sales order against the customer, to show what recent transactions have been made on these products, including quantity and price
Everything is working except the second parameter.
Thanks for any help