Dear All,
My company is using SAPB1 2005b. I would like to develop AR invoice Outstanding Report, but I have no idea how to handle the following case, by using SQL.
Transaction:
1. inv1 on 16th March 2009, value USD 1000
2. payment to inv1 on 16th April 2009, value USD 1000
Outstanding report as at 31st March 2009
Document Value O/S Balance Current Balance
Inv1 USD1000.00 USD 1000.00 USD 0.00
Remark: If I select date as 31st March 2009, the AR outstanding should contain Inv1.
From Samson