Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I've been struggling with accounts schedules in NAV 2009. I've read some instructions in order to get the comparison period formula column, field 14 in the column layout table. Is this available to add in all versions of 2009 or is it possible that this is not an option in some versions and you only have comparison date formula?
As I only have comparison date formula for now, I've been having issues in creating a column layout which gives 12 months actuals including YTD and 12 months budget including YTD. I have managed to find formula to give each month but don't know how to get a current month variance for actuals v budget. Any idea?
Variance for which month you are looking at, what does variance A-B represents to.
You need to Enter Column No. A1,A2 and so on till 12 for actuals & for Budget entries B1,B2 and so on.
Now in your Column No. 27 enter A1+A2 till A12 minus B1+B2 till B12 to get the variance.
Not sure if is this what you are looking for, but you can add some additional Columns Lines to have the Average % between Real Entries and Budget.
Here is a sample of Column Layout
and the result that you can get when running account schedule for a range of dates
Hope this can help you.
Hi Manish, thanks so much for response. Your suggestion on variance only works for the month of January then the variance becomes the same as YTD. Any other ideas?
I'm just trying to get 12 month columns for actuals with a YTD, then 12 month columns for budget with YTD, then a current month variance column and a YTD variance column. I get everything to work apart from the current month variance
Hi Carmen, I'm trying to get 12 month columns for actuals with a YTD, then 12 month columns for budget with YTD, then a current month variance column and a YTD variance column. I get everything to work apart from the current month variance. Your example looks like a YTD example
That's true my sample is YTD but also depends the date filter we use for it.
I was just trying to show how you can add some additional column to get average % between both amounts.
I will try to repro a similar case as yours.
That would be really helpful. Even just for 3 separate months as I'm at a loss!
I just take a look in previous Manish suggestion and in fact it should work if you define different codes for each columns GL Entries and GL Budget Entries instead using always "A" and "B".
Then you have to add an additional line to get the difference between those lines without entering a comparison Date formula.
Hope this can help you.
thanks for your response Carmen but can you check my attached column layout and let me know how to amend to get it to work. Its the highlighted line that doesn't work - how to get the actuals v budget variance for the month so If I view my account schedule at 30th Jul then I get the variance for that month and I also get the YTD variance in another column
A1-B1 means the difference will be shown for only Jan Month.
This is what you need to do for getting variance for each month.
Business Applications communities