Hi
I hope someone can help.
I am trying to do a report where i return the last entry in a the Subcontractor Ledger Entry table for each subcontractor, to give me a list of the last time a valuation was done for each subcontractor. When i have tried to use the last NL function, this only returns the very last entry in the table, but i need this for each subcontractor.
Due to the fact that thousands of valuations are posted each week, the run time on the report i have done is ridiculous, as i have only been able to return all of the rows over a given period.
What i have done on this is simply:
Cell F1: =NL("Rows","Subcontractor Ledger Entry",,"Sub-Contractor No.",$C$5,"Document Type",$C$3,"Posting Date",$C$2,"Labour Only",$C$4)
Cell G1: =NF($F7,"Posting Date")
Cell H1: =NF($F7,"Sub-Contractor No.")
If someone could give me some advice i would really appreciate it.
Many thanks
Tony Black
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Tony,
So I'm assuming you actually have a table called Subcontractor (these aren't standard NAV tables, but if you have a ledger entry for it then I would assume you have the entities as well). Since you want the last ledger entry for each subcontractor, it sounds like you would want to replicate subcontractors using NL(Rows) and then get the last ledger entry for each of those. It might look something like this:F1: =NL("Rows","Subcontractor","No.","No.",$C$5,"Link=","Subcontractor Ledger Entry","Sub-Contractor No.","=No.","Document Type",$C$3,"Posting Date",$C$2,"Labour Only",$C$4) G1: =NL("Last","Subcontractor Ledger Entry",,"Sub-Contractor No.",F1,"Document Type",$C$3,"+Posting Date",$C$2,"Labour Only",$C$4) etc.
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts That is exactly what i was after, thank you so much for your help
Please sign in to leave a comment.