How to recognize back orders in SALESLINE table?
Hi eiourtch,
I'm not sure if you need help with some coding or the definition of a back order? Can you elaborate on your question so we would know what exactly you are asking here?
I have AX database. In table SALESLINE how I can separate regular orders from backorders. Is it any field or flags for backorder lines?
Refer to the query "SalesDelayedOrders" which will show you all the backorders sales lines.
Thanks,
Girish S.
Hi, GirishS, I did not find field SalesDelayedOrders in SALESLINE table. Can you be more specific?
SalesDelayedOrders is a query not a field.
On that query you will have range on "SalesLine".
Try to loop through the query and see if its returning all the backorder lines.
Hi, GirishS.
My Queries does not have SalesDelayedOrders. Can you post code, please?
Unfortunately I don't have Ax 2012 environment. I will list the ranges that were mentioned in the query.
Table - SalesLine.
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 Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 734 Super User 2025 Season 2
CA Neeraj Kumar 636
Martin Dráb 553 Most Valuable Professional