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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cancel WorkOrder not r...
Microsoft Dynamics AX (Archived)

Cancel WorkOrder not reported as finished.

(0) ShareShare
ReportReport
Posted on by AlejandroMtz 70

Hello.. I have being reading about this and I found this is not possible in standard  AX2009 (maybe neither in AX2012).

All I now in resume is that we shoud reset status and delete the order. Why keeping it?... Well, Here is our reason...

Old Workorders for main assemblies got never RAF (only subassys WOs, Bad practice by production), Inventory is corrupted and we are migrating to AX2012 and only Open WOs, SOs and POs will be moved to AX2012.

I need very old opened WO have Ended status as I don't want to move them to AX2012, Also I don't want to remaind as finish be considered for further planning, I don't want to delete the orders (reset status to Created > Delete) becuase I want keep the evidence those orders existed, were never RAF but are completed in fact. Remember inventory is corrupt and will be fixed during migration.

I my case I'm think i can reach my goal creating a production Group called CXLBYADMIN. Then I update via T-SQL ProdTable PRODSTATUS = 7, REMAININVENTPHYSICAL = 0, PRODGROUPID = 'CXLBYADMIN'.

No Journal gets created for this of course and i don't want it, Also remaining will be 0, then no replenishment nor demand for it will be considered.. I mark the ProdGroupId in case I want ot quickle grab a report of the WOs that I manually cancel via SQL.

I'm I correct?, I'm a .NET developer in process learning Functional AX2009 and AX2012. I tested with one WO and looks fine.. 

Any comments from Experts?

I really appreciate your comments and help in advance.

*This post is locked for comments

I have the same question (0)
  • Guy Terry Profile Picture
    Guy Terry 28,888 Moderator on at
    RE: Cancel WorkOrder not reported as finished.

    Why do you want to set the very old opened WO to Ended? Is it because you will migrate opened WO to AX 2012? If so, can't you just set the migration to ignore WOs older than a certain date?

  • Verified answer
    Weaveriski Profile Picture
    Weaveriski 23,616 Moderator on at
    RE: Cancel WorkOrder not reported as finished.

    I would reset the status of each one to cancelled and remove them. Forget about the evidence the orders existed.

    Your stock is wrong and you want a historical cleanse so remove them. You cannot report for 0 so to end them you would need to RAF>0 which impacts on costing and stock, so you would then need to remove it - but with a corrupt inventory you need to do this anyway.

    I would use standard AX and would not undertake direct SQL updates.

  • AlejandroMtz Profile Picture
    AlejandroMtz 70 on at
    RE: Cancel WorkOrder not reported as finished.

    Hi Guy, I dont't really want to end them. I want to Cancel them so I can keep them. But "Cancelled" status does not exists. That's why I just updated Prodstatus to 7 and ProdGroupId to "CXLBYADMIN" in order to be able to know which ones are Cancelled.

    Does this really hurts? i mean.. im not deleting jorunals or transactions nor creating/deleting transactional data manually with SQL.. Just a status update to disable options for those WOs and avoid be considered for replenishment..  Is that really bad? :/

  • Guy Terry Profile Picture
    Guy Terry 28,888 Moderator on at
    RE: Cancel WorkOrder not reported as finished.

    Did you test that setting them to Ended in SQL actually hides them from MRP? Since I think MRP uses Inventory transactions to see what inventory is likely to be manufactured, and setting a production order to ended via SQL will not remove the related Inventory transaction.

  • AlejandroMtz Profile Picture
    AlejandroMtz 70 on at
    RE: Cancel WorkOrder not reported as finished.

    Hi Steven.. I understand that about no doing anything directly with SQL but I already did hoho o.O'...  I did a SQL script to rollback this too.. so I can go back to reset status to RAF and clear ProdGroupId... then do whatyou said directly in AX. I'm a Developer and that's why I prefer SQL, just convenience and cuz is faster. in addition, as i mentioned above.. I didn't deleted/modified/created transactions or journals.. it was just a status update and to avoid actions in thoe orders and field update (that used to be empty) just for reference.

    Do you really think it was so bad?

  • AlejandroMtz Profile Picture
    AlejandroMtz 70 on at
    RE: Cancel WorkOrder not reported as finished.

    Inventory is corrupted so MRP not really works ¬¬' .. We are migrating to AX2012 due to corporate directions next month. So, with a starting physical inventory, then adjust the AX Inventory, and finally hope this do not happen again once I'm here to monitor.

    I started working a couple months here and started getting used to AX(I used to be base Product Developer in other ERP) and departments process, production included, which was since my perspective the main guilty of this mess.. After few months, now I reallized several facts and that drove me to think It was better to keep them and just update the status.

    I can go back and do what you and Steven say if any problem occurs at some point of migration.

  • Weaveriski Profile Picture
    Weaveriski 23,616 Moderator on at
    RE: Cancel WorkOrder not reported as finished.

    It feels like you asked for opinions but had actually made the decision and are doing it anyway and any issues you will deal with later. So  best if luck with it.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans