Hi All
Just wondering if I can get some help here. Below is what I have so far but it is giving me the error "Invalid Field 'customer no.' ". What I'm trying to get is a list of the overdue invoices from the customer ledger entry table by using a due date of less than today plus the overdue grace days value from the payment terms table. I have changed the location of the quotes multiple times as well as changing the occurences of "=nl or =nf" statements but still no luck. I think it may be to do with the location of the nf(,""customer no."") statement but I'm not sure where to put it.
Any help would be greatly appreciated.
Thanks=NL("rows","Cust. Ledger Entry",,"Document Type",$C$4,"due date","<"&$C$6+NL(1,"payment terms","overdue grace days","code","=nl(1,""customer"",""payment terms code"",nf(,""customer no.""))"),"Closed at Date","''","amount",$C$5,"location code",$C$8,"+customer no.","*")
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
I think it might be easier to split this into several formulas. Normally I don't recommend putting multiple NL(Rows) replicators on the same row, but in this case I think it would be useful. Try something like this:C12: =NL("Rows","Customer",,"Link=","Cust. Ledger Entry","Document Type",$C$4,"Closed at Date","''","Amount",$C$5,"Location Code",$C$8) D12: =NF(C12,"No.") E12: =NF(C12,"Payment Terms Code") F12: =NL("First","Payment Terms","overdue grace days","Code",E12) G12: =NL("Rows","Cust. Ledger Entry",,"Document Type",$C$4,"due date","<"&TEXT($C$6+F12,"MM/DD/YYYY"),"Closed at Date","''","amount",$C$5,"location code",$C$8,"customer no.",D12)
Does something like that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes
Much Appreciated
Please sign in to leave a comment.