overdue amount calculation

[Former Member]

hi all,

how to calculate overdue amount for account statments.

is there any function module to calculate the overdue amount .

regards,

deepthi

[Former Member]

hi all,

how to calculate the overdue balance

for overdue(1-30),overdue(31-60),overdue(61-90),overdue(90+),

balances for the account staments.

regards,

ndeepthi

[Former Member]

Normally we get the account statement and do the calculation of overdue amount.

Here are the BAPIs for AR and AP to get the account statements.

BAPI_AR_ACC_GETSTATEMENT

BAPI_AP_ACC_GETSTATEMENT

[Former Member]

hi sudhir,

the bapi was helpful but how do we calculate the overdue amount.

regards,

ndeepthi

[Former Member]

Loop on the items and find the difference between

PSNG_DATE of each item and SY-DATUM which gives the

number of days from which it is open.

If the days is between 1-30 add the amount (LC_AMOUNT) to this cap else check if the days between 30-60 and add amount and so on for opther two caps.