Question CAL / FORM DESIGN FILTER

chrini1

Hi Guys,

I have a question regarding changing an existing form. The form contains all items that are marked as "back orders" and goes after the Sales Lines with the following filter:

SORTING(Status, Back Order, Type, No.,Shipment Date; Sell-to-Customer No.) WHERE (Status=FILTER(RELEASED),Back Order=FILTER(yes),Type=Filter(Item))

I would now like to show only those lines, where "Available for Sales" > "Quantity" is. How can I do this?

System is Client 5, DB 4.0, SQL Server.

Thanks for your help!

Christian

kriki

In Navision it is not possible to filter records where a field in confronted with another in the same table.
The only way to do this kind of filtering is looping the records and marking them/putting them in a temptable and then show only the marked records/show the temptable.

My preference goes to the temptable-solution. Marking records is best avoided on SQL because it can put a heavy burden on SQL.