0

Create a Report for Multiple Companies on a single database?

Jet Reports Historic Posts

February 19, 2013 14:43

None

Follow

Hi All,

How would we create an "Aged Accounts Payable Report” for Multiple Companies on a single database?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 20, 2013 04:07

  You can write formula for each company in rows like.,
  =nl("Rows","Item Ledger Entry","Quantity","Posting Date","01-07-13..31-07-13","Company=","XXX")
  =nl("Rows","Item Ledger Entry","Quantity","Posting Date","01-07-13..31-07-13","Company=","YYY")
  
  after generated report it will show report in single sheet.

• 0
  
  Jet Reports Historic Posts July 25, 2013 13:23

  We got around this by creating a table in NAV that lists our companies (along with address details, business unit code, etc).
  
  We then use something like:
  B3 formula is "=NL("Rows","Companies","Name")"
  C3 formula is "=NL("Sum","Cust. Ledger Entry","Amount","Posting Date","01/07/2013..31/07/2013","Company=",B3)"
  
  SD