Account Schedule

ricky76

I want to create an account schedule that compares the figures to the same month of last year. I thought i just could put -1Y in the date comparision formula but it is calculating the sum for the whole of the last year rather than just the corresponding month of last year. Anyone have any ideas how to do this?? Any help would be appreciated.

ssingla

Select Net Change in Coloumn Type in Coloumn Layout for that line

ricky76

I have done but it is still not working. Should the keep comparison period scope check mark be off?

ssingla

This field is not in the database I use (may be localization in your country). See the help of the field or try using comparision period formula.

ricky76

I don't have the comparision period field. I am using version 3.7 did this come along in a later version??

ssingla

No this field was available in 3.7. Zoom on the coloumn layout line and field will be available. Then modify the form and insert the field.

Alex_Chow

Make sure your Column Type on the column layout is set to Net Change. You want to also check the Account schedule rows to ensure that the Calculate column is set to Net Change.