Hello @BenjaminCrisman ,Thanks so much for your guidance and assistance.The statement you sent worked!!!
Hi @BenjaminCrisman ,But I'm little bit confused. how is it possible without table (ARPayment) =Report.GetFieldSchema('ARPayment.CustomerLocationID,CustomerID')When we are adding this line Location lookup data populated.Could you please elaborate how is going on here...?
Hi @BenjaminCrisman ,When we are selecting the CustomerID and LocationID in lookup filters are not working.Please give me some suggestions.how to fix this?
@NageswaraRaoAddanki60 I’m not really sure why it returns no data, though the same conditions work in a GI, so there must be something in the way Report Designer is seeing the values. Technically these are IDs being retrieved, but even if the ID is used it still returns no results, so it’s strange, but I suspect it is how the report is configured. Are you just modifying the standard Service Order report, or is this all custom report? Yes @BenjaminCrisman , I’m modifying the standard Service Order report.adding new sub report like Inventory Item list.Here showing all service orders getting filters CustomerID and LocationID.
Hello @BenjaminCrisman Yes, you are the correct. The doc type and ref nbr parameters as not required. When we removed this filter , the functionality working fine.Location filter working like this.Location.LocationCD Equal @LocationID Thanks for your support.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.