I need to load Invoice numbers related to a specific customer. How can i achieve this? I am passing ‘ARInvoice.RefNbr.CustomerID’ in the report designer parameters but no invoice numbers are displayed. Please help!
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e0cb76a2-fe7d-4e9b-b8f6-a59c1f2d4dca.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/299db8cc-eb9f-4644-aa85-4d80b6bcee73.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/457a4ed0-3cd2-4b72-a200-a142c3306502.png)
I need to load Invoice numbers related to a specific customer. How can i achieve this? I am passing ‘ARInvoice.RefNbr.CustomerID’ in the report designer parameters but no invoice numbers are displayed. Please help!
Hi
What you would need to do is make a custom table which could have this relationship already defined, then you could use it in the report parameter.
it seems there is the ability to filter “certain” parameters by other parameters already selected but it depends on the tables available. check royce’s reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.