Skip to Content
0
Former Member
Jul 07, 2009 at 07:05 AM

Question about developing SQL for AR invoice

26 Views

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