Control Account wise Debtors Balnce

[Former Member]

Dear All,

We have Control accounts, ex: Sundry Debtors I, Sundry Debtors II, etc...

Under Sundry Debtors I , we have some 100 customers.

Now , Sundry Debtors I having balance 1 lack.

Assume, each customer has 1000 rs balance.

So, where I can see this breakup ?

It should match  with gl(sundry debtors I).

Where should I check?

Thanks,

M G Hegde

[Former Member · Accepted solution]

Hi,

Go to Financial --> Financial Reports --> Accounting --> General Ledger

Under General Ledger you will find control account browse button. Select Sundry Debtors and run the report you will the detail report with customer balance.

Thanks,

Harshal

[Former Member · Accepted solution]

Hi Harshal,

Tried same.. But , I dont want details.

I need only customer balance in line item.

[Former Member · Accepted solution]

Hi,

Then you can use Aging report under Business Partner report and select particular control account.

Thanks,

Harshal

[KennedyT21 · Accepted solution]

You can use the aging report

or try this simple query

SELECT cardcode,t1.CardName, t1.CardType,DebPayAcct,t2.Acctname, Balance

  FROM ocrd t1

INNER JOIN oact t2 ON t1.DebPayAcct=t2.AcctCode

Cheers

[KennedyT21]

Kindly confirm if this is resolved,  If your thread is closed then close the thread with correct or helpful answers.   Cheers!!!

[Former Member]

Use "G/L Accounts and Business Partners" Report...