Account Schudeles. Formula

(0) Share

Report

Posted on by JPB 2022

140

About how to add new column in the Schedule Account , I was reading and watching all the videos, here the link!!

docs.microsoft.com/.../bi-how-work-account-schedule

but I couldn't figure it out how to compare the balance until today for this year, with the same pervious year.. like one column 01 to 08 2022, and second column 01 to 08 2021 . I am try with the formula -1FY [1..cp] but it is not working.. Any idea?

Thank you so much in advance

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Robyn2018 Most Valuable Professional on at

Like (2)

Report

Hi Jimena,

Maybe the best option for this is filter date in schedule account and use Row Type:

if you want exactly one day, you can use "date filter" until that day:

Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has verified answer and was beneficial to you.

Roberto Corella

Business Central developer

blog: https://blog.msdyn365bc.es
youtube channel: www.youtube.com/.../UCeIS0DjQXp4R-aWY20PSVyg
Linkedin: www.linkedin.com/.../
Twitter: https://twitter.com/rccorella

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

In your column layout use the Comparison Period Column and set to -1FY. You will have to personalize your Column Layouts page to add the Comparison Period Column.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, Hope the video below helps you, although it's NAV it's almost the same in BC.

https://www.youtube.com/watch?v=FvF4AGt9K84

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

JPB 2022 140 on at

Like (0)

Report

Thank you everyone!!..

And that Video Yun Zhu, is super !!.. I follow the step and she explain super !! how to create the column. Before to post here I started to watched but I didn't understand that is the same system .. So now I Know !!! and is helpful! Thank you so much!

Was this reply helpful? Yes No