Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Back orders recognizing
Finance | Project Operations, Human Resources, ...
Suggested answer

Back orders recognizing

(0) ShareShare
ReportReport
Posted on by eiourtch 5

How to recognize back orders in SALESLINE table?

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Back orders recognizing

    Hi eiourtch,

    Unfortunately I don't have Ax 2012 environment. I will list the ranges that were mentioned in the query.

    Table - SalesLine.

    1. SalesStatus - Value(BackOrder)
    2. RemainSalesPhysical - Value(greater then 0).
    3. ShippingDateRequest - Value(less then today date).

    Thanks,

    Girish S.

  • eiourtch Profile Picture
    eiourtch 5 on at
    RE: Back orders recognizing

    Hi, GirishS.

    My Queries does not have SalesDelayedOrders. Can you post code, please?

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Back orders recognizing

    Hi eiourtch,

    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.

    Thanks,

    Girish S.

  • eiourtch Profile Picture
    eiourtch 5 on at
    RE: Back orders recognizing

    Hi, GirishS, I did not find field SalesDelayedOrders in SALESLINE table. Can you be more specific?

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Back orders recognizing

    Hi eiourtch,

    Refer to the query "SalesDelayedOrders" which will show you all the backorders sales lines.

    Thanks,

    Girish S.

  • eiourtch Profile Picture
    eiourtch 5 on at
    RE: Back orders recognizing

    I have AX database. In table SALESLINE how I can separate regular orders from backorders. Is it any field or flags for backorder lines?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Back orders recognizing

    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?

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans