Account Schedule

jesstyl

How Can I set the formula to get Last period amount at Row Level in Account Schedule

e.g. date filter 010105..311205 at this row should show the amount as at 311204?

](*,)

kriki

try "..311204"

Marije_Brummel

Is this a trick question?

You cannot change the datefilter at row level, only at culumn level.

You need to make a change for this.

jesstyl

Hi Kriki,

try "..311204" to date filter ?


This is not trick question but one of my client wanted to view the beginning period amount in the Account Schedule - CASH Flow.

Marije_Brummel

If you want to have a different datefilter you need to add some new column and call this 'Previous Period.'

jesstyl

HI Mark,

If you want to have a different datefilter you need to add some new column and call this 'Previous Period

.'

I agree this can view the previous period amount in column ... But in my case i need it in Row level.. how can i going to make the change? Or anyone can help? [-o<

Marije_Brummel

In this case you need to add some dateformula field to the row table. Also you need to change codeunit 8. This has to be done by an experienced engineer because it is quite a complex routine.

Please tell your customer that they need a customisation in Navision for this.

kriki

jesstyl wrote:

Hi Kriki,

try "..311204" to date filter ?


This is not trick question but one of my client wanted to view the beginning period amount in the Account Schedule - CASH Flow.

I didn't notice, you needed it on a row.
But I agree with Mark Brummel that it is better in a column just to avoid the need to program something.
If you need to program it, it will cost your customer more then just adding a column.

jesstyl

HI Mark / Kriki,

Thank you for your reply. Is there any other alternative to resolve (application or programming) if this is a must? 8-[

Marije_Brummel

What you can do is build a custom report for this.

This can maybe be done faster than changing the schedule functionality.

Changing the account schedule and make it more flexible is something we have on the long-list for our add-on. But I doubt we will start before Nav5.

davmac1

With FRX now available for Navision, maybe they will push that instead of account schedules?

jesstyl

But Microsoft FRx available for 3.70 an 4.0 only..

Anyway, Thanks everyone.

DanAlpe

You can choose Beginning value instead of Net Change from the Calculate Field.

Sorry this might be a little late.