Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sara Sharkey]

I am in the process of building out our balance sheet in the account schedule area and am having issues with pulling the previous fiscal year information.  The current year MTD and YTD information is pulling correctly, but the Previous MTD and Previous YTD information is not.  When drilling down, I see that these two areas are only pulling information through 01.31.2018, not through the current date of the previous year.  

My comparison period formula shows as:  -1FY[1..CP]

Any information on how to fix this would be greatly appreciated!

Thanks!

——————————
Sara Sharkey
Accountant
Compax
Salt Lake City UT
——————————

[Jamie Constantine]

Do you close accounting periods?   is there a possibility that you close by month and stopped at 1/31/18?

——————————
Jamie Constantine
Columbus Global
——————————
——————————————-

[Sara Sharkey]

We close every month- that process is continual, so I don’t believe that is the issue.

——————————
Sara Sharkey
Accountant
Compax
Salt Lake City UT
——————————
——————————————-

[Jillian Bishop]

The formula for we use for PY MTD is -1FY[CP]…it looks like you have the prior YTD in both lines and our Prior Year YTD is Net Change not Bal @ date.  Here is our setup: 

?

——————————
Jillian Bishop
Grundens
Poulsbo WA
——————————
——————————————-

[Sara Sharkey]

Hi JIllian–

I changed our setup to mimic yours, but it created even more issues.  Now my prior year-to-date columns are pulling the same information as my year-to-date columns, with the column that I left blank calculating numbers from an unknown area.

I selected a random amounts in the MTD and YTD columns to drill down on, and it shows me that the filter is pulling dates from 01/01/2019 through 12/31/9999.  The PMTD and PYTD columns are now pulling information from 01/01/2018 through 01/31/2018.

Thanks for trying to help!

——————————
Sara Sharkey
Accountant
Compax
Salt Lake City UT
——————————
——————————————-

[Jillian Bishop]

Well, that stinks, sorry! The one other thing that comes to mind is the schedules are really picky about the date filter when you do the overview.  Best of luck!!

——————————
Jillian Bishop
Grundens
Poulsbo WA
——————————
——————————————-

[Crystal Tollison]

Sara,
Check and make sure your Accounting Periods are created. Getting that ’12/31/9999′ date will often happen when your periods don’t exist. ?

——————————
Crystal Tollison
Consultant
ArcherPoint Inc.
Lawrenceville GA
——————————
——————————————-

[Amanda Mayer]

– take a look at the link below. has put together a pretty extensive blog specifically for account schedule builds.

https://dynamicsnavfinancials.com/account-schedule-examples/
???

——————————
Amanda Mayer
New View Strategies
Milwaukee WI
——————————
——————————————-