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
Thank you very much Dr.
we will search for a solution on BI.
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
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
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
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.
are you try to filter on the dimension.business unit?
#1
Kempeth
4
#1
Andy Adamak
4
#1
Community Member
4
Share
Report
All responses (
Answers (
