web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor Balance List
Microsoft Dynamics AX (Archived)
Answered

Vendor Balance List

(0) ShareShare
ReportReport
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)
  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at

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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Community Member Profile Picture
    Community Member on at

    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

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Community Member Profile Picture
    Community Member on at

    Thank you very much Dr.

    we will search for a solution on BI.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans