Confirmation of Accounts

[Former Member]

Hi ALL

According to my client requirement i need a report ...Confirmation of Accounts report in which the user can see the Debit and Credit values of a BP for a particular period

Can anyone please give any solution for this

Thanks

[former_member187989]

Try with XL Reporter.

[former_member583013]

If you look into Reports > Financial > Accounting >.G/L and Business Partner..you should get this information

[Former Member]

Hi

Client doesn't want that reports..so we have to make this ourself......for a particular period he wants his Customer/Vendor invoice related detail and correspondingly Payment details

Thanks

[Former Member]

Hi Pari

With the querry you can get the required information and you can set the print out accordingly. other way is XL reporter, Crystal Report.

Ashish Gupte

[Former Member]

Hi

Can you let me know the Query For this purpose

Thanks

[Former Member]

Hi Pari

if you give me specific fields what you want then i will let you know the querry.

Basically you need Sale/purchase register along with the payment details. am i right?

in SAP 2007 B xl reporter is having pre defined sale/Purchase register only thing you have to do is ADD the payment details in that register

or write a querry by taking the invoice (Purcase/sales)i e opch, pch1, oinv, inv1, ovpm, vpm1 orct, rct1 and take the required fields

i know you can do that

Ashish Gupte

[Former Member]

Thanks all of you...i have done this

[Former Member]

Hi Pari

Try this querry

SELECT T0.[DocNum], T0.[CardCode], T0.[CardName], T3.[Debit], T3.[Credit] FROM OVPM T0 INNER JOIN VPM1 T1 ON T0.DocEntry = T1.DocNum INNER JOIN OJDT T2 ON T0.TransId = T2.TransId INNER JOIN JDT1 T3 ON T2.TransId = T3.TransId WHERE T0.[CardName] =[%0] and T2.[RefDate] =[%1] and T2.[RefDate] =[%2]

Ashish Gupte

[Former Member]

Hi Pari

can you share with us HOW?

Ashish Gupte

[former_member187989]

hi,

It is feasible as printable report in standard B1 from general ledger report,

customize general ledger print layout designer template to get confirmation of accounts.

Jeyakanthan

Edited by: Jeyakanthan A on Jun 11, 2009 6:05 PM

[Former Member]

Hi,

If you want the Financial transactions of a Business Partner for a period then

through query generator

using the following table

JDT1 contains all the financial transactions,

query selection make it based on BP Code ( Shortname) in that table and From and to of posting date.

using the orgin journal you can determine the transaction wrt to BP like A/P Invoice, A/R Invoice, Outgoing payments, Etc.

I Hope this helps you out

regards,

Shreyas