Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Back orders recognizing

Posted on by 5

How to recognize back orders in SALESLINE table?

  • GirishS Profile Picture
    GirishS 27,803 Super User 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,803 Super User 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,803 Super User 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... 287,696 Super User 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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans