How to print debtor customer balance on debit side and creditor one on credit side?

(0) Share

Report

Posted on by Louis Ewango

Hi all,

One of our customer would like to sum up and display debtor customer balance on his balance sheet debit side and creditor customer balance on his BS credit side. We are trying to find a way to do that with Financial Reports but it seems tricky. Any idea or workaround to share?

Thanks in advance.

I have the same question (0)

All responses (8)

Answers (4)

Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

You can try using Electronic reporting.

Did you try using existing customer transaction report where it shows two columns Debit and Credit for each transaction.

Was this reply helpful? Yes No
Juanse 660 on at

Like (0)

Report

Hello,

you won't be able to get that done using financial reports, those read information from the general ledger only. The information that you need will come from the AR subldger and is not supported by financial reporting. You will need to look at other ideas such as electronic reporting. Or you can just download your standard AR aging report and then manually seeing which customers are in each state.

regards,

Was this reply helpful? Yes No
Verified answer

SouravDam 11,730 on at

Like (0)

Report

Hello Louis Ewango,

Couple of things.

--- Is that logical to display the same customer balance in both sides of balance sheet based on debit and credit values as recorded?

--- Is that same customer is a vendor as well?

Whatever is receivable and payable to the customer; will be adjusted in the customer balance itself and the summarize value will display in balance sheet.

If I am not wrong; I don't think it is possible to cater such requirement to display in report.

Alternatively; you can do the following;

--- If the same customer is a vendor too, then create a separate vendor account with the same customer details and set this vendor in the remittance vendor account field available in the customer master form.

--- Next go to Global address book; filter by name of this customer and vendor (as name will be same) and merge both party IDs. You can select the customer party ID to retain before merging. You will get the option there.

Therefore; you will get both Debit and Credit balances for the same customer (who is a vendor too) and it will be available in both sides of the Balance sheet as Asset and Liability.

Kindly review and provide your feedback.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Louis Ewango on at

Like (0)

Report

Many thanks for the reply!

This requirement is coming from regulations actually. Applying your suggestion means that a vendor counterpart needs to be created for each customer, right?

Rgds,

Louis

Was this reply helpful? Yes No
Verified answer

SouravDam 11,730 on at

Like (0)

Report

Hello Louis,

If this is the case, then yes you have to create a counter vendor account for each customer.

Please discuss this with your client and provide your feedback here.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Louis Ewango,

The following post describes how to create switching balance financial reports.

dynamicsax-fico.com/.../

Is this what you are after?

Best regards,

Ludwig

Was this reply helpful? Yes No
Louis Ewango on at

Like (0)

Report

Hi Ludwig,

Many thanks for your reply!

This is what the customer would like to complete but not based on the total account balance (the receivables) but on the balance per customer. We thought adding customer as financial dimensions but we didn't find any way to apply formula to the financial dimensions value.

Rgds,

Louis

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Louis,

This would work on an individual customer level if you include each customer record in a separate financial reporter line.

Before doing that, I would question whether this is really necessary because such a setup would require a quite long and complex report that needs to be updated often; basically every time a new customer is setup.

Can you double check with your accounting colleagues whether they really want to have that?

I would expect that it is sufficient if you apply this 'if then else' rule on the summary accounts that you use for your different customer groups. ... would make things much easier.

Best regards,

Ludwig

Was this reply helpful? Yes No