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 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 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
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
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,
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 - I can see Load number in the infolog, did you try to track SO with that reference?
thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156