Pass the json string to the JournalEntry.Line propertyĬontextQuickbooks.JournalEntries. JournalEntry journalEntry = new JournalEntry() View More needs to be preferred in this step. Convert the list of line item objects to json In QuickBooks, to view journal entries, the following directions should be read: Click-open QB. JournalEntryLineItem debitLine = new JournalEntryLineItem() ĭebitLine.JournalEntryLineDetail_AccountRefId = debitAccount.Id ĭebitLine.JournalEntryLineDetail_AccountRefName = debitAccount.Name ĭebitLine.JournalEntryLineDetail_PostingType = "Debit" ĭebitLine.DetailType = "JournalEntryLineDetail" JournalEntryLineItem creditLine = new JournalEntryLineItem() ĬreditLine.JournalEntryLineDetail_AccountRefId = creditAccount.Id ĬreditLine.JournalEntryLineDetail_AccountRefName = creditAccount.Name ĬreditLine.JournalEntryLineDetail_PostingType = "Credit" ĬreditLine.DetailType = "JournalEntryLineDetail" Query to the the QBO Account objects for our known AcctNum valuesĪccount creditAccount = (x => x.AcctNum = "4060-1").FirstOrDefault() Īccount debitAccount = (x => x.AcctNum = "1111").FirstOrDefault()
![quickbooks journal entry debit credit quickbooks journal entry debit credit](https://quickbooks.intuit.com/us/oicms_us/uploads/2020/09/Journal-2.png)
''' QuickbooksEntities contextQuickbooks = new QuickbooksEntities() using an array of objects rather than a list of objects.Querying Google for that error turned up nothing.
![quickbooks journal entry debit credit quickbooks journal entry debit credit](https://www.principlesofaccounting.com/wp-content/gallery/quickbooks/journal.entry_.png)
"Unable to cast object of type '' to type ''" Support suggested, to the OP, assembling the entry as Json and assigning it to the JournalEntry.Line property. That suggested this isn't your normal Entity Framework walk in the park. I found an article on Devart's forum: forum link
![quickbooks journal entry debit credit quickbooks journal entry debit credit](https://www.wizxpert.com/wp-content/uploads/2020/03/Journal-Entry-for-Loan-in-QuickBooks.png)
(dotConnect for Quickbooks is version 1.10 and Entity Framework is version 6) I'm using a dotConnect for Quickbooks utility from Devart to create some General Journal Entries in Quickbooks Online using C# and Entity Framework.