Vendor Balance List

(0) Share

Report

Posted on by Community Member

We have two business unit dimension values and we need vendors balance for each business unit separately, but when I try to run vendor balance list report It gives the balance of all vendors in both business units.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

are you try to filter on the dimension.business unit?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No when I run vendor balance list report in accounts payable module, it give me the balance of all vendors in the company but I need the vendor balance list report by business unit.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mulat Chaklu,

You would need to make use of the balanced financial dimension functionality if you want to achieve this.

Here is a quick overview

stoneridgesoftware.com/balancing-financial-dimension-field-in-ax-2012-r3

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank You Very Much Dr.

Yes I can get a balanced Balance sheet for each business unit at ledger level but my problem is getting the balance of each vendor at each business unit separately.

For example we have a Vendor called X having transaction in Business unit 1 and business unit 2, when I run a vendor report I get a combined balance of vendor X in both business units but my interest is to get balance of Vendor X In business unit 1 and business unit 2 separately.

Thanks

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mulat Chaklu,

I see. Do you post the vendor financial dimension and the business unit financial dimension for your balance sheet accounts? If this is the case then setting up the vendor as the balanced financial dimension might help.

However, if you have similar requirements in other areas, such as accounts receivable where you want to see customer balances also broken down by customer and business unit, the balanced financial dimension approach might not help and you rather need to apply BI tools to get this information out of your system.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much Dr.

we will search for a solution on BI.

Was this reply helpful? Yes No