AP aging report
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.
Rod Mendoza replied
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.