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
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.
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.
[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]
Answers
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.
http://ssdynamics.co.in
Thanks for the support, I will try that. Thanks you very much. =D>