Sage 50 UKI Ideas Portal

Make the deleted record field active

There is a record deleted field in most Sage tables, but they do not function. Make it like the inactive field. Although the record disappears from view, via ODBC or SDO, they are still visible.

  • Guest
  • Oct 19 2023
  • Guest commented
    October 23, 2023 12:35

    The flag tells you it is deleted, so in ODBC you can exclude those with the deleted flag set by adding it to your WHERE clause.