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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / relation between vendT...
Microsoft Dynamics AX (Archived)

relation between vendTrans and custTrans ax 2012

(0) ShareShare
ReportReport
Posted on by Community Member

I need to create one report and the outcome for this report come from " Customer Transaction & Vendor Transaction", 

did we have a relation between vendTrans and custTrans.

I have the same Customer Account ID and Vendor Account ID

Any advise Please

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Ali,

    Note that the tags on this forum should not start with a '#' and they should be separated with a comma ','. I have corrected it for you.

    There is no database related between custTrans and vendTrans. Also on account numbers there is no relation. It is possible to setup a vendor account number on the customer details for creating a link. If the customer and vendor both share the same global address book party ID, then you also have a link. Then you can use this as starting point to get customer and vendor transactions for the same organization.

  • Community Member Profile Picture
    Community Member on at

    Its the first time I ask Question

    thank you for this kind support

    we have customized on the system once we create Vendor the system auto-create a customer with the same ID.

    IF I need to have a report contain the for Customer and vendor transaction on the same report, It's Possible?

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

    Hello Ali Hayajneh,

    In GL we have a transaction origin report that includes multiple subledgers, such as AP and AR in one single report.

    The report mentioned, is, however, an 'accounting' report.

    I am not sure what kind of customer/vendor report you look out for but you might want to look at the transaction origin report to see whether it fits and if it does not whether you can borrow some concepts from this report design.

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Ali,

    It is possible to get such report, but it requires development effort for a custom report.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans