I need to write a report that lists Purchase Orders in the amount of $50,000.00 or more. I have my report written and used the NL function Sum to total the amount field from the Purchase Lines. How do you use this "Sum" field as a filter in the report? I worte the report using Jet Professional and the Data Warehouse.
Date
Votes
2 comments
-
Harry Lewis Hello Margaret -
You would want to use the steps described in Sort by Sum for data sources other than NAV.
-
Margaret Williams Thank you Harry. This worked. I had to change the way my report was written so the Filters were all set on the Purchase Lines table instead of Purchase Header but I got the report I needed.
Please sign in to leave a comment.