web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Planned Order History

(0) ShareShare
ReportReport
Posted on by

Hello,

We're looking for a way to report what Sales Order/Production Order drove Planned Purchase Orders that were firmed. Note: Our Sales orders and Production Orders and Purchase Orders are not exclusively "marked/linked" together.

Ex:

Enter Sales Order: S0000001, Qty 1, of part ABC

AX Plans Production for 1pc of ABC

AX Plans Purchase Orders for requirements of 1pc ABC (call this ABC1, ABC2, ABC3 materials)

We firm these POs, either separately, or together into one.

On the firmed PO Line Details, we have a "Planned-Order reference" Number and Plan for the original planned order.

4130.Untitled.png

Is there a table that holds "historical" planned order info that we can reference? Is there a report we're missing in AX that would tell us this automatically?

Thank you!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: Planned Order History

    Any help would be greatly appreciated!

  • Community Member Profile Picture
    on at
    RE: Planned Order History

    Any feedback on this would be greatly appreciated!

  • Verified answer
    Weaveriski Profile Picture
    23,616 Moderator on at
    RE: Planned Order History

    Ultimately the answer is no - the PO itself might never be directly linked to one produciton order, the driver could be a transfer order, safety stock level, forecast. It is basically a balance of supply and demand. I have been involved in companies where they state this relationship is always 1:1, but that is never true, it is the majority of the time and therefore we wrote customisations to push the sales order through to the PO. This only worked if there was a direct relationship of requirement 1:1 from sales order through to PO - the moment the PO accumulated requirements from multiple production orders, or production orders accumulated requirements from multiple demand points nothing was written.

    There is no table holding historical planned orders due to the volume impact and there is no report because it would not work for most businesses and the system is flexible to break the report the majority of the time.

  • Community Member Profile Picture
    on at
    RE: Planned Order History

    I'm also looking to find a way to see if a production order was firmed from a planned order or was simply created using the new record form.  If it was firmed using a planned order, was the qty in the planned order used when firming, or was it changed by the user.  Trying to build a kpi around this as I did this often with other companies using SAP.  I'm not finding anyway to locate these details in AX. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans