[QODBC-Desktop] Troubleshooting - Who Created an Invoice/SalesOrder
Posted by Jack - QODBC Support on 18 August 2017 01:03 PM
Troubleshooting - Who Created an Invoice/SalesOrder
We don't have an operational problem, just a SQL/technical question -- we are currently pulling invoices like this:
SELECT * FROM Invoice WHERE RefNumber ='221206' (works great)
But it does NOT tell which QuickBooks user CREATED/ENTERED the Invoice/SalesOrder. (We do NOT use Sales Reps, we just want to know the actual user that typed in the order).
Where can we find this information? Can I use the TxnID from either then Invoice or SalesLine in another table to determine who entered that Invoice or line item?
QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn’t expose one feature to the application in SDK, QODBC could not do it either.
I'm sorry to inform you that the QuickBooks user details who Created/Entered the Invoice/SalesOrder is not available through the Intuit SDK so they are not available through QODBC.
As a workaround, you can create the custom field with the name (QBUser) in customer center & you can use it on Invoice/SalesOrder. You need to create the custom field in customer & define this field in Invoice template.
Once you define the custom field in Invoice/SalesOrder, You can store QBUser details on the custom field which is also available in QODBC Invoice/InvoiceLine table with name CustomField+(Field name you created). If you created the custom field with name QBUser then in QODBC you can find column "CustomFieldQBUser".
You can get the custom field in QODBC after defining custom fields in QuickBooks.
Note: You need to Disconnect the connection between QODBC & QuickBooks and Reconnect to get Custom Field. Custom Field will display in QODBC after resetting the connection.