SQL Query - To Delete a Closed Batch

Nov 01, 2006 2 Replies
D

I have several batches with errors which will not post to Quickbooks because of Missing or incorrect Supplier information in a closed P.O. Since I cannot edit a closed P.O., I would like to remove them from the closed batch list.



Could someone please provide me a SQL Statement so they will not continue to show on the Post CLosed Batches list. I will do the posting manually in QuickBooks for these batches.



Thank You,



David Walker


Vote
Twitter Facebook LinkedIn
C

David, You could switch the accounting type to a quickbooks file, post the batches with errors in them, and then switch back to integration with quickbooks

Vote
Twitter Facebook LinkedIn
N

open File|Configuration|Options|Purchase order options|Allow edit of closed purchase orders just check this option, and go correct your closed orders

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required