ACCOUNT SCHEDULES

(0) Share

Report

Posted on by TARA BRANDEWIE

Our Fiscal Year is 10/1 - 9/30 but when i do the account schedule overview, view by year, and the date value, I have to fill it in all the time. Is there a way to make that date match the fiscal year without having to type in those dates every time? It defaults to 1/1-12/31 now, even though that's not my fiscal year.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

I believe those accounting period follow the Accounting Period that you scheduled in Accounting Period setup. What is the month that your Fiscal Year starts in Accounting Period? if it is 1/1/year then formula is correct. But if it is 10/1/yy then my theory is wrong.

Was this reply helpful? Yes No
TARA BRANDEWIE 58 on at

Like (0)

Report

Yes, the accounting periods are set up correctly.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Thanks for info. I tested and yes when I select Year it goes for year and not Fiscal Year. Can you try Accounting Period? The other method is in date section use FY

But I could not find any method to make year goes for fiscal year. I hope some other experts can provide more info.

Was this reply helpful? Yes No
TARA BRANDEWIE 58 on at

Like (0)

Report

thank you, I'll test it out next time. If not, might be something they can add to an update.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Please keep us posted. and you are right about update. Maybe ask your partner to send this request to Microsoft or submit your idea here

experience.dynamics.com/.../

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

What do you have in your Column Layouts as the Column Type? There are options from Entire Fiscal Year, Rest of Fiscal Year and others. Regardless of your date range, if your columns are looking to the Fiscal Year, you'll get your correct data.

Was this reply helpful? Yes No
TARA BRANDEWIE 58 on at

Like (0)

Report

Thank you, I'll check that!

Was this reply helpful? Yes No