Hello,
I am writing a report to sum up this formula where fields are coming from 2 tables but it is giving me value error:
=NL("Sum","Sales Invoice Line","=NF(,""Amount"")/NL(,""Sales Invoice Header"",""Currency Factor"",""No."",NF(,""Document No.""),""Source Code"",""SALES"",""Posting Date"",DateRange,""Customer Posting Group"",""@@""&$C7)")
Is this not possible?
Thanks!
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Actually I have a question. Why are you using the Sales Invoice Line table instead of the Sales Invoice Header table or even the Customer Ledger Entry table?
The Sales Invoice Header has an Amount field which sums the Amount field from the Sales Invoice Line table. It also holds the 3 fields you are applying in your filters. You actually don't need these 3 fields from the line to find a header - the document no. is sufficient, but I assume you need them for the logic of your report.
You still need to calculate the LCY value though . "… ("=NF(,""Amount"")/NF(,"Currency Factor"")"….
If you take a look at the Customer Ledger Entry table, things may be even easier. This table has an amount in LCY field already. and the 3 fields you are using in your filters. Additionally, you can use the Document Type field to filter Sales Invoices only…. or include the Sales credit memos at the same time. But that depends on the information you want to report.ou
P.s. I'm using NAV 2009 R2.
Does this help? -
Jet Reports Historic Posts Thanks Hans! You are right. I could simply use Sales Invoice Header or Cust. Ledger Entrty table in my report.
Thanks for your help!
Please sign in to leave a comment.