# How to create this Account Schedule?

**URL:** <https://www.dynamicsuser.net/t/how-to-create-this-account-schedule/9315>\
**Category:** Developers Forum\
**Created:** [November 1, 2004, 1:52am UTC](https://www.dynamicsuser.net/t/how-to-create-this-account-schedule/9315 "2004-11-01T01:52:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wws](https://avatars.discourse-cdn.com/v4/letter/w/43a26b/32.png) [@wws](https://www.dynamicsuser.net/u/wws)\
**Post date:** [November 1, 2004, 1:52am UTC](https://www.dynamicsuser.net/t/how-to-create-this-account-schedule/9315/1 "2004-11-01T01:52:26Z")

</div>

My customer has a report which rows are Sales Revenue, Costs, Profits, etc., the columns are Previous Year, JAN, FEB, MAR, … , Total. I find it’s quite difficult to impletement it using Account Schedule because I am not able to specify the posting date of ledger entries to get the amount of each month. Any solution? Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Rajeshj](https://avatars.discourse-cdn.com/v4/letter/r/f6c823/32.png) [@Rajeshj](https://www.dynamicsuser.net/u/Rajeshj)\
**Post date:** [November 1, 2004, 2:54am UTC](https://www.dynamicsuser.net/t/how-to-create-this-account-schedule/9315/2 "2004-11-01T02:54:46Z")

</div>

Hi, You can use Comparison Period Formula in Account Schedule. For e.g. (Design your Column Layout like this) COLUMN Comparision Period Formula ---------- -------------------------------- JAN FY[1…1] FEB FY[2…2] … … You can play with Comparision Period Formula according to your need. For more detail about formula please refer online help.

---

<div class="post-metadata">

**Author:** ![wws](https://avatars.discourse-cdn.com/v4/letter/w/43a26b/32.png) [@wws](https://www.dynamicsuser.net/u/wws)\
**Post date:** [November 1, 2004, 8:07am UTC](https://www.dynamicsuser.net/t/how-to-create-this-account-schedule/9315/3 "2004-11-01T08:07:32Z")

</div>

Thanks Rajesh! I got it. Actually, I use FY[1] intead of [1…1]. 🙂