Vendor ageing report for down payment bucketwise

[former_member221515]

Hi

I have paid many downpayment to various vendors. Now i want the ageing report for the same (i.e. bucket wise i.e. 0-30 days, 31-60 days and so on).

This i am getting for vendor invoices in TCode: S_ALR_87012085 (Vendor payment history with OI sorted list).

Please let me know if the bucketwise report is possible for the downpayment too.

[durgasankar_innamuri · Accepted solution]

Hi,

Vendor ageing for down payments as well as invoice i use to see from T.code FBL1N by creating layouts.

Choose Arreas after net due date from layout and for that column you can apply a rule that from 0 to Lessthan or equal to 30.

Like that you can create the layouts. In FBL1N you can give this layout (down) so information come in that format.

The one disadvantage is that you have to select manually the layouts and you can see only one ageing information at a time.

Regards,

Sankar

[former_member221515 · Accepted solution]

Hi

But this net arrears is calculated from due date or posting date.

[durgasankar_innamuri · Accepted solution]

Hi,

Date depend upon the baseline date. check the payment terms once.

Check whether you are consider baseline date as invoice date or posting date or other.

Regards,

Sankar

Edited by: Durgasankar.Innamuri on Jul 23, 2010 11:02 AM

[kim_khan · Accepted solution]

Hi Dear

I was going through your reply for this thread and I wanted to try to create aging in FBL1N. Could you please explain me how to do this - "Choose Arreas after net due date from layout and for that column you can apply a rule that from 0 to Lessthan or equal to 30".

Please elobrate on this and guide me

Regards

KIM

[former_member221515]

New report is being developed

Edited by: Deepak Agrawal on Jul 25, 2010 4:58 PM