Hi
I am going to design a form for delivery monitoring. The form is based on Purchase Line. In form u have some fields to filter, like Vendor, Location Code and Purchaser code. It was easy get all Purchase lines with Vendorfilter and Locationfilter. But I am stuck with Purchaserfilter. It is possible to get all Purchase Line based on Purchasercode in form??
](*,)
Is there anyone who have a good solution??
0
Comments
Another workaround is to create a flow field on the purchase line taht will have a Lookup formula to the corresponding Header.Purchaser Code field and then do your filtering.
Oleg
I have not tested it but should work. This sets up a filter on the single value. Setting "real" filter (like 1..4, 8 ) is possible but more complicated
Let me know if that helps
Oleg
Instead, add a Purchaser Code field to Purchase Line table. Add code to Puchase Header - Purchaser Code - OnValidate to update this field on all the lines if it is changed (SETRANGE - FIND('-') - VALIDATE - MODIFY(TRUE), check them out in C/SIDE help). Also add code to Purchase Line - OnInsert to grab the Purchaser Code from the header (GET - VALIDATE, nothing else. Check GET in C/SIDE help).
You make the choice anyway: either you lose some performance during creation of the order, or during reporting. Usually I look what is done more ofthen and by how much more often.
Oleg