I am making a Sales Order based Report. I want my users to select a Customer ID and then a customer Ship To Location. I want the Customer Ship To Locations to only be for the Customer ID. Right now I can’t even get the Customer Locations to pull up...How do I make this happen in a report?
I’m including a screen shot of the parameter screen and the relationship tab from the build schema part of the report. Please note, I’m a novice, so any help would be appreciated.
Best answer by hkabiri
=Report.GetFieldSchema('ARPayment.CustomerLocationID,CustomerID')
You do not need to add the ARPayment table to the report.
Let me know how it goes.
+7
Since I’m new to this, I’m not sure how to properly say show me the Customer Location, after I select the Customer.
I tried the syntax shown in the KB article example and I thought the following would work: =Report.GetFieldSchema('SOOrder.CustomerLocationID,CustomerID')
but the Ship To lookup is still blank. Is there a “friendly” name i need to use here?
+7=Report.GetFieldSchema('ARPayment.CustomerLocationID,CustomerID')
You do not need to add the ARPayment table to the report.
Let me know how it goes.
UPDATE - 2/10 - 5:18 PM CST
The drop-down list for the customer ship to locations populated with the statement you sent but when I run my report and select the Customer and the Customer Ship To, there’s nothing on the report. If I run the report and only select the Customer, I get the data I need…
Now what could I be missing???
The statement you sent worked!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
