Expected AP Balances for coming months

[former_member1278929]

Hi,

We have an requirement where client is asking to have expected AP balances for the coming months based on the vendor payment terms. for example if today date is 26 June 2019 and they want to execute FBL1N in future date suppose 30 June 2019, then it should give the pending invoices report balances having due dates between 26 & 30 June only . Is there any standard report for the same or we need to develop Z report ?

Can somebody advises on the same.

Thanks & Regards

[former_member1278929]

Hi Ganesan,

I have already checked the report S_ALR_87010034. In that it will give all AP balances pertaining to open items at key date. Mine requirement is to have pending invoices having due dates between todays date and open items at key date only .If you refer mine above example, when I execute this report , it should assume invoices having due date till 25 June as cleared.

Regards

Nikhil Sarna

[Lakshmipathi]

Have a look at S_ALR_87010034