Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

SettleVendorInvoice need database information

Posted on by 115

I am working on the API of dynamicsAx. 

I want to know which tables are affected with the API call 'SettleVendorInvoice'.

Please reply with details or process of above API.

*This post is locked for comments

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: SettleVendorInvoice need database information

    Yes, that's exactly what I'm talking about. Looking at everything is virtually useless, because there are two many things going on and most of them are not important for your task (whatever it is).

    You really should spend a minute thinking about what you're trying to achieve and then focus on data relevant to this goal.

  • Bhavesh Gohel Profile Picture
    Bhavesh Gohel 115 on at
    RE: SettleVendorInvoice need database information

    I have run SQL profiler  but gives 100-200 sql queries and Its hard to identify What to take from that logs. That's why asking in the community somebody has exact knowledge regarding this process or SQL queries then it will more helpful.

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: SettleVendorInvoice need database information

    I think you should first think about what data you need. If you first try to identify everything what's going on when settling invoices and only then selecting what you need, you'll find that it's super complicated and 99% is likely irrelevant for you. Therefore identifying what's relevant and then looking just for that (and ignoring the rest) is likely a better approach.

    In either case, things like debugger, cross-references and database profiler will help you to understand the impact of a particular call.

  • Bhavesh Gohel Profile Picture
    Bhavesh Gohel 115 on at
    RE: SettleVendorInvoice need database information

    We are using the API with help of "Microsoft.Dynamics.BusinessConnectorNet;" But not getting the scene behind it.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: SettleVendorInvoice need database information

    Hi,

    Do you make vendor payments outside of AX?

    Is is right that you are still on AX2009? If so, which version of AX2009 do you operate?

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans