Case or Large If Statment - I think

[amypaulsmom]

I can picture what I want in my head and on paper, but I can't get my mind around it using the FMP functions - thanks in advance for the help.

I am working on a accounts statements page. I have summary fields that add up my Over 90, Over 60, Over 30, and current due. My situation is - if there is a credit balance in the Over 90 column, I first want it to apply to the Over 60, and if 0, then Over 30, and if O then Current. And the same is true for the Over 60 with credits, Over 30. And the same is true for the other direction. If there is a credit in the current, Over 30, Over 60, and a balance in the Over 90 - I want it applied to the Over 90 first.

Basically - I need some calculation that will apply any credit to the most outstanding amount due.

Sounds simply enough - but I am just not wrapping my head around it.

Thank you for you help.

[falkaholic]

Could you give some more details on it? I'm not sure how your system works.

[amypaulsmom]

Let's see - more information

I have a statement that prints every month. On the statment is a list of list of invoices that have been put through the system and then a section below that is showing the amounts due for Current, Past 30, Past 60, and Past 90. these are all Summary fields.

This is all set up on a payment plan structute and the individual payments are entered in another layout. So - sometimes - a client might pay $600 when only $300 is due. Well that extra $300 shows up as a credit - when I really want it to apply itself to any amount that is oustanding in the Current, Past 30, Past 60, and Past 90 fields.

Does that make any more sense - to help me out.

Thanks -

[falkaholic]

Well, you can make a self relation to the customer of each invoice (run a search on this forums for more info on self relations), the use the Sum() function on the payment field with that relation. That should yeild their net balance.

More info about the structure would help