Vendors/Suppliers balances by Account

(0) Share

Report

Posted on by Community Member

Hi,

I want (have to) create Balance Sheet.

The issue is, that on Vendors accounts (in meaning chart of account from GL) there are vendors with balance DT or CR (and the same is with Customers).

Due to local law I have to DT balances (not whole account, but sum DT balances vendor/customer by vendor/customer) present in assets and CR balances (sum CT balances vendor/customer by vendor/customer in liabilities).

I tried to use management reporter and Attributes in Column Definition (https://www.youtube.com/watch?v=BrVoQoV5xGA) and create one report for vendors/customers accounts and then linked them to the BS report, but without success.

Help

Jarek

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi djarko,

How many customer and vendor accounts have you setup. Showing the debit credit balances separately can be achieved in MR by making use of the if-then-else formula. Yet, if you want to use this for all vendors you would have to ensure that they have their own financial vendor dimension assigned. Otherwise you would need to create a separate report or use BI tools to achieve this.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There are thousands.

In effect I would like to get such informations (I'm not interested in numbers and names of vendors /customers - potentially - for accounting - it could be in drill down):

GL Account Dt Ct

7001 -300 150

7002 -40 800

7003 -180 0

7004 0 95

…

I prepared report, which shows:

Balances by account:

in drill there are needed informations:

Below are Row and Column definitions:

Balances from Drill down (Net Difference I want to put into BS.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Maybe I didn't understand Your questions - GL Accounts, which are connected to Vendor and Customers modules, I have 10-20. But numbers of vendors/customers accounts I have thousands.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Probably have a look at the following post dynamicsax-fico.com/.../switching-accounts

That describes how to handle switching accounts.

If this does not work in your case you probably need to make a system modification.

Best regards

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ludwig,

thanks for your reply.

I've read, mentioned by You, article. In fact it's similar, but I have rather problem with dt/ct balances from Vendors/Customers modules, than from General Ledger. I think, that BS report in receivables/liabilities sections should link to another report.

Is there in Vendors/Customers modules attribute (?), which shows on which side the balance is?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi djarko,

In the MR line setup there is a functionality available under the print control that allows you filtering only DR or CR balances.

Yet, based on what you mentioned further above, I am not sure whether this is the Feature you are looking for.

Probably test it and let us know.

If this does not work for your case, I believe that you would go through a different reporting way and use something else than MR.

Best regards,

Ludwig

Was this reply helpful? Yes No