How to Get Prod Order Line Qty linked to Prod Order Header with Finished Date

I'm new to Jet Reports and hope someone can help with a simple calculation.

I want to find different item type on Prod Order Lines but only on a specific date using the Finished Date in the Prod Order Header

I can count the number of Production Orders finished on specific date using the below

=NL("Count","Production Order",,"Status","Finished","Finished Date",Settings!E6)

To find the item type on line level I am currently using Ending Date field(as below) but our operatives are not changing the ending date to suit the finished date. They are leaving it as calculated by NAV 2017 but they are often finishing early or late so the dates don't match.

=NL("Sum","Prod. Order Line","Quantity","Detailed Item Type","cylinder","Ending Date",Settings!E6,"Status","Finished")

Vince Brown April 19, 2019 19:41

I'm sure I need a LINK= or a Filter but a little unsure how to use this in this calculation

Harry Lewis April 19, 2019 20:18

Hi Vince.

Maybe something like this?

Vince Brown April 19, 2019 20:35

Thanks Harry

I worked it out before your post and now have it working.
Mine is similar to yours

=NL("Rows","Prod. Order Line","Prod. Order No.","LINK=","Production Order","No.","=Prod. Order No.","Status","Finished","Finished Date",Settings!E6)

Cheers

How to Get Prod Order Line Qty linked to Prod Order Header with Finished Date

3 comments