Apologies for posting in the wrong forum - I couldn't see a forum for posting queries with Microsoft Access.

I am trying to integrate Quickbooks with Microsoft Access to post transactions directly from a simple POS screen to Quickbooks.

Basically, I am taking each line of the POS screen, adding it to InvoiceLine, closing it by creating a Line in Invoice, and then attempting to add a payment for the invoice just created.

If I have optimization turned on, then the whole process runs very quickly, but it will not post the payment against the invoice - I think because the Invoice table has not refreshed, and therefore it can't retrieve the TxnID

If I turn optimization off, it all runs perfectly - but incredibly slowly.

Any advice please?

Paul

Actually you should be using SP_LASTINSERTID to find TxnID of the Invoice immediately after you created all the lines in the Invoice:

SP_LASTINSERTID Invoice

And then when you're finished making the payments you can resync your optimized Invoice table by running:-

sp_optimizefullsync Invoice

Tom

Thanks - how do I call this from within Access?

Paul