Get IS-U Account Balance, Due Date and Overdue indicator

[Utrivedi]

Hello,

I am trying to get Account Balance, Due Date and Overdue indicator for multiple accounts. Is there any FM which can give this data? As this is mass data interface, I would prefer to have a table so that we can get data with one SELECT instead of looping through the accounts, and using FM for each account.

Thanks you for your input on this.

Regards,

Udit

[AmlanBanerjee]

Udit,

There is no such FM which can give you the account balance and other relevant details for multiple contract accounts at one shot.

If you want to retrieve,these information, then the table you should go for is DFKKOP.

Once you retrieve the information, you have adjust it based on due date/deferral date and then do the calculation for over due balance etc.

You also need to exclude the Downpayments, like Security deposit payments etc. from the calculation.

Thanks

Amlan

[ricky_shaw]

Hi,

There are some std ISU FM's like 'ISU_S_LAST_PRINT_DOC' to get the last balance amount.

Also you need to query the table DFKKOP based on payment status(AUGST = ''), open items, Statistical items if any(STAKZ), clearing restrictions(AUGRS), BLART & sort the net due dates(FAEDN) and do the calculations.

Do not consider any down payments in the calculation.