Net Change

asking Member Posts: 37

2009-06-03 edited 2009-06-03 in NAV/Navision Classic Client

Using A/c Schedule what formula should i use to take out Net Change for every month for last 5 years ?

0

Comments

• 

  Alex_Chow Member Posts: 5,063

  2009-06-03

  Use the Comparison Period Formula on the Column Layouts. The formula will be FY[1..5] (month 1 to month 5).

  Confessions of a Dynamics NAV Consultant = my blog
  AP Commerce, Inc. = where I work
  
  Getting Started with Dynamics NAV 2013 Application Development = my book
  Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

  0
• 

  asking Member Posts: 37

  2009-06-03

  I tried it didn't work, actually i want to display net change in columns in this manner
  
  Jan Feb March April ....... for complete year.

  0
• 

  Alex_Chow Member Posts: 5,063

  2009-06-03

  Use the Comparison Period Formula and setup a line for each month.
  so it would be:
  FY[1]
  FY[2]
  ....
  FY[12]

  Confessions of a Dynamics NAV Consultant = my blog
  AP Commerce, Inc. = where I work
  
  Getting Started with Dynamics NAV 2013 Application Development = my book
  Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

  0
• 

  asking Member Posts: 37

  2009-06-03

  It worked =D> Thanks.

  0
• 

  Alex_Chow Member Posts: 5,063

  2009-06-03

  asking wrote:

  It worked =D> Thanks.

  
  Your welcome.

  Confessions of a Dynamics NAV Consultant = my blog
  AP Commerce, Inc. = where I work
  
  Getting Started with Dynamics NAV 2013 Application Development = my book
  Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

  0
• 

  asking Member Posts: 37

  2009-06-03

  Can i do the same for Vendors, Customers, Bank etc. ? If yes then How ?

  0
• 

  Alex_Chow Member Posts: 5,063

  2009-06-03

  asking wrote:

  Can i do the same for Vendors, Customers, Bank etc. ? If yes then How ?

  
  You have to setup dimensions and use the Analysis by Dimensions granule.

  Confessions of a Dynamics NAV Consultant = my blog
  AP Commerce, Inc. = where I work
  
  Getting Started with Dynamics NAV 2013 Application Development = my book
  Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

  0