Skip to Content
0
Sep 25, 2013 at 11:21 AM

Report of JE

21 Views

Hello Experts,

I need a query that will show the posted JE of A/P Invoice and Outgoing Payment by taking the input of Business Partner Name. The report template is as follows..

Posting Date Document Date Doc Number(A/P Invoice/Outgoing Payment) Remarks

Account Name

Debit Credit Cumulative Bal.
25/09/2012 10/08/2013 Invoice No. 11100 Supplier invoice abc
100.00 25/09/2012 10/08/2013 Invoice No. 11100 Supplier invoice VAT Receivable (Input Tax) 2.00

25/09/2012 10/08/2013 Invoice No. 11100 Supplier invoice Raw Materials (Stock) 100.00

25/09/2012 10/08/2013 Invoice No. 11100 Supplier invoice Interest on Mobilisation -1.00

25/09/2012 10/08/2013 Invoice No. 11100 Supplier invoice FSD -1.00

25/09/2012 25/09/2013 Outgoing Pay. No. 2550 Supplier Payment abc 100.00

25/09/2012 25/09/2013 Outgoing Pay. No. 2550 Supplier Payment Cash A/C Head Office
100.00

Please help me in above mention report. Thanks in advance.....

Regards,

Umamahesh.