Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
How to remove Duplicate Invoices |
Author |
Message |
|
Posted : 2006-09-14 08:02:27 |
I have a custom written application that used the QB SDK to import invoices from a SQL based application into QuickBooks. When we upgraded from QBES 4 to QBES 6 that application still worked correctly. However for one batch of invoices, something happened and while the invoices were imported into QuickBooks, they application did not mark them as imported in the SQL application.
This happened for only one batch. I was able to import correctly before this batch, and since this batch.
But the invoices in this batch have now been imported 4 times.
Using the qODBC drivers, how can I safely removed these invoices. Secondly, will removing the invoices automatically update all related fields in other records / tables, such as Customer's balance? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-14 09:25:02 |
Using QODBC you use the standard SQL DELETE statement and the TxnID of the invoice to delete the invoice:
Delete from Invoice where TxnID='5D43-1197768681'
QODBC sends the delete request to QuickBooks and QuickBooks will automatically make the necessay changes to the Customer balance etc. |
|
|
|
|