Break up of DR & CR Bal in PLD

[Former Member]

Dear Experts

One of our client needs to print the Vendor / Customer balances in the following format. We are using the reports option (Reports--Financial-Accounting-G/L & Business Partners).

The format is:

Vendor -- Cr Balance - Dr Balance - Total

xxxx          100               50              50

Can anyone help us on this??

regards

karthik

[KennedyT21 · Accepted solution]

Hi Karthik,

This the layout design in the existing Pld and save with different name ,

Regards

Kennedy

[Former Member · Accepted solution]

Hi Kennedy

Can u pls elaborate. I don't understand what ur referring to??

regards

KARTHIK

[KennedyT21 · Accepted solution]

HI Karthik ,

Check this report.

Reports - Financials -- Financial -- Trial balance

In this report you get the format what you mention....

or try this query in query pld format...

SELECT T0.ShortName,T1.cardname, SUM(T0.Credit) 'Credit', SUM(T0.Debit) 'Debit', SUM(T0.Credit-T0.Debit) Balance

FROM JDT1 T0  inner join ocrd T1 on t1.cardcode=t0.cardcode

WHERE T0.BalDueCred != T0.BalDueDeb  Group By T0.ShortName, T1.cardname

Regards

Kennedy

Message was edited by: Kennedy T

[Former Member]

Hi Gardon / Kennedy

Thanks a lot. As you said the format in the reports option gives me the required results.

REGARDS

KARTHIK

[Former Member]

Hi Karthik,

This can be done through query PLD. Try:

SELECT T0.ShortName, SUM(T0.Credit) 'Credit', SUM(T0.Debit) 'Debit', SUM(T0.Credit-T0.Debit) Balance

FROM JDT1 T0

WHERE T0.BalDueCred != T0.BalDueDeb

Group By T0.ShortName

Thanks,

Gordon