title: Sage50 OBDC [RECORD_DELETED] field isn't working
body: <p>I am trying to import invoices from Sage 50 UK using MS access. The problem I am facing is that sometimes, the invoices on sage might have had a product on it before but, has since been removed. Unfortunately, using a select * query on [INVOICE_ITEM] will include all items on the invoice, <strong>including deleted records.</strong></p>
  
  <p>Judging by the database schema on <a href="https://docs.zynk.com/workflow/developers/sage-50-uk-schema/sage-50-uk-invoice_item-columns.html#RECORD_DELETED" rel="nofollow noreferrer">here</a>, sage seems to use a RECORD_DELETED field in order to keep track of items (products) that are no longer supposed to be on the invoice. Obviously, the next step is to use a WHERE in the query to exclude the deleted records. Well, unfortunately, my RECORD_DELETED field is always showing the default "0" value - even for actual deleted items on the invoice!</p>
  
  <p><strong>Example, highlighted record is actually supposed to be deleted.</strong></p>
  
  <p><img src="https://i.stack.imgur.com/EqNdP.png"></p>
  
  <p>Would appreciate any help here!</p>