QODBC: Modify all existing invoices, item, description fields

I am new to QODBC but not SQL.  I am trying to eliminate manual data entry for a special project for my company.

On every invoice in our system, or each "Item" on each invoice, there is text field called "Description".  I need to replace the text that is currently in the "Description" field with the text "service".  See attachment for an example.

I want to update every invoice in our quickbooks database like this.  We need todo this, because we have private information in that text field, and I need to provide a copy of my quickbooks database to a 3rd party.

What would be the QODBC code to accomplish this?  I am open to another method (besides QODBC).  I just need to get this done ASAP.  I have also posted a freelance job post on upwork to see if I can pay someone to code this for me.

Thank you ahead of time for your help.
Accounting3.jpg
LVL 1
far182Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Bill BachPresidentCommented:
You can do this with a simple UPDATE statement, but it might take a real long time to run.  First, determine which item descriptions you want to change -- I expect that this will be only for some Items, and not absolutely EVERYTHING.  Second, determine the item ID for the item(s) that you want to change.  Once you have that, then the rest is easy:
    UPDATE InvoiceLine
    SET InvoiceLineDesc = 'Service'
    WHERE InvoiceLineItemRefListId = 'the_item_ID';
0
All Courses

From novice to tech pro — start learning today.