topic Re: overdue amount calculation in Application Development and Automation Discussions

overdue amount calculation

Former Member — Mon, 28 Aug 2006 22:01:24 GMT

hi all,

how to calculate overdue amount for account statments.

is there any function module to calculate the overdue amount .

regards,

deepthi

Former Member — Mon, 28 Aug 2006 22:52:06 GMT

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 — Mon, 28 Aug 2006 22:53:59 GMT

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 — Mon, 28 Aug 2006 23:00:21 GMT

hi sudhir,

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

regards,

ndeepthi

Former Member — Mon, 28 Aug 2006 23:06:42 GMT

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.