Payment Report Design Suggestion

[erprider]

Hi Guys

I've been designing a AP Payment voucher report, in this report i have to show the expense account of an invoice.
e.g
payment against an invoice A,B,C,D so i have to show those invoice expense account in the report
Example:

Invoice nos Invoice Amount
A 157.250
B 52.000
C 161.500
D 30.000
-----------------------------------------------------------
Account No | Desc | Dr | Cr
------------------------------------------------------------
40500 Education Expense Dr 157.250
40111 Medical Insur Dr 243.604
40222 Account Payable Cr 400.854
40222 Account Payable Dr 400.854
10000 Bank Cr 400.854
------------------------------------------------------------
in a some report i have show the GL affect in this report(invoice,payment effect)My question is which table has this information ?so it would be grateful if you suggest any valuable information on the same.

Thanks

 

[ettienne]

I suggest you to use APIBD for the GL accounts.

 

[erprider]

Thanks for your reply ettienee! already dont it but issue part is bring the GL information debit and credit information.am still struck to retreive those GL effect information into the report.

 

[Jay Converse]

Like Ettienne said, use APIBD. Or APPJD, but that would be harder.

 

[erprider]

Yeap! but my customer want to see those GL effect without posting a payment.

 

[Jay Converse]

Yes, so what's your point?