0

Turnover per country

Jet Reports Historic Posts

June 17, 2010 15:17

None

Follow

Hi all,

I'm busy with creating a report which shows the turnover per country per period.
See attached screenshot.

Is used the following formula:
=NL("Sum";"G/L Entry";"Amount";"Posting date";"01-01-2010..31-01-2010";"G/L Account No.";"8500..8600")

However, I need to add a filterfield (source no.) in this formula which enables me to get all the customers from a certain country. I need to have a link to the 18 Customer table. Can someone help me how to fix this?

Thanks!

• 2010-06-17_1656.png

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts June 18, 2010 07:50

  Do you really need to use G/L? The customer table has a field that holds the sales value (excl VAT). Check F1 in NAV to learn more about this field if you want.
  
  In your report it would be something like this for each country.
  
  =NL("Sum";"Customer";"Sales (LCY)";"Country/Region Code";RefToColumnB;"Date filter";"01-01-2010..31-01-2010")

• 0
  
  Jet Reports Historic Posts June 18, 2010 12:47

  Thanks for your reaction.
  
  But yes, I need to use the G/L account table. I only want the amounts booked on certain nominal codes. The customer sales (LCY) table shows all amounts, even the ones being booked on other nominal codes.

• 0
  
  Jet Reports Historic Posts June 18, 2010 14:13

  Nominal codes… Interesting… Well, then you could try this:
  
  =NL("Sum";"G/L Entry";"Amount";"Posting date";"01-01-2010..31-01-2010";"G/L Account No.";"8500..8600";"Source No.";NL("Filter";"Customer";"No.";"Country/Region Code";ReferenceToB))

• 0
  
  Jet Reports Historic Posts July 05, 2010 14:43

  Ok thanks for your reply.
  
  But the formula gives an error, see attached file (supposing you are Dutch :))
  
  Thanks,
  
  Tom

  • 2010-07-05_1640.png