[QODBC-Desktop] How to create Journal Entries using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM
|
|
Two Examples of Creating Journal EntriesCreate a Journal Entry with 2 Credit Lines and 2 Debit LinesNote: This example creates one Journal Entry with two credit lines and two debit lines. Note the FQSaveToCache field, set to True except on the last line. Also, when saving Journal Entries, QuickBooks will reject transaction which does not balance the Credit and Debit sides. First Credit Line INSERT INTO "JournalEntryCreditLine" ("RefNumber", "JournalCreditLineAccountRefListID", "JournalCreditLineAmount", "JournalCreditLineMemo", "FQSaveToCache") VALUES ('1', '120000-933270542', 1.11, 'Test Memo 1', 1) Second Credit Line INSERT INTO "JournalEntryCreditLine" ("RefNumber", "JournalCreditLineAccountRefListID", "JournalCreditLineAmount", "JournalCreditLineMemo", "FQSaveToCache") VALUES ('1', '120000-933270543', 2.22, 'Test Memo 2', 1) First Debit Line INSERT INTO "JournalEntryDebitLine" ("RefNumber", "JournalDebitLineAccountRefListID", "JournalDebitLineAmount", "JournalDebitLineMemo", "FQSaveToCache") VALUES ('1', '120000-933270544', 1.11, 'Test Memo 1', 1) Second Debit Line INSERT INTO "JournalEntryDebitLine" ("RefNumber", "JournalDebitLineAccountRefListID", "JournalDebitLineAmount", "JournalDebitLineMemo", "FQSaveToCache") VALUES ('1', '120000-933270545', 2.22, 'Test Memo 2', 0) Create a Journal Entry with 1 Credit Line and 1 Debit LineNote: The QuickBooks sample files set the QuickBooks system date at Nov 15, 2021, here, so I have used these sample SQL insert statements to demonstrate using future dates in a journal entry: Create a Credit Line INSERT INTO "JournalEntryCreditLine" ("TxnDate", "RefNumber",
Create a Debit Line INSERT INTO "JournalEntryDebitLine" ("TxnDate", "RefNumber",
TxnLineIDs Locate SELECT JournalCreditLineTxnLineID, JournalDebitLineTxnLineID
| |
|
For example, if I insert to the "Professional Fees" account using a list ID of "XYZ", the insert works correctly but then a query against the Accounts table will show two "Professional Fees" accounts -- the original one and new one with all the same values (including ListId = "XYZ") but a different TimeModified.
Any thoughts on why this might be happening or what I could do?
I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit
I kindly request you to share more information about the issue you’re facing, so that we can locate the problem quickly.
We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About (Start>>All Programs>> QODBC Driver for use with QuickBooks>> QODBC Setup Screen >> About Tab )
2) Screenshot of the issue you’re facing.
3) Share QuickBooks Version details: Press f2 on QuickBooks UI & share screenshot.
4) Share the SQL statement you’re using.
Share Entire Log Files as an attachment in text format from
5) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
6) QODBC Setup Screen -- > Messages -- > Review SDK Messages