AP aging report

[Former Member]

Hello all gurus,

I need to write a functional specs for ABAPer to develop AP aging report with vendor number,vandor name,invoice date and by due dates 30,60,90,180. I haven't written any functional specs earlier can any one provide me the functional spec for AP aging with above requirements, million thanks in advance.

Kind regards,

Krishna

[Former Member · Accepted solution]

Hi,

Basic data on the vendor open invoices subject for your aging can be located in BSIK table such as company code, vendor number, reference, invoice date, amount.

For aging computation such as 0-30, 31-60, 61-90 and over 90 days can be computed as follows:

Compute Due Date. Compute using T052 table where BSIK-ZTERM = T052-ZTERM. Due Date = BSIK-ZFBDT + no of days*. To get No of Days: Condition 1: If T052-ZTAG3 ne 0; then No. Of Days = T052-ZTAG3; Condition 2: If T052-ZTAG3 = 0 and T052-ZTAG2 ne 0; then No. of Days = T052-ZTAG2; Condition 3: If T052-ZTAG3 = 0 and T052-ZTAG2 = 0; then No. of Days = T052-ZTAG1; Condition 4: Else Due Date = BSIK-ZFBDT

Should you have any question, let me know.

Hope this helps you.

Thanks,

Rod

[Former Member · Accepted solution]

Hi Rodolfo,

Thanks a lot for your reply, I will put this in my functional specification I think it should solve the issue.

Once again, Thanks.

Kind regards,

Vikram