Unified Operations & Dynamics AX Forum

​Has anyone had to restore a sales order from backup?

Someone accidentally deleted an SO from our PRD environment and there is an open invoice against that SO.  I'm thinking that we would somehow restore the SalesTable and SalesLine records from backup for that SO.  But are there other tables that we would also have to restore records to?  (We are on AX 2012 R2.)

------------------------------
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
------------------------------
​

Hi Rudy,

Depending on your parameters in AR, the deleted order may still be visible is the "Voided Orders", you can find that in the Inquiries/History menu path.  You won't be able to restore, however you will be able to see what was ordered etc.

Regards
Phil

------------------------------
Phil Dawson
Data#3 Limited
Toowong
------------------------------

Original Message:
Sent: 12-05-2018 04:45 PM
From: Rudy Salcedo
Subject: User accidentally deleted a Sales Order

​Has anyone had to restore a sales order from backup?

Someone accidentally deleted an SO from our PRD environment and there is an open invoice against that SO.  I'm thinking that we would somehow restore the SalesTable and SalesLine records from backup for that SO.  But are there other tables that we would also have to restore records to?  (We are on AX 2012 R2.)

------------------------------
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
------------------------------
​

Hi Rudy,
To avoid similar issues in the future you should possibly rethink and redesign your users roles and what they are allowed to do.
Best regards,
Ludwig

------------------------------
Ludwig Reinhard
Sycor
Veitshoechheim
------------------------------

Original Message:
Sent: 12-05-2018 04:45 PM
From: Rudy Salcedo
Subject: User accidentally deleted a Sales Order

​Has anyone had to restore a sales order from backup?

Someone accidentally deleted an SO from our PRD environment and there is an open invoice against that SO.  I'm thinking that we would somehow restore the SalesTable and SalesLine records from backup for that SO.  But are there other tables that we would also have to restore records to?  (We are on AX 2012 R2.)

------------------------------
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
------------------------------
​

Do you enter Sales Orders via EDI or manually?

------------------------------
John Bergman
The Mennel Milling Company
Fostoria OH
------------------------------

Original Message:
Sent: 12-05-2018 04:45 PM
From: Rudy Salcedo
Subject: User accidentally deleted a Sales Order

​Has anyone had to restore a sales order from backup?

Someone accidentally deleted an SO from our PRD environment and there is an open invoice against that SO.  I'm thinking that we would somehow restore the SalesTable and SalesLine records from backup for that SO.  But are there other tables that we would also have to restore records to?  (We are on AX 2012 R2.)

------------------------------
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
------------------------------
​

​If you retain copies of SOs that are deleted in Voided Sales orders, as @Phil Dawson mentions, you have a chance, because the record fields are mapped to a container field.
Attached is what I use (AX2009). Depending on the state of your SO lines, you may have to tinker with the line qty values and associations with InventTrans related records. As usual, model in test.

------------------------------
Mark Prouty
Programmer / Analyst
ANGI Energy Systems
Janesville WI
------------------------------

Original Message:
Sent: 12-05-2018 04:45 PM
From: Rudy Salcedo
Subject: User accidentally deleted a Sales Order

​Has anyone had to restore a sales order from backup?

Someone accidentally deleted an SO from our PRD environment and there is an open invoice against that SO.  I'm thinking that we would somehow restore the SalesTable and SalesLine records from backup for that SO.  But are there other tables that we would also have to restore records to?  (We are on AX 2012 R2.)

------------------------------
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
------------------------------
​

​Thanks everyone, to answer some of your questions...the SOs are manually entered, and we do have our AR parameters set up such that we can see deleted orders in the "Voided sales orders" menu option.

@Mark Prouty, thanks for the code for your solution.  I'll tweak and test it in a dev or test environment to see if I can make it work for our purpose.  Thanks!

 ​

------------------------------
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
------------------------------

Original Message:
Sent: 12-06-2018 09:30 AM
From: Mark Prouty
Subject: User accidentally deleted a Sales Order

​If you retain copies of SOs that are deleted in Voided Sales orders, as @Phil Dawson mentions, you have a chance, because the record fields are mapped to a container field.
Attached is what I use (AX2009). Depending on the state of your SO lines, you may have to tinker with the line qty values and associations with InventTrans related records. As usual, model in test.

------------------------------
Mark Prouty
Programmer / Analyst
ANGI Energy Systems
Janesville WI

Original Message:
Sent: 12-05-2018 04:45 PM
From: Rudy Salcedo
Subject: User accidentally deleted a Sales Order

​Has anyone had to restore a sales order from backup?

Someone accidentally deleted an SO from our PRD environment and there is an open invoice against that SO.  I'm thinking that we would somehow restore the SalesTable and SalesLine records from backup for that SO.  But are there other tables that we would also have to restore records to?  (We are on AX 2012 R2.)

------------------------------
Rudy Salcedo
Senior Programmer/Analyst
LaForce, Inc
Green Bay WI
------------------------------
​