Geeks With Blogs

News
Microsoft MVP

INETA Community Champions

Join the Movement: Stop Diabetes

Illuminate Every difficult problem can be broken down into simple solutions

I don’t know the exact business reason but someone asked how to identify all sales shipping orders with any negative quantities on them.  They needed to print these separately from the shipments that only have all positive quantities.

Here is one way to solve this problem

In NAV, open Sales Shipment Header

clip_image001

Add a field of type Boolean (The field type should match the value you expect to return from the flow field method.  In this case we will use an exist so we expect a bool but we could have used a Sum, Average, Min, Max, Count, or a Lookup to return a value).

clip_image002

Define it as a flow field and click on the ellipse next to CalcFormula

clip_image003

clip_image004

Now [Has Negative Qty] is false if no negatives exist

clip_image006

And [Has Negative Qty] and true if a negative exist

clip_image007

So it is ready to be used as a filter on the report.

clip_image008

Don’t forget that if you are using it in code, you may need to CalcFields.

Hope that helps.  If you really can’t afford the field in your header, you can use code to check the lines for a negative value each time and use a skip or break function to skip that header record but it seems expensive to check them all if you only want a few to print.

Please let me know if you think of a better solution.

Posted on Friday, March 16, 2012 9:08 PM | Back to top


Comments on this post: Flow Fields in Dynamics NAV

# re: Flow Fields in Dynamics NAV
Requesting Gravatar...
I have a similar scenario.

But instead of being related to a "phisical" field such as Quantity, I need to perform a filter over a FlowField Field.

I haven't found already the way to get the expected results.

It's necessary sth like "CalcFields"?

Thanks.
Left by Jorge on Apr 16, 2013 10:17 AM

# re: Flow Fields in Dynamics NAV
Requesting Gravatar...
Jorge,
You can not filter a flow field. Often you can look at what comprised the flow field and actually replicate that logic. If you use the contact form to send me more details about your situation and what version of NAV and your email address, I would be happy to help further.
Left by Teresa on Apr 16, 2013 10:35 AM

Comments have been closed on this topic.
Copyright © T | Powered by: GeeksWithBlogs.net | Join free