Hi. I have two tables: sales shipment header and sales shipment line. I want to show in a form ONLY the sales shipment header with one (or more) shipment lines where the condition "quantity shipped not invoiced <>0" is true. Using a report it would be easy, but is there an easy way for doing it in a form?.
Thanks,
0
Answers
Create a flowfield in the header table that checks if there are lines connected to that header with "quantity shipped not invoiced" <>0, returning true or false. Then you can use this field to filter in your form.
My world: Dynamics NAV,SQL and .NET
CEO at Solving Dynamics
http://www.solvingdynamics.com
Something like:
But oh my foes and oh my friends, it gives a lovely light
Thanks so much
My world: Dynamics NAV,SQL and .NET
CEO at Solving Dynamics
http://www.solvingdynamics.com
That's quite fast I think.
My world: Dynamics NAV,SQL and .NET
CEO at Solving Dynamics
http://www.solvingdynamics.com