Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Write query to track the issued SOs in Load release error message

Posted on by 489

Hi guys,

We have a number of SO in this load and got an error of credit limit.

I want to know which order belong to credit limit issue.

pastedimage1596082630053v3.png

Does anyone guide me how to write a query to identify it?

Many thanks

Ett

  • Austin Shen Profile Picture
    Austin Shen on at
    RE: Write query to track the issued SOs in Load release error message

    Hi ETT,

    Sorry to get you late. You could refer to following document for the tool - Trace parser. The process would be like below -

    1. Open the trace with the trace parser and identify your session

    2. Try to filter x++ calls with info::add or anything else to determine where the error may be thrown

    3. Then you could switch to call tree and check why the error is thrown, also you will find some SQL clauses which are used to get related data. The SQL clauses may be what you are seeking.

    docs.microsoft.com/.../trace-trace-tutorial

    Best Regards,

    Austin Shen

  • Ett Profile Picture
    Ett 489 on at
    RE: Write query to track the issued SOs in Load release error message

    Hi Austin,

    Thanks for your suggestion..

    Our business process, we only group SO by post code.

    On technical side, can you explain more detailed.

    Thanks

    Ett

  • Suggested answer
    Austin Shen Profile Picture
    Austin Shen on at
    RE: Write query to track the issued SOs in Load release error message

    Hi ETT,

    From function side, you could group your orders in the load by customer and then check credit limit for customer one by one.

    If you have some technical background, you could capture a trace for the process to release the load to warehouse and then analyze the trace and check where the issue may come from.

    Best Regards,

    Austin Shen

  • Ett Profile Picture
    Ett 489 on at
    RE: Write query to track the issued SO in Load release error message

    Hi,

    Yes, I checked this SO, but there could be more than 1 SO that got credit limit issue. I want to list them out from this load.

  • MuthukumaranAX Profile Picture
    MuthukumaranAX 2,907 on at
    RE: Write query to to get issued SO number in Load

    hi - I can see Load number in the infolog, did you try to track SO with  that reference?

    thanks

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans