In traditional accounting, transactions are entered into the general journal and categorized exclusively by account. In QuickBooks, most transactions can be categorized either by account or by type (invoice, check, and so on). For a few activities in QuickBooks, you must use the general journal directly, for example for recording depreciation. Notice that you must supply the credit line and a corresponding debit line in the same request. It will not work to supply them in two distinct requests. You can supply as many credit lines and debit lines in one single request as you want so long as the total monetary amount from the credits equals the total monetary amount from the debits in that request. Finally, DO NOT supply negative sign for the monetary amounts. QuickBooks does that for you. If you do supply the negative sign amounts will add instead of cancel and you’ll get a runtime error. Querying for Condensed Transactions If you need the query to return condensed transactions, you can do this by using either an Entity or Account filter in the journal query request. Alternatively, you could use the The generic TransactionQuery, which can return condensed transactions.
Request
Response
XMLOps
VB.NET
C#
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 | <?xml version="1.0" encoding="utf-8"?> <?qbxml version="16.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <JournalEntryQueryRq metaData="ENUMTYPE" iterator="ENUMTYPE" iteratorID="UUIDTYPE"> <!-- BEGIN OR --> <TxnID >IDTYPE</TxnID> <!-- optional, may repeat --> <!-- OR --> <RefNumber >STRTYPE</RefNumber> <!-- optional, may repeat --> <!-- OR --> <RefNumberCaseSensitive >STRTYPE</RefNumberCaseSensitive> <!-- optional, may repeat --> <!-- OR --> <MaxReturned >INTTYPE</MaxReturned> <!-- optional --> <!-- BEGIN OR --> <ModifiedDateRangeFilter> <!-- optional --> <FromModifiedDate >DATETIMETYPE</FromModifiedDate> <!-- optional --> <ToModifiedDate >DATETIMETYPE</ToModifiedDate> <!-- optional --> </ModifiedDateRangeFilter> <!-- OR --> <TxnDateRangeFilter> <!-- optional --> <!-- BEGIN OR --> <FromTxnDate >DATETYPE</FromTxnDate> <!-- optional --> <ToTxnDate >DATETYPE</ToTxnDate> <!-- optional --> <!-- OR --> <!-- DateMacro may have one of the following values: All, Today, ThisWeek, ThisWeekToDate, ThisMonth, ThisMonthToDate, ThisCalendarQuarter, ThisCalendarQuarterToDate, ThisFiscalQuarter, ThisFiscalQuarterToDate, ThisCalendarYear, ThisCalendarYearToDate, ThisFiscalYear, ThisFiscalYearToDate, Yesterday, LastWeek, LastWeekToDate, LastMonth, LastMonthToDate, LastCalendarQuarter, LastCalendarQuarterToDate, LastFiscalQuarter, LastFiscalQuarterToDate, LastCalendarYear, LastCalendarYearToDate, LastFiscalYear, LastFiscalYearToDate, NextWeek, NextFourWeeks, NextMonth, NextCalendarQuarter, NextCalendarYear, NextFiscalQuarter, NextFiscalYear --> <DateMacro >ENUMTYPE</DateMacro> <!-- optional --> <!-- END OR --> </TxnDateRangeFilter> <!-- END OR --> <EntityFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- OR --> <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional --> <!-- OR --> <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional --> <!-- END OR --> </EntityFilter> <AccountFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- OR --> <ListIDWithChildren >IDTYPE</ListIDWithChildren> <!-- optional --> <!-- OR --> <FullNameWithChildren >STRTYPE</FullNameWithChildren> <!-- optional --> <!-- END OR --> </AccountFilter> <!-- BEGIN OR --> <RefNumberFilter> <!-- optional --> <!-- MatchCriterion may have one of the following values: StartsWith, Contains, EndsWith --> <MatchCriterion >ENUMTYPE</MatchCriterion> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- required --> </RefNumberFilter> <!-- OR --> <RefNumberRangeFilter> <!-- optional --> <FromRefNumber >STRTYPE</FromRefNumber> <!-- optional --> <ToRefNumber >STRTYPE</ToRefNumber> <!-- optional --> </RefNumberRangeFilter> <!-- END OR --> <CurrencyFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- END OR --> </CurrencyFilter> <!-- END OR --> <IncludeLineItems >BOOLTYPE</IncludeLineItems> <!-- optional --> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional, may repeat --> </JournalEntryQueryRq> <JournalEntryQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE"> <JournalEntryRet> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- required --> <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required --> <TimeModified >DATETIMETYPE</TimeModified> <!-- required --> <EditSequence >STRTYPE</EditSequence> <!-- required --> <TxnNumber >INTTYPE</TxnNumber> <!-- optional --> <TxnDate >DATETYPE</TxnDate> <!-- required --> <RefNumber >STRTYPE</RefNumber> <!-- optional --> <IsAdjustment >BOOLTYPE</IsAdjustment> <!-- optional --> <IsHomeCurrencyAdjustment >BOOLTYPE</IsHomeCurrencyAdjustment> <!-- optional --> <IsAmountsEnteredInHomeCurrency >BOOLTYPE</IsAmountsEnteredInHomeCurrency> <!-- optional --> <CurrencyRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CurrencyRef> <ExchangeRate >FLOATTYPE</ExchangeRate> <!-- optional --> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> <!-- BEGIN OR --> <JournalDebitLine defMacro="MACROTYPE"> <!-- optional --> <TxnLineID >IDTYPE</TxnLineID> <!-- optional --> <AccountRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </AccountRef> <Amount >AMTTYPE</Amount> <!-- optional --> <Memo >STRTYPE</Memo> <!-- optional --> <EntityRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </EntityRef> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <ItemSalesTaxRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemSalesTaxRef> <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled --> <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional --> </JournalDebitLine> <!-- OR --> <JournalCreditLine defMacro="MACROTYPE"> <!-- optional --> <TxnLineID >IDTYPE</TxnLineID> <!-- optional --> <AccountRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </AccountRef> <Amount >AMTTYPE</Amount> <!-- optional --> <Memo >STRTYPE</Memo> <!-- optional --> <EntityRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </EntityRef> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <ItemSalesTaxRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemSalesTaxRef> <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled --> <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional --> </JournalCreditLine> <!-- END OR --> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: AMTTYPE, DATETIMETYPE, INTTYPE, PERCENTTYPE, PRICETYPE, QUANTYPE, STR1024TYPE, STR255TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </JournalEntryRet> </JournalEntryQueryRs> </QBXMLMsgsRq> </QBXML> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 | 'The following sample code is generated as an illustration of 'Creating requests and parsing responses ONLY 'This code is NOT intended to show best practices or ideal code 'Use at your most careful discretion imports System imports System.Net imports System.Drawing imports System.Collections imports System.ComponentModel imports System.Windows.Forms imports System.Data imports System.IO imports Interop.QBFC16 Module com.intuit.idn.samples Public Class Sample Public Sub DoJournalEntryQuery() Dim sessionBegun as Boolean sessionBegun = False Dim connectionOpen as Boolean connectionOpen = False Dim sessionManager as QBSessionManager sessionManager = nothing Try 'Create the session Manager object sessionManager = new QBSessionManager 'Create the message set request object to hold our request Dim requestMsgSet as IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0) requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue BuildJournalEntryQueryRq(requestMsgSet) 'Connect to QuickBooks and begin a session sessionManager.OpenConnection("","Sample Code from OSR") connectionOpen = True sessionManager.BeginSession("", ENOpenMode.omDontCare) sessionBegun = True 'Send the request and get the response from QuickBooks Dim responseMsgSet as IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet) 'End the session and close the connection to QuickBooks sessionManager.EndSession() sessionBegun = False sessionManager.CloseConnection() connectionOpen = False WalkJournalEntryQueryRs(responseMsgSet) Catch e as Exception MessageBox.Show(e.Message, "Error") if (sessionBegun) then sessionManager.EndSession() End If if (connectionOpen) then sessionManager.CloseConnection() End If End Try End Sub Public Sub BuildJournalEntryQueryRq(requestMsgSet as IMsgSetRequest) Dim JournalEntryQueryRq as IJournalEntryQuery JournalEntryQueryRq= requestMsgSet.AppendJournalEntryQueryRq() Dim ORTxnQueryElementType16633 as String ORTxnQueryElementType16633 = "TxnIDList" if (ORTxnQueryElementType16633 == "TxnIDList") then 'Set field value for TxnIDList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnIDList.Add("200000-1011023419") End If if (ORTxnQueryElementType16633 == "RefNumberList") then 'Set field value for RefNumberList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.RefNumberList.Add("ab") End If if (ORTxnQueryElementType16633 == "RefNumberCaseSensitiveList") then 'Set field value for RefNumberCaseSensitiveList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.RefNumberCaseSensitiveList.Add("ab") End If if (ORTxnQueryElementType16633 == "TxnFilter") then 'Set field value for MaxReturned JournalEntryQueryRq.ORTxnQuery.TxnFilter.MaxReturned.SetValue(6) Dim ORDateRangeFilterElementType16634 as String ORDateRangeFilterElementType16634 = "ModifiedDateRangeFilter" if (ORDateRangeFilterElementType16634 == "ModifiedDateRangeFilter") then 'Set field value for FromModifiedDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false) 'Set field value for ToModifiedDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false) End If if (ORDateRangeFilterElementType16634 == "TxnDateRangeFilter") then Dim ORTxnDateRangeFilterElementType16635 as String ORTxnDateRangeFilterElementType16635 = "TxnDateFilter" if (ORTxnDateRangeFilterElementType16635 == "TxnDateFilter") then 'Set field value for FromTxnDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")) 'Set field value for ToTxnDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")) End If if (ORTxnDateRangeFilterElementType16635 == "DateMacro") then 'Set field value for DateMacro JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll) End If End If Dim OREntityFilterElementType16636 as String OREntityFilterElementType16636 = "ListIDList" if (OREntityFilterElementType16636 == "ListIDList") then 'Set field value for ListIDList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419") End If if (OREntityFilterElementType16636 == "FullNameList") then 'Set field value for FullNameList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab") End If if (OREntityFilterElementType16636 == "ListIDWithChildren") then 'Set field value for ListIDWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419") End If if (OREntityFilterElementType16636 == "FullNameWithChildren") then 'Set field value for FullNameWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab") End If Dim ORAccountFilterElementType16637 as String ORAccountFilterElementType16637 = "ListIDList" if (ORAccountFilterElementType16637 == "ListIDList") then 'Set field value for ListIDList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419") End If if (ORAccountFilterElementType16637 == "FullNameList") then 'Set field value for FullNameList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab") End If if (ORAccountFilterElementType16637 == "ListIDWithChildren") then 'Set field value for ListIDWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419") End If if (ORAccountFilterElementType16637 == "FullNameWithChildren") then 'Set field value for FullNameWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab") End If Dim ORRefNumberFilterElementType16638 as String ORRefNumberFilterElementType16638 = "RefNumberFilter" if (ORRefNumberFilterElementType16638 == "RefNumberFilter") then 'Set field value for MatchCriterion JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith) 'Set field value for RefNumber JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab") End If if (ORRefNumberFilterElementType16638 == "RefNumberRangeFilter") then 'Set field value for FromRefNumber JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab") 'Set field value for ToRefNumber JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab") End If Dim ORCurrencyFilterElementType16639 as String ORCurrencyFilterElementType16639 = "ListIDList" if (ORCurrencyFilterElementType16639 == "ListIDList") then 'Set field value for ListIDList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419") End If if (ORCurrencyFilterElementType16639 == "FullNameList") then 'Set field value for FullNameList 'May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab") End If End If 'Set field value for IncludeLineItems JournalEntryQueryRq.IncludeLineItems.SetValue(True) 'Set field value for IncludeRetElementList 'May create more than one of these if needed JournalEntryQueryRq.IncludeRetElementList.Add("ab") 'Set field value for OwnerIDList 'May create more than one of these if needed JournalEntryQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString()) End Sub Public Sub WalkJournalEntryQueryRs( responseMsgSet as IMsgSetResponse) if (responseMsgSet is nothing) then Exit Sub End If Dim responseList as IResponseList responseList = responseMsgSet.ResponseList if (responseList is nothing) then Exit Sub End If 'if we sent only one request, there is only one response, we'll walk the list for this sample for j=0 to responseList.Count-1 Dim response as IResponse response = responseList.GetAt(j) 'check the status code of the response, 0=ok, >0 is warning if (response.StatusCode >= 0) then 'the request-specific response is in the details, make sure we have some if (not response.Detail is nothing) then 'make sure the response is the type we're expecting Dim responseType as ENResponseType responseType = CType(response.Type.GetValue(),ENResponseType) if (responseType == ENResponseType.rtJournalEntryQueryRs) then 'upcast to more specific type here, this is safe because we checked with response.Type check above Dim JournalEntryRet as IJournalEntryRetList JournalEntryRet = CType(response.Detail,IJournalEntryRetList) WalkJournalEntryRet(JournalEntryRet) End If End If End If Next j End Sub Public Sub WalkJournalEntryRet(JournalEntryRet as IJournalEntryRetList) if (JournalEntryRet is nothing) then Exit Sub End If 'Go through all the elements of IJournalEntryRetList 'Get value of TxnID Dim TxnID16640 as String TxnID16640 = JournalEntryRet.TxnID.GetValue() 'Get value of TimeCreated Dim TimeCreated16641 as DateTime TimeCreated16641 = JournalEntryRet.TimeCreated.GetValue() 'Get value of TimeModified Dim TimeModified16642 as DateTime TimeModified16642 = JournalEntryRet.TimeModified.GetValue() 'Get value of EditSequence Dim EditSequence16643 as String EditSequence16643 = JournalEntryRet.EditSequence.GetValue() 'Get value of TxnNumber if ( not JournalEntryRet.TxnNumber is nothing) then Dim TxnNumber16644 as Integer TxnNumber16644 = JournalEntryRet.TxnNumber.GetValue() End If 'Get value of TxnDate Dim TxnDate16645 as DateTime TxnDate16645 = JournalEntryRet.TxnDate.GetValue() 'Get value of RefNumber if ( not JournalEntryRet.RefNumber is nothing) then Dim RefNumber16646 as String RefNumber16646 = JournalEntryRet.RefNumber.GetValue() End If 'Get value of IsAdjustment if ( not JournalEntryRet.IsAdjustment is nothing) then Dim IsAdjustment16647 as Boolean IsAdjustment16647 = JournalEntryRet.IsAdjustment.GetValue() End If 'Get value of IsHomeCurrencyAdjustment if ( not JournalEntryRet.IsHomeCurrencyAdjustment is nothing) then Dim IsHomeCurrencyAdjustment16648 as Boolean IsHomeCurrencyAdjustment16648 = JournalEntryRet.IsHomeCurrencyAdjustment.GetValue() End If 'Get value of IsAmountsEnteredInHomeCurrency if ( not JournalEntryRet.IsAmountsEnteredInHomeCurrency is nothing) then Dim IsAmountsEnteredInHomeCurrency16649 as Boolean IsAmountsEnteredInHomeCurrency16649 = JournalEntryRet.IsAmountsEnteredInHomeCurrency.GetValue() End If if (not JournalEntryRet.CurrencyRef. is nothing) then 'Get value of ListID if ( not JournalEntryRet.CurrencyRef.ListID is nothing) then Dim ListID16650 as String ListID16650 = JournalEntryRet.CurrencyRef.ListID.GetValue() End If 'Get value of FullName if ( not JournalEntryRet.CurrencyRef.FullName is nothing) then Dim FullName16651 as String FullName16651 = JournalEntryRet.CurrencyRef.FullName.GetValue() End If End If 'Get value of ExchangeRate if ( not JournalEntryRet.ExchangeRate is nothing) then Dim ExchangeRate16652 as IQBFloatType ExchangeRate16652 = JournalEntryRet.ExchangeRate.GetValue() End If 'Get value of ExternalGUID if ( not JournalEntryRet.ExternalGUID is nothing) then Dim ExternalGUID16653 as String ExternalGUID16653 = JournalEntryRet.ExternalGUID.GetValue() End If if (not JournalEntryRet.ORJournalLineList is nothing) then Dim i16654 as Integer for i16654 = 0 to JournalEntryRet.ORJournalLineList.Count - 1 Dim ORJournalLine16655 as IORJournalLine ORJournalLine16655 = JournalEntryRet.ORJournalLineList.GetAt(i16654) if (not ORJournalLine16655.JournalDebitLine is nothing) then if (not ORJournalLine16655.JournalDebitLine. is nothing) then 'Get value of TxnLineID if ( not ORJournalLine16655.JournalDebitLine.TxnLineID is nothing) then Dim TxnLineID16656 as String TxnLineID16656 = ORJournalLine16655.JournalDebitLine.TxnLineID.GetValue() End If if (not ORJournalLine16655.JournalDebitLine.AccountRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalDebitLine.AccountRef.ListID is nothing) then Dim ListID16657 as String ListID16657 = ORJournalLine16655.JournalDebitLine.AccountRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalDebitLine.AccountRef.FullName is nothing) then Dim FullName16658 as String FullName16658 = ORJournalLine16655.JournalDebitLine.AccountRef.FullName.GetValue() End If End If 'Get value of Amount if ( not ORJournalLine16655.JournalDebitLine.Amount is nothing) then Dim Amount16659 as Double Amount16659 = ORJournalLine16655.JournalDebitLine.Amount.GetValue() End If 'Get value of Memo if ( not ORJournalLine16655.JournalDebitLine.Memo is nothing) then Dim Memo16660 as String Memo16660 = ORJournalLine16655.JournalDebitLine.Memo.GetValue() End If if (not ORJournalLine16655.JournalDebitLine.EntityRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalDebitLine.EntityRef.ListID is nothing) then Dim ListID16661 as String ListID16661 = ORJournalLine16655.JournalDebitLine.EntityRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalDebitLine.EntityRef.FullName is nothing) then Dim FullName16662 as String FullName16662 = ORJournalLine16655.JournalDebitLine.EntityRef.FullName.GetValue() End If End If if (not ORJournalLine16655.JournalDebitLine.ClassRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalDebitLine.ClassRef.ListID is nothing) then Dim ListID16663 as String ListID16663 = ORJournalLine16655.JournalDebitLine.ClassRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalDebitLine.ClassRef.FullName is nothing) then Dim FullName16664 as String FullName16664 = ORJournalLine16655.JournalDebitLine.ClassRef.FullName.GetValue() End If End If if (not ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.ListID is nothing) then Dim ListID16665 as String ListID16665 = ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.FullName is nothing) then Dim FullName16666 as String FullName16666 = ORJournalLine16655.JournalDebitLine.ItemSalesTaxRef.FullName.GetValue() End If End If 'Get value of BillableStatus if ( not ORJournalLine16655.JournalDebitLine.BillableStatus is nothing) then Dim BillableStatus16667 as ENBillableStatus BillableStatus16667 = ORJournalLine16655.JournalDebitLine.BillableStatus.GetValue() End If End If End If if (not ORJournalLine16655.JournalCreditLine is nothing) then if (not ORJournalLine16655.JournalCreditLine. is nothing) then 'Get value of TxnLineID if ( not ORJournalLine16655.JournalCreditLine.TxnLineID is nothing) then Dim TxnLineID16668 as String TxnLineID16668 = ORJournalLine16655.JournalCreditLine.TxnLineID.GetValue() End If if (not ORJournalLine16655.JournalCreditLine.AccountRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalCreditLine.AccountRef.ListID is nothing) then Dim ListID16669 as String ListID16669 = ORJournalLine16655.JournalCreditLine.AccountRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalCreditLine.AccountRef.FullName is nothing) then Dim FullName16670 as String FullName16670 = ORJournalLine16655.JournalCreditLine.AccountRef.FullName.GetValue() End If End If 'Get value of Amount if ( not ORJournalLine16655.JournalCreditLine.Amount is nothing) then Dim Amount16671 as Double Amount16671 = ORJournalLine16655.JournalCreditLine.Amount.GetValue() End If 'Get value of Memo if ( not ORJournalLine16655.JournalCreditLine.Memo is nothing) then Dim Memo16672 as String Memo16672 = ORJournalLine16655.JournalCreditLine.Memo.GetValue() End If if (not ORJournalLine16655.JournalCreditLine.EntityRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalCreditLine.EntityRef.ListID is nothing) then Dim ListID16673 as String ListID16673 = ORJournalLine16655.JournalCreditLine.EntityRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalCreditLine.EntityRef.FullName is nothing) then Dim FullName16674 as String FullName16674 = ORJournalLine16655.JournalCreditLine.EntityRef.FullName.GetValue() End If End If if (not ORJournalLine16655.JournalCreditLine.ClassRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalCreditLine.ClassRef.ListID is nothing) then Dim ListID16675 as String ListID16675 = ORJournalLine16655.JournalCreditLine.ClassRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalCreditLine.ClassRef.FullName is nothing) then Dim FullName16676 as String FullName16676 = ORJournalLine16655.JournalCreditLine.ClassRef.FullName.GetValue() End If End If if (not ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef. is nothing) then 'Get value of ListID if ( not ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.ListID is nothing) then Dim ListID16677 as String ListID16677 = ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.ListID.GetValue() End If 'Get value of FullName if ( not ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.FullName is nothing) then Dim FullName16678 as String FullName16678 = ORJournalLine16655.JournalCreditLine.ItemSalesTaxRef.FullName.GetValue() End If End If 'Get value of BillableStatus if ( not ORJournalLine16655.JournalCreditLine.BillableStatus is nothing) then Dim BillableStatus16679 as ENBillableStatus BillableStatus16679 = ORJournalLine16655.JournalCreditLine.BillableStatus.GetValue() End If End If End If Next i16654 End If if (not JournalEntryRet.DataExtRetList is nothing) Dim i16680 as Integer for i16680 = 0 to JournalEntryRet.DataExtRetList.Count - 1 Dim DataExtRet as IDataExtRet DataExtRet = JournalEntryRet.DataExtRetList.GetAt(i16680) 'Get value of OwnerID if ( not DataExtRetOwnerID is nothing) then Dim OwnerID16681 as String OwnerID16681 = DataExtRetOwnerID.GetValue() End If 'Get value of DataExtName Dim DataExtName16682 as String DataExtName16682 = DataExtRetDataExtName.GetValue() 'Get value of DataExtType Dim DataExtType16683 as ENDataExtType DataExtType16683 = DataExtRetDataExtType.GetValue() 'Get value of DataExtValue Dim DataExtValue16684 as String DataExtValue16684 = DataExtRetDataExtValue.GetValue() Next i16680 End If End Sub End Class End Module |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 | //The following sample code is generated as an illustration of //Creating requests and parsing responses ONLY //This code is NOT intended to show best practices or ideal code //Use at your most careful discretion using System; using System.Net; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.IO; using Interop.QBFC16; namespace com.intuit.idn.samples { public class Sample { public void DoJournalEntryQuery() { bool sessionBegun = false; bool connectionOpen = false; QBSessionManager sessionManager = null; try { //Create the session Manager object sessionManager = new QBSessionManager(); //Create the message set request object to hold our request IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0); requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue; BuildJournalEntryQueryRq(requestMsgSet); //Connect to QuickBooks and begin a session sessionManager.OpenConnection("","Sample Code from OSR"); connectionOpen = true; sessionManager.BeginSession("", ENOpenMode.omDontCare); sessionBegun = true; //Send the request and get the response from QuickBooks IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet); //End the session and close the connection to QuickBooks sessionManager.EndSession(); sessionBegun = false; sessionManager.CloseConnection(); connectionOpen = false; WalkJournalEntryQueryRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildJournalEntryQueryRq(IMsgSetRequest requestMsgSet) { IJournalEntryQuery JournalEntryQueryRq= requestMsgSet.AppendJournalEntryQueryRq(); //Set attributes //Set field value for metaData JournalEntryQueryRq.metaData.SetValue("IQBENmetaDataType"); //Set field value for iterator JournalEntryQueryRq.iterator.SetValue("IQBENiteratorType"); //Set field value for iteratorID JournalEntryQueryRq.iteratorID.SetValue("IQBUUIDType"); string ORTxnQueryElementType16581 = "TxnIDList"; if (ORTxnQueryElementType16581 == "TxnIDList") { //Set field value for TxnIDList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnIDList.Add("200000-1011023419"); } if (ORTxnQueryElementType16581 == "RefNumberList") { //Set field value for RefNumberList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.RefNumberList.Add("ab"); } if (ORTxnQueryElementType16581 == "RefNumberCaseSensitiveList") { //Set field value for RefNumberCaseSensitiveList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.RefNumberCaseSensitiveList.Add("ab"); } if (ORTxnQueryElementType16581 == "TxnFilter") { //Set field value for MaxReturned JournalEntryQueryRq.ORTxnQuery.TxnFilter.MaxReturned.SetValue(6); string ORDateRangeFilterElementType16582 = "ModifiedDateRangeFilter"; if (ORDateRangeFilterElementType16582 == "ModifiedDateRangeFilter") { //Set field value for FromModifiedDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToModifiedDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORDateRangeFilterElementType16582 == "TxnDateRangeFilter") { string ORTxnDateRangeFilterElementType16583 = "TxnDateFilter"; if (ORTxnDateRangeFilterElementType16583 == "TxnDateFilter") { //Set field value for FromTxnDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for ToTxnDate JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")); } if (ORTxnDateRangeFilterElementType16583 == "DateMacro") { //Set field value for DateMacro JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll); } } string OREntityFilterElementType16584 = "ListIDList"; if (OREntityFilterElementType16584 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDList.Add("200000-1011023419"); } if (OREntityFilterElementType16584 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameList.Add("ab"); } if (OREntityFilterElementType16584 == "ListIDWithChildren") { //Set field value for ListIDWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.ListIDWithChildren.SetValue("200000-1011023419"); } if (OREntityFilterElementType16584 == "FullNameWithChildren") { //Set field value for FullNameWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.EntityFilter.OREntityFilter.FullNameWithChildren.SetValue("ab"); } string ORAccountFilterElementType16585 = "ListIDList"; if (ORAccountFilterElementType16585 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDList.Add("200000-1011023419"); } if (ORAccountFilterElementType16585 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameList.Add("ab"); } if (ORAccountFilterElementType16585 == "ListIDWithChildren") { //Set field value for ListIDWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.ListIDWithChildren.SetValue("200000-1011023419"); } if (ORAccountFilterElementType16585 == "FullNameWithChildren") { //Set field value for FullNameWithChildren JournalEntryQueryRq.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameWithChildren.SetValue("ab"); } string ORRefNumberFilterElementType16586 = "RefNumberFilter"; if (ORRefNumberFilterElementType16586 == "RefNumberFilter") { //Set field value for MatchCriterion JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcStartsWith); //Set field value for RefNumber JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue("ab"); } if (ORRefNumberFilterElementType16586 == "RefNumberRangeFilter") { //Set field value for FromRefNumber JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.FromRefNumber.SetValue("ab"); //Set field value for ToRefNumber JournalEntryQueryRq.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberRangeFilter.ToRefNumber.SetValue("ab"); } string ORCurrencyFilterElementType16587 = "ListIDList"; if (ORCurrencyFilterElementType16587 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.ListIDList.Add("200000-1011023419"); } if (ORCurrencyFilterElementType16587 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed JournalEntryQueryRq.ORTxnQuery.TxnFilter.CurrencyFilter.ORCurrencyFilter.FullNameList.Add("ab"); } } //Set field value for IncludeLineItems JournalEntryQueryRq.IncludeLineItems.SetValue(true); //Set field value for IncludeRetElementList //May create more than one of these if needed JournalEntryQueryRq.IncludeRetElementList.Add("ab"); //Set field value for OwnerIDList //May create more than one of these if needed JournalEntryQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString()); } void WalkJournalEntryQueryRs(IMsgSetResponse responseMsgSet) { if (responseMsgSet == null) return; IResponseList responseList = responseMsgSet.ResponseList; if (responseList == null) return; //if we sent only one request, there is only one response, we'll walk the list for this sample for(int i=0; i < responseList.Count; i++) { IResponse response = responseList.GetAt(i); //check the status code of the response, 0=ok, >0 is warning if (response.StatusCode >= 0) { //the request-specific response is in the details, make sure we have some if (response.Detail != null) { //make sure the response is the type we're expecting ENResponseType responseType = (ENResponseType)response.Type.GetValue(); if (responseType == ENResponseType.rtJournalEntryQueryRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IJournalEntryRetList JournalEntryRet = (IJournalEntryRetList)response.Detail; WalkJournalEntryRet(JournalEntryRet); } } } } } void WalkJournalEntryRet(IJournalEntryRetList JournalEntryRet) { if (JournalEntryRet == null) return; //Go through all the elements of IJournalEntryRetList //Get value of TxnID string TxnID16588 = (string)JournalEntryRet.TxnID.GetValue(); //Get value of TimeCreated DateTime TimeCreated16589 = (DateTime)JournalEntryRet.TimeCreated.GetValue(); //Get value of TimeModified DateTime TimeModified16590 = (DateTime)JournalEntryRet.TimeModified.GetValue(); //Get value of EditSequence string EditSequence16591 = (string)JournalEntryRet.EditSequence.GetValue(); //Get value of TxnNumber if (JournalEntryRet.TxnNumber != null) { int TxnNumber16592 = (int)JournalEntryRet.TxnNumber.GetValue(); } //Get value of TxnDate DateTime TxnDate16593 = (DateTime)JournalEntryRet.TxnDate.GetValue(); //Get value of RefNumber if (JournalEntryRet.RefNumber != null) { string RefNumber16594 = (string)JournalEntryRet.RefNumber.GetValue(); } //Get value of IsAdjustment if (JournalEntryRet.IsAdjustment != null) { bool IsAdjustment16595 = (bool)JournalEntryRet.IsAdjustment.GetValue(); } //Get value of IsHomeCurrencyAdjustment if (JournalEntryRet.IsHomeCurrencyAdjustment != null) { bool IsHomeCurrencyAdjustment16596 = (bool)JournalEntryRet.IsHomeCurrencyAdjustment.GetValue(); } //Get value of IsAmountsEnteredInHomeCurrency if (JournalEntryRet.IsAmountsEnteredInHomeCurrency != null) { bool IsAmountsEnteredInHomeCurrency16597 = (bool)JournalEntryRet.IsAmountsEnteredInHomeCurrency.GetValue(); } if (JournalEntryRet.CurrencyRef != null) { //Get value of ListID if (JournalEntryRet.CurrencyRef.ListID != null) { string ListID16598 = (string)JournalEntryRet.CurrencyRef.ListID.GetValue(); } //Get value of FullName if (JournalEntryRet.CurrencyRef.FullName != null) { string FullName16599 = (string)JournalEntryRet.CurrencyRef.FullName.GetValue(); } } //Get value of ExchangeRate if (JournalEntryRet.ExchangeRate != null) { IQBFloatType ExchangeRate16600 = (IQBFloatType)JournalEntryRet.ExchangeRate.GetValue(); } //Get value of ExternalGUID if (JournalEntryRet.ExternalGUID != null) { string ExternalGUID16601 = (string)JournalEntryRet.ExternalGUID.GetValue(); } if (JournalEntryRet.ORJournalLineList != null) { for (int i16602 = 0; i16602 < JournalEntryRet.ORJournalLineList.Count; i16602++) { IORJournalLine ORJournalLine16603 = JournalEntryRet.ORJournalLineList.GetAt(i16602); if (ORJournalLine16603.JournalDebitLine != null) { if (ORJournalLine16603.JournalDebitLine != null) { //Get value of TxnLineID if (ORJournalLine16603.JournalDebitLine.TxnLineID != null) { string TxnLineID16604 = (string)ORJournalLine16603.JournalDebitLine.TxnLineID.GetValue(); } if (ORJournalLine16603.JournalDebitLine.AccountRef != null) { //Get value of ListID if (ORJournalLine16603.JournalDebitLine.AccountRef.ListID != null) { string ListID16605 = (string)ORJournalLine16603.JournalDebitLine.AccountRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalDebitLine.AccountRef.FullName != null) { string FullName16606 = (string)ORJournalLine16603.JournalDebitLine.AccountRef.FullName.GetValue(); } } //Get value of Amount if (ORJournalLine16603.JournalDebitLine.Amount != null) { double Amount16607 = (double)ORJournalLine16603.JournalDebitLine.Amount.GetValue(); } //Get value of Memo if (ORJournalLine16603.JournalDebitLine.Memo != null) { string Memo16608 = (string)ORJournalLine16603.JournalDebitLine.Memo.GetValue(); } if (ORJournalLine16603.JournalDebitLine.EntityRef != null) { //Get value of ListID if (ORJournalLine16603.JournalDebitLine.EntityRef.ListID != null) { string ListID16609 = (string)ORJournalLine16603.JournalDebitLine.EntityRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalDebitLine.EntityRef.FullName != null) { string FullName16610 = (string)ORJournalLine16603.JournalDebitLine.EntityRef.FullName.GetValue(); } } if (ORJournalLine16603.JournalDebitLine.ClassRef != null) { //Get value of ListID if (ORJournalLine16603.JournalDebitLine.ClassRef.ListID != null) { string ListID16611 = (string)ORJournalLine16603.JournalDebitLine.ClassRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalDebitLine.ClassRef.FullName != null) { string FullName16612 = (string)ORJournalLine16603.JournalDebitLine.ClassRef.FullName.GetValue(); } } if (ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef != null) { //Get value of ListID if (ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.ListID != null) { string ListID16613 = (string)ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.FullName != null) { string FullName16614 = (string)ORJournalLine16603.JournalDebitLine.ItemSalesTaxRef.FullName.GetValue(); } } //Get value of BillableStatus if (ORJournalLine16603.JournalDebitLine.BillableStatus != null) { ENBillableStatus BillableStatus16615 = (ENBillableStatus)ORJournalLine16603.JournalDebitLine.BillableStatus.GetValue(); } } } if (ORJournalLine16603.JournalCreditLine != null) { if (ORJournalLine16603.JournalCreditLine != null) { //Get value of TxnLineID if (ORJournalLine16603.JournalCreditLine.TxnLineID != null) { string TxnLineID16616 = (string)ORJournalLine16603.JournalCreditLine.TxnLineID.GetValue(); } if (ORJournalLine16603.JournalCreditLine.AccountRef != null) { //Get value of ListID if (ORJournalLine16603.JournalCreditLine.AccountRef.ListID != null) { string ListID16617 = (string)ORJournalLine16603.JournalCreditLine.AccountRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalCreditLine.AccountRef.FullName != null) { string FullName16618 = (string)ORJournalLine16603.JournalCreditLine.AccountRef.FullName.GetValue(); } } //Get value of Amount if (ORJournalLine16603.JournalCreditLine.Amount != null) { double Amount16619 = (double)ORJournalLine16603.JournalCreditLine.Amount.GetValue(); } //Get value of Memo if (ORJournalLine16603.JournalCreditLine.Memo != null) { string Memo16620 = (string)ORJournalLine16603.JournalCreditLine.Memo.GetValue(); } if (ORJournalLine16603.JournalCreditLine.EntityRef != null) { //Get value of ListID if (ORJournalLine16603.JournalCreditLine.EntityRef.ListID != null) { string ListID16621 = (string)ORJournalLine16603.JournalCreditLine.EntityRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalCreditLine.EntityRef.FullName != null) { string FullName16622 = (string)ORJournalLine16603.JournalCreditLine.EntityRef.FullName.GetValue(); } } if (ORJournalLine16603.JournalCreditLine.ClassRef != null) { //Get value of ListID if (ORJournalLine16603.JournalCreditLine.ClassRef.ListID != null) { string ListID16623 = (string)ORJournalLine16603.JournalCreditLine.ClassRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalCreditLine.ClassRef.FullName != null) { string FullName16624 = (string)ORJournalLine16603.JournalCreditLine.ClassRef.FullName.GetValue(); } } if (ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef != null) { //Get value of ListID if (ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.ListID != null) { string ListID16625 = (string)ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.FullName != null) { string FullName16626 = (string)ORJournalLine16603.JournalCreditLine.ItemSalesTaxRef.FullName.GetValue(); } } //Get value of BillableStatus if (ORJournalLine16603.JournalCreditLine.BillableStatus != null) { ENBillableStatus BillableStatus16627 = (ENBillableStatus)ORJournalLine16603.JournalCreditLine.BillableStatus.GetValue(); } } } } } if (JournalEntryRet.DataExtRetList != null) { for (int i16628 = 0; i16628 < JournalEntryRet.DataExtRetList.Count; i16628++) { IDataExtRet DataExtRet = JournalEntryRet.DataExtRetList.GetAt(i16628); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID16629 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName16630 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType16631 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue16632 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } |