[QODBC-Desktop] Troubleshooting - Invoice RefNumber FAQ
Posted by Jack - QODBC Support on 02 March 2015 12:20 PM
|
|
Troubleshooting - Invoice RefNumber FAQProblem Description: I have invoice number (RefNumber) from my own table outside of QuickBooks. But if QuickBooks user creates invoices directly in QuickBooks then QuickBooks keeps new incrementing invoices automatically and the next invoice I create using my outside table will be incorrect. Solutions: While inserting new invoice from QODBC, if you do not pass RefNumber, QuickBooks will automatically manage and assign a RefNumber to the newly inserted invoice. Problem Description: How do I Auto increment Ref Number for Invoice? Solutions: While inserting new invoice from QODBC, if you do not pass RefNumber, QuickBooks will automatically increment and assign a RefNumber to the newly inserted invoice. Problem Description: How do I Get max and insert RefNumber for Invoice? Solutions: You can get max RefNumber for Invoice by using below query & add 1 to result and can create new Invoice:
We got 2581 as max RefNumber. Now we are creating the new invoice with RefNumber 2582.
Problem Description: What happens If I use the same RefNumber for Invoice creation? Solutions: QuickBooks is allowing duplicate RefNumber. So when you use the same RefNumber for Invoice creation. QuickBooks will create Invoice with duplicate RefNumber/ Problem Description: How do I Auto Increment Alphanumeric RefNumber for Invoice? Solutions: First, create any Invoice from QuickBooks UI & assign alphanumeric RefNumber "R0001T". Now create new Invoice from QODBC & do not pass RefNumber, QuickBooks will automatically increment and assign a RefNumber (i.e. "R0002T") to the newly inserted invoice.
| |
|