Account Schedule Monthly Column???

SilvaSilva Member Posts: 281
Hi,

Im having dificulties in setup in Account Schedule, I want to Set up the Column Monthly Ex Jan., Feb, Mar,....Dec. Any one can help me..Hoping for you reply. Thanks

Answers

  • i4tosti4tost Member Posts: 208
    I usually use fiscal year. There is very good example in standard NAV help system related to fiscal years.
    In Comparison Period Formula column write FY[1], FY[2]...
    Also you can use M1, M2 in Comparison Date Formula. Then make sure, that you selected Month as a period when calculating values.
  • ssinglassingla Member Posts: 2,973
    Use different columns with Calculation Date formula as -1, -2 ...... and so on. While running you need to select current month as date filter and rest column calculation will follow automatically.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • SilvaSilva Member Posts: 281
    Hi,

    Thanks for the support, I will try that. Thanks you very much. =D>
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,499
    [The use of [SOLVED] in the Topic Title is no longer supported. Please edit the first message in the thread and use the field Attribute (below the Subject-field) to put a green checkmark next to the Topic Title]
Sign In or Register to comment.