Quickbooks 2015 Hack

I need someone who can figure out how to delete a "condensed" Journal Entry in QB and provide a utility to do this.  If you do not know what this type of entry is, please do not respond.
boordwWebsite Developer/ Designer Needed - Python ExperienceAsked:
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.

JohnBusiness Consultant (Owner)Commented:
There is no native ability in QuickBooks to do this. You need to use the Intuit database repair facility.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
boordwWebsite Developer/ Designer Needed - Python ExperienceAuthor Commented:
That's why I asked for a utility of some sort to be written.  I'm not asking for QB instructions.  Thanks.
JohnBusiness Consultant (Owner)Commented:
I do not think there is a utility. Damaged transactions must be fixed by Intuit. I have done this before.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Bill BachPresident and Btrieve GuruCommented:
While I've not tried it with Journal entries, I use the QODBC tool to directly (and safely) edit data in my QB environment all the time via straight SQL queries.  With QB Enterprise, you get a free read-only copy, but you have to pay for the Read-Write version, but if you only need it this one time, you may be able to use the 30-day trial to get done what you need done.  

Note that although QODBC opens up the entire QB database to the ODBC interface, it still leverages the QB SDK under the covers -- meaning that there are some operations that it will simply NOT allow.  Will it allow the change you need?  You'd need to try it & see for sure.

Sorry that it is not a complete answer, but hopefully it is a push in the right direction.
boordwWebsite Developer/ Designer Needed - Python ExperienceAuthor Commented:
Thanks Bill.  I'll see if I can make it work.  Any chance you could give me a simple sample SQL command to use in this environment to, let's say, change the date of CK #1001 from 09/30/2015 to 10/01/2015?
Bill BachPresident and Btrieve GuruCommented:
Something along this line should work:
   UPDATE BillPaymentCheck
   SET TxnDate = {d '2015-10-01'}
   WHRERE RefNumber = '1001';
Note that if you have multiple bank accounts, you might need to specify an account restriction as well.  Additional details about data structures available in QODBC can be found at http://qodbc.com/schema.htm.
JohnBusiness Consultant (Owner)Commented:
Did you try Bill's approach?  Otherwise you need the Intuit repair facility.
JohnBusiness Consultant (Owner)Commented:
No native QB facility for this. Author must use the Intuit Repair facility.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.