Skip to main content
Solved

How to locate deleted Sales Orders with a GI?

  • February 20, 2024
  • 2 replies
  • 354 views

gmast
Freshman I

We noticed recently that we have had a few sales order #’s skip in sequence.  This only happens if someone deleted a Sales Order. While we probably need to tighten up our security to prevent this from a broader set of team members, I’m wondering if we can create a GI that is able to identify deleted sales orders?  We have been able to do so with deleted Stock Items and notice that some records have an “IS DELETED” field.  We cannot locate this on the Sales Order table - PX.Objects.SO.SOOrder?

Best answer by darylbowman

I could be wrong, but I believe the ‘Show deleted records’ checkbox will only work if the database table has a ‘DeletedDatabaseRecord’ field. This field is optional to include and tells Acumatica to hide the record from view rather than deleting it. Since SOOrder does NOT have this field, records are actually deleted out of the database, making viewing them impossible.

View original
Did this topic help you find an answer to your question?

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • February 20, 2024

Hello,

If you click Customization , Edit Generic Inquiry, there is a checkbox you can check ON to Show Deleted Records.

If the table has no “is deleted” field… perhaps there is a Deleted status or another field that will help identify the deleted records?  I think, look at ‘Database Record Status’.

Laura


darylbowman
Captain II
Forum|alt.badge.img+13
  • 1683 replies
  • Answer
  • February 20, 2024

I could be wrong, but I believe the ‘Show deleted records’ checkbox will only work if the database table has a ‘DeletedDatabaseRecord’ field. This field is optional to include and tells Acumatica to hide the record from view rather than deleting it. Since SOOrder does NOT have this field, records are actually deleted out of the database, making viewing them impossible.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings