Skip to Content
Aug 06, 2018 at 06:14 PM

Simple SQL report for Customer Name and RDR1.ItemCode

135 Views Last edit Aug 14, 2018 at 07:39 AM 2 rev


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