Notifications
Announcements
No record found.
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.
Does anyone guide me how to write a query to identify it?
Many thanks
Ett
hi - I can see Load number in the infolog, did you try to track SO with that reference?
thanks
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.
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
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
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 584 Most Valuable Professional
André Arnaud de Cal... 499 Super User 2025 Season 2
Sohaib Cheema 254 User Group Leader
