Is it possible to create running totals in account schedules? I have created a monthly balance sheet with 12 columns. I need to do the following calculation:
closing balance for august= closing balance for july + balance for august
Try to play with ColumnType, Comparison Date & Period Formulae in Column Layout.
AccShedules + ColLayouts are really comprehensive, but hard to set up, if you do not do it daily. Please search the forum for “Account Schedule”, there are many threads about how to do some tricky setups --some of them mine – as I don’t remember all these by heart, I can mess something up…
A quick tip - Help does’t contain all possible values for Comp.formula fields… Enter some garbage there, and a msg will pop up enlisting allowed values [:)]