Try setting QTY to 0 and change status to “UPDATE”
UPDATE invoicelinedetail set Quantity=0 where IDKEY='[TxnID]’ <– txnid from invoice
UPDATE invoice SET status = ‘UPDATE’,Memo=’Deleted OpenSYnc’ WHERE TxnID = ”
@raymond1 I have the same problem with .25 that it crashes only when deleting a task.
plus once it crashes it still keep the setting before it crashed.
but I use OpenSync Configure only once and then re-run the same task.
if you want to modify a task manually you can go edit
it is where all the tasks are stored the Password is stored in a format of ESD not if you can’t generate ESD format I would install OPenSync trail on another PC and try copying the settings.
@mark welcome to QuickBooks, API don’t expect anything to work perfectly, in particular, hold your fingers after an update 🙂
It sounds like you should be using a sale receipt.
if an invoice is paid straight away there is no point in making an invoice just make a sale-receipt
and make sure you apply to “undeposite funds” or directly to the right bank account you receive the payment.
The other option I am using I have a table called “ApplyCredit” which I created.
and the end of the day I click a button and all the credit is uploaded.
if the customer wants an invoice printed showing the amount is paid, I generate an invoice that check if there is “pending credit to upload” and does the calculation.
Ok uploaded it to google drive you can use https://drive.google.com/open?id=14TEVqDwG4_jr30nEffxZ9gxDCXKf2bLL
what is your email I will send you a link
Ok I manage to find a copy of ver 3.0.25 now everything is working again.
so bugs in v 3.0.28 to fix
A) ItemInventory – The entire table cannot be UPDATED any part.
B) Invoice – when changing QTY to 0 it keeps it as 1
C) [dbo].[error_table] table need to change the field [TIME_DATE] to varchar(200) as I use D/M/Y format.
I get – 404 – File or directory not found. in that URL provided.
Another bug when updating an invoice and changing the QTY to 0
it does not register it. and keeps the QTY on 1.
is it possible to provide a link to ver 3.0.25?
can you share the script how to check if quickbooks crash?
do you use timer? or is there some quickbooks .log file that indicates it?
All this “Addional” tables are a mess i never used them.
If I was you I would remove it from the list of table syncs and use other fields that are more reliable.
like Memo field. seem to work well.
just login to your account and download it?
Was it released?
Just an idea I don’t know if it will work but you can use putty.exe and do SSH tunning to your entire computer. then you can run opensync to connect to your SQL database.
I am sure there is better software than putty that support this.
Yudel any estimated time for release 3.2?