Hi,
I'm writing a Jet report for MS Dynamics/Navision to show performance stats on Production Orders. For each Operation we want to see the first date and last date that labor was posted. I used the NL(first) and NL(last) on the Capacity Ledger Entry table and filtered on Posting Date. What I'm getting back appears to be the first Entry Number and last Entry Number for each operation. This produces some inaccurate information because Posting Dates entries are not always sequential. Is there another way to do this?
Formulas:
=NL("First","Capacity Ledger Entry","Posting Date","Prod. Order No.",$F16,"Operation No.",$R16,"Prod. Order Line No.","10000")
=NL("Last","Capacity Ledger Entry","Posting Date","Prod. Order No.",$F16,"Operation No.",$R16,"Prod. Order Line No.","10000")
Gretchen
Date
Votes
2 comments
-
Jet Reports Historic Posts Try the following:
=NL("First","Capacity Ledger Entry","Posting Date","Prod. Order No.",$F16,"Operation No.",$R16,"Prod. Order Line No.","10000","+Posting Date","*")
=NL("First","Capacity Ledger Entry","Posting Date","Prod. Order No.",$F16,"Operation No.",$R16,"Prod. Order Line No.","10000","-Posting Date","*") -
Jet Reports Historic Posts Hi
I tried this suggestion and it worked. Thanks for your help.
Gretchen
Please sign in to leave a comment.