Former Member

Receivable report based on Sale Order

Hi Guys,

We are using SAP Business One 8.82 PL 10, Management wants to see a Receivable report based on Sale Order in which A/R Down Payment Request and its Incoming Payment, A/R Invoice (Partial or complete) and its Incoming Payment, A/R Credit Memo if any posted. We are using both Item and Service type Sale Order and A/R Invoices. We can see relationship map for each Sale Order but not complete report based on dates.

Irfan Yousaf

10|10000 characters needed characters exceeded

Related questions

• Posted on Jun 03, 2013 at 07:02 AM

Hi Irfan,

Try this and let me know the result:

SELECT [CustName] as CustName, isnull([1],0) as Jan, isnull([2],0) as Feb, [3] as Mar, isnull([4],0) as Apr, isnull([5],0) as May, isnull([6],0) as june, isnull([7],0) as July, isnull([8],0) as Aug, isnull([9],0) as Sept, isnull([10],0) as Oct, isnull([11],0) as Nov, isnull([12],0) as Dec

from
(SELECT T0.[CardName] as CustName, sum(T0.[DocTotal]) as Total, month(T0.[DocDate]) as month FROM OINV T0 WHERE year(T0.[DocDate]) = 2013 and T0.[CardCode] = 'ADD YOUR CARDCODE HERE' and T0.[DocStatus] ='o' GROUP BY T0.[CardName],T0.[DocDate]

union all
(SELECT T0.[CardName] as CustName, -sum(T0.[DocTotal]) as Total, month(T0.[DocDate]) as month FROM ORIN T0 WHERE year(T0.[DocDate]) = 2013 and T0.[CardCode] = 'ADD YOUR CARD HERE' and T0.[DocStatus] ='o' GROUP BY T0.[CardName],T0.[DocDate])) S

Pivot
(sum(S.total) For Month IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) P

Thanks & Regards,

Nagarajan