JournalEntryAdd
In versions 1.0 and 1.1, all debit lines in a JournalEntryAdd request had to appear first, followed by all credit lines. But in versions 2.0 and above, the debit and credit lines can be intermingled. A credit line can legally come first in thejournal entry add. 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. If the transaction is a home currency adjustment, QuickBooks will ignore the IsAmountsEnteredInHomeCurrency, CurrencyRef, and ExchangeRate elements.
Request
Response
XMLOps
VB.NET
C#
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
IJournalEntryAdd
In versions 1.0 and 1.1, all debit lines in a JournalEntryAdd request had to appear first, followed by all credit lines. But in versions 2.0 and above, the debit and credit lines can be intermingled. A credit line can legally come first in thejournal entry add. 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. If the transaction is a home currency adjustment, QuickBooks will ignore the IsAmountsEnteredInHomeCurrency, CurrencyRef, and ExchangeRate elements.
|
||||
defMacro
Note that defMacro was introduced with SDK 2.0, so it only works with 2.0 and higher requests. You can use the defMacro attribute to assign a name to the TxnID or TxnListID that this aggregate will return. This way you can refer to the transaction by name in a later request. For example, if you were using the qbXML API and you defined an invoice add request with the name TxnID:RecvPmt1234, as shown below, then you could refer to that invoice by name in a later receive payment add request: … … …If you use macros with QBOE… There may be a bug in the QBOE implementation of this feature. If this feature is not working for you in QBOE, try stripping the prefix “TxnID:” from the name of the useMacro. For example, defMacro=”TxnID:RecvPmt1234” and useMacro=”RecvPmt1234”
|
IQBStringType | 2.0 | ||
TxnDate
The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
|
IQBDateType | |||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | 11 chars | ||
IsAdjustment
When a change is an “adjustment,” the original information is retained, usually so an accountant can see the effects of the adjustment.
|
IQBBoolType | 3.0 | ||
ORHomeCurrencyAdjustment |
IORHomeCurrencyAdjustment | 8.0 | ||
IsHomeCurrencyAdjustment
Indicates whether the transaction is using a home currency or foreign currency.
|
IQBBoolType | 8.0 | ||
CurrencyExchangeRate
The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency. The exchange rate should be considered a snapshot of the rates in effect at the AsOfDate. You can update the exchange rate using the exchange rate property when you add a transaction. However, you need to obtain and supply the exchange rate. If you are using USD (United States Dollars) as the home currency and are connected to the Internet, you can download the current exchange rates for all active currencies automatically in the QuickBooks UI by selecting Lists->Currency->Activities->Download latest exchange rates. (Currently, you can’t do this in the SDK.)
|
ICurrencyExchangeRate | |||
IsAmountsEnteredInHomeCurrency
Flag that indicates the amount being entered is in the home currency.
|
IQBBoolType | 8.0 | ||
CurrencyRef
The currency object contains all of the information needed by QuickBooks to display and use. For built-in currencies, the name and currency code values are internationally accepted values and thus are not editable. The comma format is editable, as is the IsActive status. For user-defined currencies, every value in the object is editable including name and currency code. When used with PriceLevels, the CurrencyRef should only be used with “per item” price levels.
|
IQBBaseRef | 8.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 8.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 64 chars | 8.0 | |
ExchangeRate
The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency. The exchange rate should be considered a snapshot of the rates in effect at the AsOfDate. You can update the exchange rate using the exchange rate property when you add a transaction. However, you need to obtain and supply the exchange rate. If you are using USD (United States Dollars) as the home currency and are connected to the Internet, you can download the current exchange rates for all active currencies automatically in the QuickBooks UI by selecting Lists->Currency->Activities->Download latest exchange rates. (Currently, you can’t do this in the SDK.)
|
IQBFloatType | 8.0 | ||
ExternalGUID
Allows for the attachment of a user defined GUID value.
|
IQBGUIDType | 9.0 | ||
ORJournalLineList |
IORJournalLineList | Y | ||
(List
of IORJournalLine Objects)
|
||||
JournalDebitLine
If no amount is included in the first debit line (or credit line) of a journal entry in the QuickBooks user interface, then subsequent SDK queries on that JournalEntry object will fail XML validation.
|
IJournalDebitLine | |||
defMacro
Note that defMacro was introduced with SDK 2.0, so it only works with 2.0 and higher requests. You can use the defMacro attribute to assign a name to the TxnID or TxnListID that this aggregate will return. This way you can refer to the transaction by name in a later request. For example, if you were using the qbXML API and you defined an invoice add request with the name TxnID:RecvPmt1234, as shown below, then you could refer to that invoice by name in a later receive payment add request: … … …If you use macros with QBOE… There may be a bug in the QBOE implementation of this feature. If this feature is not working for you in QBOE, try stripping the prefix “TxnID:” from the name of the useMacro. For example, defMacro=”TxnID:RecvPmt1234” and useMacro=”RecvPmt1234”
|
IQBStringType | 2.0 | ||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | |||
AccountRef
The Account list is the company file’s list of accounts. An AccountRef aggregate refers to one of these accounts. (If an AccountRef aggregate includes both FullName and ListID, FullName will be ignored.) Special cases to note:In a Check message, AccountRef refers to the account from which the funds are being drawn for this check, for example, Checking or Savings.In an ExpenseLineAdd message, you must include AccountRef if the “Require accounts” check box is selected in the QuickBooks Accounting preferences. (It is selected by default.) In a CreditCardCredit message, AccountRef refers to the bank account or credit card account to which the credit is applied.In a CreditCardCharge message, AccountRef refers to the bank or credit card company to whom money is owed. How do you increase and decrease amounts in bank accounts? The following requests increase the balance in a bank account: Deposit Add ReceivePaymentAdd Journal Entry Add Sales ReceiptAdd The following requests decrease the balance in a bank account: CheckAdd Bill PaymentCheckAdd JournalEntryAdd
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
Amount
A monetary amount.
|
IQBAmountType | |||
Memo
Additional information.
|
IQBStringType | 4095 chars | ||
EntityRef
A QuickBooks “entity” is a customer, vendor, employee, or person on the QuickBooks “other names” list. Special cases to note: In a BillToPayQuery message, EntityRef refers to the vendor name.In JournalCreditLine and JournalDebitLine messages for A/R accounts, EntityRef must refer to a customer, or else the transaction will not be recorded. For A/P accounts the EntityRef must refer to a vendor, or else the transaction will not be recorded.In a TimeTracking message, EntityRef cannot refer to a customer, only to an employee, vendor, or person on the “other names” list whose time is being tracked.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
ItemSalesTaxRef
A sales-tax item is used to calculate a single sales tax that is collected at a specified rate and paid to a single agency. (Compare with the ItemSalesTaxGroupAdd message.) An ItemSalesTaxRef aggregate refers to an item on this list. In a request, if an ItemSalesTaxRef aggregate includes both FullName and ListID, FullName will be ignored. Taxes can be reflected in transaction line items The following information refers to invoices specifically, but it also applies to sales receipts. Generally its best to assign a tax item or tax group item to an invoice and allow QuickBooks to apply the same tax to all taxable items on the invoice. However in some situations multiple tax combinations are required, so this method doesn’t work. In this case one must use techniques to apply the taxes in the invoice itself as line items. Using lines to apply taxes isn’t always straight forward. When applying taxes as line items, only single tax items can be used, tax groups can only be used for the entire invoice. If you have multiple taxes which apply to all taxable items, and one or more other taxes that only apply to some of the items on an invoice its better to use a tax group which applies to the entire invoice for the taxes which applies to all taxable items and then apply the other taxes in the invoice itself. One applies a tax or tax group to an entire invoice by using the ItemSalesTaxRef aggregate. One can use subtotals to apply a single tax line to multiple items in an invoice, but the tax is only applied automatically for the first tax line after the subtotal line. Any other tax lines which need to be applied to the subtotal line must supply their own amount. If you don’t supply an amount the amount comes out as zero and the tax line is useless. When one does supply an amount, the amount of tax on the subtotal also shows up in the rate column for that tax line. There isn’t any way for the rate to show up as anything other than the amount of the tax. If you have a complicated tax situation where no single tax applies to all taxable items on the invoice, you must choose a zero percent tax to apply for the entire invoice. It is recommended to name such a tax item “Tax Calculated On Invoice” so that it’s clear that the tax is not being applied by QuickBooks on the entire invoice.
|
IQBBaseRef | 6.0   |
||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 6.0 |
||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 6.0 |
|
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 3.0 | ||
JournalCreditLine
If no amount is included in the first credit line (or debit line) of a journal entry in the QuickBooks user interface, then subsequent SDK queries on that JournalEntry object will fail XML validation.
|
IJournalCreditLine | |||
defMacro
Note that defMacro was introduced with SDK 2.0, so it only works with 2.0 and higher requests. You can use the defMacro attribute to assign a name to the TxnID or TxnListID that this aggregate will return. This way you can refer to the transaction by name in a later request. For example, if you were using the qbXML API and you defined an invoice add request with the name TxnID:RecvPmt1234, as shown below, then you could refer to that invoice by name in a later receive payment add request: … … …If you use macros with QBOE… There may be a bug in the QBOE implementation of this feature. If this feature is not working for you in QBOE, try stripping the prefix “TxnID:” from the name of the useMacro. For example, defMacro=”TxnID:RecvPmt1234” and useMacro=”RecvPmt1234”
|
IQBStringType | 2.0 | ||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | |||
AccountRef
The Account list is the company file’s list of accounts. An AccountRef aggregate refers to one of these accounts. (If an AccountRef aggregate includes both FullName and ListID, FullName will be ignored.) Special cases to note:In a Check message, AccountRef refers to the account from which the funds are being drawn for this check, for example, Checking or Savings.In an ExpenseLineAdd message, you must include AccountRef if the “Require accounts” check box is selected in the QuickBooks Accounting preferences. (It is selected by default.) In a CreditCardCredit message, AccountRef refers to the bank account or credit card account to which the credit is applied.In a CreditCardCharge message, AccountRef refers to the bank or credit card company to whom money is owed. How do you increase and decrease amounts in bank accounts? The following requests increase the balance in a bank account: Deposit Add ReceivePaymentAdd Journal Entry Add Sales ReceiptAdd The following requests decrease the balance in a bank account: CheckAdd Bill PaymentCheckAdd JournalEntryAdd
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
Amount
A monetary amount.
|
IQBAmountType | |||
Memo
Additional information.
|
IQBStringType | 4095 chars | ||
EntityRef
A QuickBooks “entity” is a customer, vendor, employee, or person on the QuickBooks “other names” list. Special cases to note: In a BillToPayQuery message, EntityRef refers to the vendor name.In JournalCreditLine and JournalDebitLine messages for A/R accounts, EntityRef must refer to a customer, or else the transaction will not be recorded. For A/P accounts the EntityRef must refer to a vendor, or else the transaction will not be recorded.In a TimeTracking message, EntityRef cannot refer to a customer, only to an employee, vendor, or person on the “other names” list whose time is being tracked.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
ItemSalesTaxRef
A sales-tax item is used to calculate a single sales tax that is collected at a specified rate and paid to a single agency. (Compare with the ItemSalesTaxGroupAdd message.) An ItemSalesTaxRef aggregate refers to an item on this list. In a request, if an ItemSalesTaxRef aggregate includes both FullName and ListID, FullName will be ignored. Taxes can be reflected in transaction line items The following information refers to invoices specifically, but it also applies to sales receipts. Generally its best to assign a tax item or tax group item to an invoice and allow QuickBooks to apply the same tax to all taxable items on the invoice. However in some situations multiple tax combinations are required, so this method doesn’t work. In this case one must use techniques to apply the taxes in the invoice itself as line items. Using lines to apply taxes isn’t always straight forward. When applying taxes as line items, only single tax items can be used, tax groups can only be used for the entire invoice. If you have multiple taxes which apply to all taxable items, and one or more other taxes that only apply to some of the items on an invoice its better to use a tax group which applies to the entire invoice for the taxes which applies to all taxable items and then apply the other taxes in the invoice itself. One applies a tax or tax group to an entire invoice by using the ItemSalesTaxRef aggregate. One can use subtotals to apply a single tax line to multiple items in an invoice, but the tax is only applied automatically for the first tax line after the subtotal line. Any other tax lines which need to be applied to the subtotal line must supply their own amount. If you don’t supply an amount the amount comes out as zero and the tax line is useless. When one does supply an amount, the amount of tax on the subtotal also shows up in the rate column for that tax line. There isn’t any way for the rate to show up as anything other than the amount of the tax. If you have a complicated tax situation where no single tax applies to all taxable items on the invoice, you must choose a zero percent tax to apply for the entire invoice. It is recommended to name such a tax item “Tax Calculated On Invoice” so that it’s clear that the tax is not being applied by QuickBooks on the entire invoice.
|
IQBBaseRef | 6.0 |
||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 6.0 |
||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 6.0 |
|
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 3.0 | ||
IncludeRetElementList
You use this if you want to limit the data that will be returned in the response. In this list, you specify the name of each top-level element or aggregate that you want to be returned in the response to the request. You cannot specify fields within an aggregate, for example, you cannot specify a City within an Address: you must specify Address and will get the entire address. The names specified in the list are not parsed, so you must be especially careful to supply valid names, properly cased. No error is returned in the status code if you specify an invalid name. Notice that if you want to return custom data or private data extensions, you must specify the DataExtRet element and you must supply the OwnerID set to either a value of 0 (custom data) or the GUID for the private data.
|
IBSTRList | 50 chars | 4.0 |
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
IResponse
In versions 1.0 and 1.1, all debit lines in a JournalEntryAdd request had to appear first, followed by all credit lines. But in versions 2.0 and above, the debit and credit lines can be intermingled. A credit line can legally come first in thejournal entry add. 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. If the transaction is a home currency adjustment, QuickBooks will ignore the IsAmountsEnteredInHomeCurrency, CurrencyRef, and ExchangeRate elements.
|
||||
StatusCode
A number that corresponds to a statusSeverity and statusMessage. Five status codes relate directly to signon messages: 2000, 2010, 2020, 2030, and 2040. For details about these and other statusCode values that can be returned, see the statusCode table on the Error Codes page.
|
IQBIntType | Y | ||
StatusSeverity
One of the following values: INFO The request was completed, and the results are consistent with what your application expected. WARNING The request was completed, but the results might not be consistent with what you expected. ERROR The request was not completed. No data will appear in the server’s response after the statusMessage.
|
IQBStringType | Y | ||
StatusMessage
A user-readable explanation of the success or error condition that is indicated by the statusCode. For details about the statusMessage values that can be returned, see the “Explanation” column of the statusCode table on the Error Codes page.
|
IQBStringType | Y | ||
Detail |
IJournalEntryRet | |||
TxnID
QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IQBIDType | Y | ||
TimeCreated
Time the object was created.
|
IQBDateTimeType | Y | ||
TimeModified
Time the object was last modified.
|
IQBDateTimeType | Y | ||
EditSequence
A number that the server generates and assigns to this object. Every time the object is changed, the server will change its EditSequence value. When you try to modify a list object, you must provide its EditSequence. The server compares the EditSequence you provide with the EditSequence in memory to make sure you are dealing with the latest copy of the object. If you are not, the server will reject the request and return an error. Because EditSequence is only used to check whether two objects match, there is no reason to interpret its value.
|
IQBStringType | 16 chars | Y | |
TxnNumber
An identifying number for this transaction.
|
IQBIntType | |||
TxnDate
The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
|
IQBDateType | Y | ||
RefNumber
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user. In a BillPaymentCheckAdd request, if you want to set the check number, use RefNumber.Note (especially relevant to CheckAdd requests): When RefNumber is left blank in an SDK transaction add request (that is, or ), the RefNumber will be left blank in QuickBooks. This behavior is new as of QBFC3. It used to select the next sequential reference number since the last one used by QuickBooks, as though no RefNumber had been provided. This is especially relevant to CheckAdd requests because with the current behavior, you will not know the number until the check is printed.
|
IQBStringType | 11 chars | ||
IsAdjustment
When a change is an “adjustment,” the original information is retained, usually so an accountant can see the effects of the adjustment.
|
IQBBoolType | 3.0 | ||
IsHomeCurrencyAdjustment
Indicates whether the transaction is using a home currency or foreign currency.
|
IQBBoolType | 8.0 | ||
IsAmountsEnteredInHomeCurrency
Flag that indicates the amount being entered is in the home currency.
|
IQBBoolType | 8.0 | ||
CurrencyRef
The currency object contains all of the information needed by QuickBooks to display and use. For built-in currencies, the name and currency code values are internationally accepted values and thus are not editable. The comma format is editable, as is the IsActive status. For user-defined currencies, every value in the object is editable including name and currency code. When used with PriceLevels, the CurrencyRef should only be used with “per item” price levels.
|
IQBBaseRef | 8.0 | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 8.0 | ||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 64 chars | 8.0 | |
ExchangeRate
The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency. The exchange rate should be considered a snapshot of the rates in effect at the AsOfDate. You can update the exchange rate using the exchange rate property when you add a transaction. However, you need to obtain and supply the exchange rate. If you are using USD (United States Dollars) as the home currency and are connected to the Internet, you can download the current exchange rates for all active currencies automatically in the QuickBooks UI by selecting Lists->Currency->Activities->Download latest exchange rates. (Currently, you can’t do this in the SDK.)
|
IQBFloatType | 8.0 | ||
ExternalGUID
Allows for the attachment of a user defined GUID value.
|
IQBGUIDType | 9.0 | ||
ORJournalLineList |
IORJournalLineList | |||
(List
of IORJournalLine Objects)
|
||||
JournalDebitLine
If no amount is included in the first debit line (or credit line) of a journal entry in the QuickBooks user interface, then subsequent SDK queries on that JournalEntry object will fail XML validation.
|
IJournalDebitLine | |||
defMacro
Note that defMacro was introduced with SDK 2.0, so it only works with 2.0 and higher requests. You can use the defMacro attribute to assign a name to the TxnID or TxnListID that this aggregate will return. This way you can refer to the transaction by name in a later request. For example, if you were using the qbXML API and you defined an invoice add request with the name TxnID:RecvPmt1234, as shown below, then you could refer to that invoice by name in a later receive payment add request: … … …If you use macros with QBOE… There may be a bug in the QBOE implementation of this feature. If this feature is not working for you in QBOE, try stripping the prefix “TxnID:” from the name of the useMacro. For example, defMacro=”TxnID:RecvPmt1234” and useMacro=”RecvPmt1234”
|
IQBStringType | 2.0 | ||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | |||
AccountRef
The Account list is the company file’s list of accounts. An AccountRef aggregate refers to one of these accounts. (If an AccountRef aggregate includes both FullName and ListID, FullName will be ignored.) Special cases to note:In a Check message, AccountRef refers to the account from which the funds are being drawn for this check, for example, Checking or Savings.In an ExpenseLineAdd message, you must include AccountRef if the “Require accounts” check box is selected in the QuickBooks Accounting preferences. (It is selected by default.) In a CreditCardCredit message, AccountRef refers to the bank account or credit card account to which the credit is applied.In a CreditCardCharge message, AccountRef refers to the bank or credit card company to whom money is owed. How do you increase and decrease amounts in bank accounts? The following requests increase the balance in a bank account: Deposit Add ReceivePaymentAdd Journal Entry Add Sales ReceiptAdd The following requests decrease the balance in a bank account: CheckAdd Bill PaymentCheckAdd JournalEntryAdd
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
Amount
A monetary amount.
|
IQBAmountType | |||
Memo
Additional information.
|
IQBStringType | 4095 chars | ||
EntityRef
A QuickBooks “entity” is a customer, vendor, employee, or person on the QuickBooks “other names” list. Special cases to note: In a BillToPayQuery message, EntityRef refers to the vendor name.In JournalCreditLine and JournalDebitLine messages for A/R accounts, EntityRef must refer to a customer, or else the transaction will not be recorded. For A/P accounts the EntityRef must refer to a vendor, or else the transaction will not be recorded.In a TimeTracking message, EntityRef cannot refer to a customer, only to an employee, vendor, or person on the “other names” list whose time is being tracked.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
ItemSalesTaxRef
A sales-tax item is used to calculate a single sales tax that is collected at a specified rate and paid to a single agency. (Compare with the ItemSalesTaxGroupAdd message.) An ItemSalesTaxRef aggregate refers to an item on this list. In a request, if an ItemSalesTaxRef aggregate includes both FullName and ListID, FullName will be ignored. Taxes can be reflected in transaction line items The following information refers to invoices specifically, but it also applies to sales receipts. Generally its best to assign a tax item or tax group item to an invoice and allow QuickBooks to apply the same tax to all taxable items on the invoice. However in some situations multiple tax combinations are required, so this method doesn’t work. In this case one must use techniques to apply the taxes in the invoice itself as line items. Using lines to apply taxes isn’t always straight forward. When applying taxes as line items, only single tax items can be used, tax groups can only be used for the entire invoice. If you have multiple taxes which apply to all taxable items, and one or more other taxes that only apply to some of the items on an invoice its better to use a tax group which applies to the entire invoice for the taxes which applies to all taxable items and then apply the other taxes in the invoice itself. One applies a tax or tax group to an entire invoice by using the ItemSalesTaxRef aggregate. One can use subtotals to apply a single tax line to multiple items in an invoice, but the tax is only applied automatically for the first tax line after the subtotal line. Any other tax lines which need to be applied to the subtotal line must supply their own amount. If you don’t supply an amount the amount comes out as zero and the tax line is useless. When one does supply an amount, the amount of tax on the subtotal also shows up in the rate column for that tax line. There isn’t any way for the rate to show up as anything other than the amount of the tax. If you have a complicated tax situation where no single tax applies to all taxable items on the invoice, you must choose a zero percent tax to apply for the entire invoice. It is recommended to name such a tax item “Tax Calculated On Invoice” so that it’s clear that the tax is not being applied by QuickBooks on the entire invoice.
|
IQBBaseRef | 6.0 |
||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 6.0 |
||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 6.0 |
|
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 3.0 | ||
JournalCreditLine
If no amount is included in the first credit line (or debit line) of a journal entry in the QuickBooks user interface, then subsequent SDK queries on that JournalEntry object will fail XML validation.
|
IJournalCreditLine | |||
defMacro
Note that defMacro was introduced with SDK 2.0, so it only works with 2.0 and higher requests. You can use the defMacro attribute to assign a name to the TxnID or TxnListID that this aggregate will return. This way you can refer to the transaction by name in a later request. For example, if you were using the qbXML API and you defined an invoice add request with the name TxnID:RecvPmt1234, as shown below, then you could refer to that invoice by name in a later receive payment add request: … … …If you use macros with QBOE… There may be a bug in the QBOE implementation of this feature. If this feature is not working for you in QBOE, try stripping the prefix “TxnID:” from the name of the useMacro. For example, defMacro=”TxnID:RecvPmt1234” and useMacro=”RecvPmt1234”
|
IQBStringType | 2.0 | ||
TxnLineID
Identification number of the transaction line. (TxnLineID is supported as of v2.0 of the SDK. With qbXML v1.0 and v1.1, TxnLineID is always returned as zero.) If you need to add a new transaction line in a transaction Mod request, you can do so by setting the TxnLineID to -1.
|
IQBIDType | |||
AccountRef
The Account list is the company file’s list of accounts. An AccountRef aggregate refers to one of these accounts. (If an AccountRef aggregate includes both FullName and ListID, FullName will be ignored.) Special cases to note:In a Check message, AccountRef refers to the account from which the funds are being drawn for this check, for example, Checking or Savings.In an ExpenseLineAdd message, you must include AccountRef if the “Require accounts” check box is selected in the QuickBooks Accounting preferences. (It is selected by default.) In a CreditCardCredit message, AccountRef refers to the bank account or credit card account to which the credit is applied.In a CreditCardCharge message, AccountRef refers to the bank or credit card company to whom money is owed. How do you increase and decrease amounts in bank accounts? The following requests increase the balance in a bank account: Deposit Add ReceivePaymentAdd Journal Entry Add Sales ReceiptAdd The following requests decrease the balance in a bank account: CheckAdd Bill PaymentCheckAdd JournalEntryAdd
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
Amount
A monetary amount.
|
IQBAmountType | |||
Memo
Additional information.
|
IQBStringType | 4095 chars | ||
EntityRef
A QuickBooks “entity” is a customer, vendor, employee, or person on the QuickBooks “other names” list. Special cases to note: In a BillToPayQuery message, EntityRef refers to the vendor name.In JournalCreditLine and JournalDebitLine messages for A/R accounts, EntityRef must refer to a customer, or else the transaction will not be recorded. For A/P accounts the EntityRef must refer to a vendor, or else the transaction will not be recorded.In a TimeTracking message, EntityRef cannot refer to a customer, only to an employee, vendor, or person on the “other names” list whose time is being tracked.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
ItemSalesTaxRef
A sales-tax item is used to calculate a single sales tax that is collected at a specified rate and paid to a single agency. (Compare with the ItemSalesTaxGroupAdd message.) An ItemSalesTaxRef aggregate refers to an item on this list. In a request, if an ItemSalesTaxRef aggregate includes both FullName and ListID, FullName will be ignored. Taxes can be reflected in transaction line items The following information refers to invoices specifically, but it also applies to sales receipts. Generally its best to assign a tax item or tax group item to an invoice and allow QuickBooks to apply the same tax to all taxable items on the invoice. However in some situations multiple tax combinations are required, so this method doesn’t work. In this case one must use techniques to apply the taxes in the invoice itself as line items. Using lines to apply taxes isn’t always straight forward. When applying taxes as line items, only single tax items can be used, tax groups can only be used for the entire invoice. If you have multiple taxes which apply to all taxable items, and one or more other taxes that only apply to some of the items on an invoice its better to use a tax group which applies to the entire invoice for the taxes which applies to all taxable items and then apply the other taxes in the invoice itself. One applies a tax or tax group to an entire invoice by using the ItemSalesTaxRef aggregate. One can use subtotals to apply a single tax line to multiple items in an invoice, but the tax is only applied automatically for the first tax line after the subtotal line. Any other tax lines which need to be applied to the subtotal line must supply their own amount. If you don’t supply an amount the amount comes out as zero and the tax line is useless. When one does supply an amount, the amount of tax on the subtotal also shows up in the rate column for that tax line. There isn’t any way for the rate to show up as anything other than the amount of the tax. If you have a complicated tax situation where no single tax applies to all taxable items on the invoice, you must choose a zero percent tax to apply for the entire invoice. It is recommended to name such a tax item “Tax Calculated On Invoice” so that it’s clear that the tax is not being applied by QuickBooks on the entire invoice.
|
IQBBaseRef | 6.0 |
||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | 6.0 |
||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | 6.0 |
|
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 3.0 | ||
DataExtRetList
A list of IDataExtRet objects, each of which represents a field that has been added to QuickBooks as a data extension.
|
IDataExtRetList | 2.0 | ||
(List
of IDataExtRet Objects)
|
||||
OwnerID
OwnerID refers to the owner of a data extension, and must be 0 or a valid GUID. (Custom fields, which are visible in the QuickBooks UI, always have an OwnerID of 0. ) Usually you would keep your application’s GUID confidential to prevent other applications from accessing your data extensions. But if you want to share data extensions with another application, the applications need to use the same GUID. In this case, each application could use two GUIDs, one for shared data extensions and one for confidential data extensions. (An application can have any number of GUIDs.) When you share a data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | |||
DataExtName
The name of the data extension. If this is a custom field, DataExtName will be visible as a label in the QuickBooks user interface. Also because OwnerID and DataExtName together make the data extension unique, and because custom fields all have the same OwnerID of zero, the DataExtName must be a unique value among existing custom fields. In contrast, the DataExtName for private data extensions must be unique only for the specified OwnerID GUID.
|
IQBStringType | 31 chars | Y | |
DataExtType
The field’s data type, which corresponds to a qbXML data type. In an IDataExtDefAdd request object, if this is a custom field, DataExtType must be detSTR255TYPE.
|
IQBENDataExtTypeType | Y | ||
DataExtValue
The data in this field. The maximum length of DataExtValue will depend on the DataExtType of this data extension. For example, if DataExtType is STR255TYPE, the maximum length of DataExtValue is 255 characters. If DataExtType is STR1024TYPE, the maximum size of DataExtValue is 1KB.
|
IQBStringType | Y | ||
Detail |
IErrorRecovery | 11.0 | ||
ORListOwnerTxn |
IORListOwnerTxn | Y | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
OwnerID
Refers to the owner of a data extension:If OwnerID is 0, this is a public data extension, also known as a custom field. Custom fields appear in the QuickBooks UI.If OwnerID is a GUID, for example {6B063959-81B0-4622-85D6-F548C8CCB517}, this field is a private data extension defined by an integrated application. Private data extensions do not appear in the QuickBooks UI. Note that OwnerID values are not case-sensitive, meaning that if you enter an OwnerID value with lower-case letters, the value will be saved and returned with upper-case letters. When you share a private data extension with another application, the other application must know both the OwnerID and the DataExtName, as these together form a data extension’s unique name.
|
IQBGUIDType | |||
TxnID
QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IQBIDType | |||
TxnNumber
An identifying number for this transaction.
|
IQBIntType | |||
EditSequence
A number that the server generates and assigns to this object. Every time the object is changed, the server will change its EditSequence value. When you try to modify a list object, you must provide its EditSequence. The server compares the EditSequence you provide with the EditSequence in memory to make sure you are dealing with the latest copy of the object. If you are not, the server will reject the request and return an error. Because EditSequence is only used to check whether two objects match, there is no reason to interpret its value.
|
IQBStringType | 16 chars | ||
ExternalGUID
Allows for the attachment of a user defined GUID value.
|
IQBGUIDType |
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 | <?xml version="1.0" encoding="utf-8"?> <?qbxml version="16.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <JournalEntryAddRq> <JournalEntryAdd defMacro="MACROTYPE"> <!-- required --> <TxnDate >DATETYPE</TxnDate> <!-- optional --> <RefNumber >STRTYPE</RefNumber> <!-- optional --> <IsAdjustment >BOOLTYPE</IsAdjustment> <!-- optional --> <!-- BEGIN OR --> <IsHomeCurrencyAdjustment >BOOLTYPE</IsHomeCurrencyAdjustment> <!-- optional --> <!-- OR --> <IsAmountsEnteredInHomeCurrency >BOOLTYPE</IsAmountsEnteredInHomeCurrency> <!-- optional --> <CurrencyRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CurrencyRef> <ExchangeRate >FLOATTYPE</ExchangeRate> <!-- optional --> <!-- OR --> <!-- END OR --> <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 --> </JournalEntryAdd> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> </JournalEntryAddRq> <JournalEntryAddRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE"> <JournalEntryRet> <!-- optional --> <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> <ErrorRecovery> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional --> <!-- OR --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional --> <!-- OR --> <TxnID >IDTYPE</TxnID> <!-- optional --> <!-- END OR --> <TxnNumber >INTTYPE</TxnNumber> <!-- optional --> <EditSequence >STRTYPE</EditSequence> <!-- optional --> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> </ErrorRecovery> </JournalEntryAddRs> </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 | '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 DoJournalEntryAdd()
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
BuildJournalEntryAddRq(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
WalkJournalEntryAddRs(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 BuildJournalEntryAddRq(requestMsgSet as IMsgSetRequest)
Dim JournalEntryAddRq as IJournalEntryAdd
JournalEntryAddRq= requestMsgSet.AppendJournalEntryAddRq()
'Set field value for TxnDate
JournalEntryAddRq.TxnDate.SetValue(DateTime.Parse("12/15/2007"))
'Set field value for RefNumber
JournalEntryAddRq.RefNumber.SetValue("ab")
'Set field value for IsAdjustment
JournalEntryAddRq.IsAdjustment.SetValue(True)
Dim ORHomeCurrencyAdjustmentElementType16441 as String
ORHomeCurrencyAdjustmentElementType16441 = "IsHomeCurrencyAdjustment"
if (ORHomeCurrencyAdjustmentElementType16441 == "IsHomeCurrencyAdjustment") then
'Set field value for IsHomeCurrencyAdjustment
JournalEntryAddRq.ORHomeCurrencyAdjustment.IsHomeCurrencyAdjustment.SetValue(True)
End If
if (ORHomeCurrencyAdjustmentElementType16441 == "CurrencyExchangeRate") then
'Set field value for IsAmountsEnteredInHomeCurrency
JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.IsAmountsEnteredInHomeCurrency.SetValue(True)
'Set field value for ListID
JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.CurrencyRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.CurrencyRef.FullName.SetValue("ab")
'Set field value for ExchangeRate
JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.ExchangeRate.SetValue("IQBFloatType")
End If
if (ORHomeCurrencyAdjustmentElementType16441 == "") then
End If
'Set field value for ExternalGUID
JournalEntryAddRq.ExternalGUID.SetValue(System.Guid.NewGuid().ToString())
Dim ORJournalLineListElement16442 as IORJournalLine
ORJournalLineListElement16442 =JournalEntryAddRq.ORJournalLineList.Append()
Dim ORJournalLineListElementType16443 as String
ORJournalLineListElementType16443 = "JournalDebitLine"
if (ORJournalLineListElementType16443 == "JournalDebitLine") then
'Set field value for TxnLineID
ORJournalLineListElement16442.JournalDebitLine.TxnLineID.SetValue("200000-1011023419")
'Set field value for ListID
ORJournalLineListElement16442.JournalDebitLine.AccountRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalDebitLine.AccountRef.FullName.SetValue("ab")
'Set field value for Amount
ORJournalLineListElement16442.JournalDebitLine.Amount.SetValue(10.01)
'Set field value for Memo
ORJournalLineListElement16442.JournalDebitLine.Memo.SetValue("ab")
'Set field value for ListID
ORJournalLineListElement16442.JournalDebitLine.EntityRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalDebitLine.EntityRef.FullName.SetValue("ab")
'Set field value for ListID
ORJournalLineListElement16442.JournalDebitLine.ClassRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalDebitLine.ClassRef.FullName.SetValue("ab")
'Set field value for ListID
ORJournalLineListElement16442.JournalDebitLine.ItemSalesTaxRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalDebitLine.ItemSalesTaxRef.FullName.SetValue("ab")
'Set field value for BillableStatus
ORJournalLineListElement16442.JournalDebitLine.BillableStatus.SetValue(ENBillableStatus.bsBillable)
End If
if (ORJournalLineListElementType16443 == "JournalCreditLine") then
'Set field value for TxnLineID
ORJournalLineListElement16442.JournalCreditLine.TxnLineID.SetValue("200000-1011023419")
'Set field value for ListID
ORJournalLineListElement16442.JournalCreditLine.AccountRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalCreditLine.AccountRef.FullName.SetValue("ab")
'Set field value for Amount
ORJournalLineListElement16442.JournalCreditLine.Amount.SetValue(10.01)
'Set field value for Memo
ORJournalLineListElement16442.JournalCreditLine.Memo.SetValue("ab")
'Set field value for ListID
ORJournalLineListElement16442.JournalCreditLine.EntityRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalCreditLine.EntityRef.FullName.SetValue("ab")
'Set field value for ListID
ORJournalLineListElement16442.JournalCreditLine.ClassRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalCreditLine.ClassRef.FullName.SetValue("ab")
'Set field value for ListID
ORJournalLineListElement16442.JournalCreditLine.ItemSalesTaxRef.ListID.SetValue("200000-1011023419")
'Set field value for FullName
ORJournalLineListElement16442.JournalCreditLine.ItemSalesTaxRef.FullName.SetValue("ab")
'Set field value for BillableStatus
ORJournalLineListElement16442.JournalCreditLine.BillableStatus.SetValue(ENBillableStatus.bsBillable)
End If
'Set field value for IncludeRetElementList
'May create more than one of these if needed
JournalEntryAddRq.IncludeRetElementList.Add("ab")
End Sub
Public Sub WalkJournalEntryAddRs( 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.rtJournalEntryAddRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim JournalEntryRet as IJournalEntryRet
JournalEntryRet = CType(response.Detail,IJournalEntryRet)
WalkJournalEntryRet(JournalEntryRet)
End If
End If
End If
Next j
End Sub
Public Sub WalkJournalEntryRet(JournalEntryRet as IJournalEntryRet)
if (JournalEntryRet is nothing) then
Exit Sub
End If
'Go through all the elements of IJournalEntryRet
'Get value of TxnID
Dim TxnID16444 as String
TxnID16444 = JournalEntryRet.TxnID.GetValue()
'Get value of TimeCreated
Dim TimeCreated16445 as DateTime
TimeCreated16445 = JournalEntryRet.TimeCreated.GetValue()
'Get value of TimeModified
Dim TimeModified16446 as DateTime
TimeModified16446 = JournalEntryRet.TimeModified.GetValue()
'Get value of EditSequence
Dim EditSequence16447 as String
EditSequence16447 = JournalEntryRet.EditSequence.GetValue()
'Get value of TxnNumber
if ( not JournalEntryRet.TxnNumber is nothing) then
Dim TxnNumber16448 as Integer
TxnNumber16448 = JournalEntryRet.TxnNumber.GetValue()
End If
'Get value of TxnDate
Dim TxnDate16449 as DateTime
TxnDate16449 = JournalEntryRet.TxnDate.GetValue()
'Get value of RefNumber
if ( not JournalEntryRet.RefNumber is nothing) then
Dim RefNumber16450 as String
RefNumber16450 = JournalEntryRet.RefNumber.GetValue()
End If
'Get value of IsAdjustment
if ( not JournalEntryRet.IsAdjustment is nothing) then
Dim IsAdjustment16451 as Boolean
IsAdjustment16451 = JournalEntryRet.IsAdjustment.GetValue()
End If
'Get value of IsHomeCurrencyAdjustment
if ( not JournalEntryRet.IsHomeCurrencyAdjustment is nothing) then
Dim IsHomeCurrencyAdjustment16452 as Boolean
IsHomeCurrencyAdjustment16452 = JournalEntryRet.IsHomeCurrencyAdjustment.GetValue()
End If
'Get value of IsAmountsEnteredInHomeCurrency
if ( not JournalEntryRet.IsAmountsEnteredInHomeCurrency is nothing) then
Dim IsAmountsEnteredInHomeCurrency16453 as Boolean
IsAmountsEnteredInHomeCurrency16453 = 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 ListID16454 as String
ListID16454 = JournalEntryRet.CurrencyRef.ListID.GetValue()
End If
'Get value of FullName
if ( not JournalEntryRet.CurrencyRef.FullName is nothing) then
Dim FullName16455 as String
FullName16455 = JournalEntryRet.CurrencyRef.FullName.GetValue()
End If
End If
'Get value of ExchangeRate
if ( not JournalEntryRet.ExchangeRate is nothing) then
Dim ExchangeRate16456 as IQBFloatType
ExchangeRate16456 = JournalEntryRet.ExchangeRate.GetValue()
End If
'Get value of ExternalGUID
if ( not JournalEntryRet.ExternalGUID is nothing) then
Dim ExternalGUID16457 as String
ExternalGUID16457 = JournalEntryRet.ExternalGUID.GetValue()
End If
if (not JournalEntryRet.ORJournalLineList is nothing) then
Dim i16458 as Integer
for i16458 = 0 to JournalEntryRet.ORJournalLineList.Count - 1
Dim ORJournalLine16459 as IORJournalLine
ORJournalLine16459 = JournalEntryRet.ORJournalLineList.GetAt(i16458)
if (not ORJournalLine16459.JournalDebitLine is nothing) then
if (not ORJournalLine16459.JournalDebitLine. is nothing) then
'Get value of TxnLineID
if ( not ORJournalLine16459.JournalDebitLine.TxnLineID is nothing) then
Dim TxnLineID16460 as String
TxnLineID16460 = ORJournalLine16459.JournalDebitLine.TxnLineID.GetValue()
End If
if (not ORJournalLine16459.JournalDebitLine.AccountRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalDebitLine.AccountRef.ListID is nothing) then
Dim ListID16461 as String
ListID16461 = ORJournalLine16459.JournalDebitLine.AccountRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalDebitLine.AccountRef.FullName is nothing) then
Dim FullName16462 as String
FullName16462 = ORJournalLine16459.JournalDebitLine.AccountRef.FullName.GetValue()
End If
End If
'Get value of Amount
if ( not ORJournalLine16459.JournalDebitLine.Amount is nothing) then
Dim Amount16463 as Double
Amount16463 = ORJournalLine16459.JournalDebitLine.Amount.GetValue()
End If
'Get value of Memo
if ( not ORJournalLine16459.JournalDebitLine.Memo is nothing) then
Dim Memo16464 as String
Memo16464 = ORJournalLine16459.JournalDebitLine.Memo.GetValue()
End If
if (not ORJournalLine16459.JournalDebitLine.EntityRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalDebitLine.EntityRef.ListID is nothing) then
Dim ListID16465 as String
ListID16465 = ORJournalLine16459.JournalDebitLine.EntityRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalDebitLine.EntityRef.FullName is nothing) then
Dim FullName16466 as String
FullName16466 = ORJournalLine16459.JournalDebitLine.EntityRef.FullName.GetValue()
End If
End If
if (not ORJournalLine16459.JournalDebitLine.ClassRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalDebitLine.ClassRef.ListID is nothing) then
Dim ListID16467 as String
ListID16467 = ORJournalLine16459.JournalDebitLine.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalDebitLine.ClassRef.FullName is nothing) then
Dim FullName16468 as String
FullName16468 = ORJournalLine16459.JournalDebitLine.ClassRef.FullName.GetValue()
End If
End If
if (not ORJournalLine16459.JournalDebitLine.ItemSalesTaxRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalDebitLine.ItemSalesTaxRef.ListID is nothing) then
Dim ListID16469 as String
ListID16469 = ORJournalLine16459.JournalDebitLine.ItemSalesTaxRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalDebitLine.ItemSalesTaxRef.FullName is nothing) then
Dim FullName16470 as String
FullName16470 = ORJournalLine16459.JournalDebitLine.ItemSalesTaxRef.FullName.GetValue()
End If
End If
'Get value of BillableStatus
if ( not ORJournalLine16459.JournalDebitLine.BillableStatus is nothing) then
Dim BillableStatus16471 as ENBillableStatus
BillableStatus16471 = ORJournalLine16459.JournalDebitLine.BillableStatus.GetValue()
End If
End If
End If
if (not ORJournalLine16459.JournalCreditLine is nothing) then
if (not ORJournalLine16459.JournalCreditLine. is nothing) then
'Get value of TxnLineID
if ( not ORJournalLine16459.JournalCreditLine.TxnLineID is nothing) then
Dim TxnLineID16472 as String
TxnLineID16472 = ORJournalLine16459.JournalCreditLine.TxnLineID.GetValue()
End If
if (not ORJournalLine16459.JournalCreditLine.AccountRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalCreditLine.AccountRef.ListID is nothing) then
Dim ListID16473 as String
ListID16473 = ORJournalLine16459.JournalCreditLine.AccountRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalCreditLine.AccountRef.FullName is nothing) then
Dim FullName16474 as String
FullName16474 = ORJournalLine16459.JournalCreditLine.AccountRef.FullName.GetValue()
End If
End If
'Get value of Amount
if ( not ORJournalLine16459.JournalCreditLine.Amount is nothing) then
Dim Amount16475 as Double
Amount16475 = ORJournalLine16459.JournalCreditLine.Amount.GetValue()
End If
'Get value of Memo
if ( not ORJournalLine16459.JournalCreditLine.Memo is nothing) then
Dim Memo16476 as String
Memo16476 = ORJournalLine16459.JournalCreditLine.Memo.GetValue()
End If
if (not ORJournalLine16459.JournalCreditLine.EntityRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalCreditLine.EntityRef.ListID is nothing) then
Dim ListID16477 as String
ListID16477 = ORJournalLine16459.JournalCreditLine.EntityRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalCreditLine.EntityRef.FullName is nothing) then
Dim FullName16478 as String
FullName16478 = ORJournalLine16459.JournalCreditLine.EntityRef.FullName.GetValue()
End If
End If
if (not ORJournalLine16459.JournalCreditLine.ClassRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalCreditLine.ClassRef.ListID is nothing) then
Dim ListID16479 as String
ListID16479 = ORJournalLine16459.JournalCreditLine.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalCreditLine.ClassRef.FullName is nothing) then
Dim FullName16480 as String
FullName16480 = ORJournalLine16459.JournalCreditLine.ClassRef.FullName.GetValue()
End If
End If
if (not ORJournalLine16459.JournalCreditLine.ItemSalesTaxRef. is nothing) then
'Get value of ListID
if ( not ORJournalLine16459.JournalCreditLine.ItemSalesTaxRef.ListID is nothing) then
Dim ListID16481 as String
ListID16481 = ORJournalLine16459.JournalCreditLine.ItemSalesTaxRef.ListID.GetValue()
End If
'Get value of FullName
if ( not ORJournalLine16459.JournalCreditLine.ItemSalesTaxRef.FullName is nothing) then
Dim FullName16482 as String
FullName16482 = ORJournalLine16459.JournalCreditLine.ItemSalesTaxRef.FullName.GetValue()
End If
End If
'Get value of BillableStatus
if ( not ORJournalLine16459.JournalCreditLine.BillableStatus is nothing) then
Dim BillableStatus16483 as ENBillableStatus
BillableStatus16483 = ORJournalLine16459.JournalCreditLine.BillableStatus.GetValue()
End If
End If
End If
Next i16458
End If
if (not JournalEntryRet.DataExtRetList is nothing)
Dim i16484 as Integer
for i16484 = 0 to JournalEntryRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = JournalEntryRet.DataExtRetList.GetAt(i16484)
'Get value of OwnerID
if ( not DataExtRetOwnerID is nothing) then
Dim OwnerID16485 as String
OwnerID16485 = DataExtRetOwnerID.GetValue()
End If
'Get value of DataExtName
Dim DataExtName16486 as String
DataExtName16486 = DataExtRetDataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType16487 as ENDataExtType
DataExtType16487 = DataExtRetDataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue16488 as String
DataExtValue16488 = DataExtRetDataExtValue.GetValue()
Next i16484
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 | //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 DoJournalEntryAdd() { 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; BuildJournalEntryAddRq(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; WalkJournalEntryAddRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildJournalEntryAddRq(IMsgSetRequest requestMsgSet) { IJournalEntryAdd JournalEntryAddRq= requestMsgSet.AppendJournalEntryAddRq(); //Set attributes //Set field value for defMacro JournalEntryAddRq.defMacro.SetValue("IQBStringType"); //Set field value for TxnDate JournalEntryAddRq.TxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for RefNumber JournalEntryAddRq.RefNumber.SetValue("ab"); //Set field value for IsAdjustment JournalEntryAddRq.IsAdjustment.SetValue(true); string ORHomeCurrencyAdjustmentElementType16393 = "IsHomeCurrencyAdjustment"; if (ORHomeCurrencyAdjustmentElementType16393 == "IsHomeCurrencyAdjustment") { //Set field value for IsHomeCurrencyAdjustment JournalEntryAddRq.ORHomeCurrencyAdjustment.IsHomeCurrencyAdjustment.SetValue(true); } if (ORHomeCurrencyAdjustmentElementType16393 == "CurrencyExchangeRate") { //Set field value for IsAmountsEnteredInHomeCurrency JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.IsAmountsEnteredInHomeCurrency.SetValue(true); //Set field value for ListID JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.CurrencyRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.CurrencyRef.FullName.SetValue("ab"); //Set field value for ExchangeRate JournalEntryAddRq.ORHomeCurrencyAdjustment.CurrencyExchangeRate.ExchangeRate.SetValue("IQBFloatType"); } if (ORHomeCurrencyAdjustmentElementType16393 == "") { } //Set field value for ExternalGUID JournalEntryAddRq.ExternalGUID.SetValue(Guid.NewGuid().ToString()); IORJournalLine ORJournalLineListElement16394 =JournalEntryAddRq.ORJournalLineList.Append(); string ORJournalLineListElementType16395 = "JournalDebitLine"; if (ORJournalLineListElementType16395 == "JournalDebitLine") { //Set attributes //Set field value for defMacro ORJournalLineListElement16394.JournalDebitLine.defMacro.SetValue("IQBStringType"); //Set field value for TxnLineID ORJournalLineListElement16394.JournalDebitLine.TxnLineID.SetValue("200000-1011023419"); //Set field value for ListID ORJournalLineListElement16394.JournalDebitLine.AccountRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalDebitLine.AccountRef.FullName.SetValue("ab"); //Set field value for Amount ORJournalLineListElement16394.JournalDebitLine.Amount.SetValue(10.01); //Set field value for Memo ORJournalLineListElement16394.JournalDebitLine.Memo.SetValue("ab"); //Set field value for ListID ORJournalLineListElement16394.JournalDebitLine.EntityRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalDebitLine.EntityRef.FullName.SetValue("ab"); //Set field value for ListID ORJournalLineListElement16394.JournalDebitLine.ClassRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalDebitLine.ClassRef.FullName.SetValue("ab"); //Set field value for ListID ORJournalLineListElement16394.JournalDebitLine.ItemSalesTaxRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalDebitLine.ItemSalesTaxRef.FullName.SetValue("ab"); //Set field value for BillableStatus ORJournalLineListElement16394.JournalDebitLine.BillableStatus.SetValue(ENBillableStatus.bsBillable); } if (ORJournalLineListElementType16395 == "JournalCreditLine") { //Set attributes //Set field value for defMacro ORJournalLineListElement16394.JournalCreditLine.defMacro.SetValue("IQBStringType"); //Set field value for TxnLineID ORJournalLineListElement16394.JournalCreditLine.TxnLineID.SetValue("200000-1011023419"); //Set field value for ListID ORJournalLineListElement16394.JournalCreditLine.AccountRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalCreditLine.AccountRef.FullName.SetValue("ab"); //Set field value for Amount ORJournalLineListElement16394.JournalCreditLine.Amount.SetValue(10.01); //Set field value for Memo ORJournalLineListElement16394.JournalCreditLine.Memo.SetValue("ab"); //Set field value for ListID ORJournalLineListElement16394.JournalCreditLine.EntityRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalCreditLine.EntityRef.FullName.SetValue("ab"); //Set field value for ListID ORJournalLineListElement16394.JournalCreditLine.ClassRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalCreditLine.ClassRef.FullName.SetValue("ab"); //Set field value for ListID ORJournalLineListElement16394.JournalCreditLine.ItemSalesTaxRef.ListID.SetValue("200000-1011023419"); //Set field value for FullName ORJournalLineListElement16394.JournalCreditLine.ItemSalesTaxRef.FullName.SetValue("ab"); //Set field value for BillableStatus ORJournalLineListElement16394.JournalCreditLine.BillableStatus.SetValue(ENBillableStatus.bsBillable); } //Set field value for IncludeRetElementList //May create more than one of these if needed JournalEntryAddRq.IncludeRetElementList.Add("ab"); } void WalkJournalEntryAddRs(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.rtJournalEntryAddRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IJournalEntryRet JournalEntryRet = (IJournalEntryRet)response.Detail; WalkJournalEntryRet(JournalEntryRet); } } } } } void WalkJournalEntryRet(IJournalEntryRet JournalEntryRet) { if (JournalEntryRet == null) return; //Go through all the elements of IJournalEntryRet //Get value of TxnID string TxnID16396 = (string)JournalEntryRet.TxnID.GetValue(); //Get value of TimeCreated DateTime TimeCreated16397 = (DateTime)JournalEntryRet.TimeCreated.GetValue(); //Get value of TimeModified DateTime TimeModified16398 = (DateTime)JournalEntryRet.TimeModified.GetValue(); //Get value of EditSequence string EditSequence16399 = (string)JournalEntryRet.EditSequence.GetValue(); //Get value of TxnNumber if (JournalEntryRet.TxnNumber != null) { int TxnNumber16400 = (int)JournalEntryRet.TxnNumber.GetValue(); } //Get value of TxnDate DateTime TxnDate16401 = (DateTime)JournalEntryRet.TxnDate.GetValue(); //Get value of RefNumber if (JournalEntryRet.RefNumber != null) { string RefNumber16402 = (string)JournalEntryRet.RefNumber.GetValue(); } //Get value of IsAdjustment if (JournalEntryRet.IsAdjustment != null) { bool IsAdjustment16403 = (bool)JournalEntryRet.IsAdjustment.GetValue(); } //Get value of IsHomeCurrencyAdjustment if (JournalEntryRet.IsHomeCurrencyAdjustment != null) { bool IsHomeCurrencyAdjustment16404 = (bool)JournalEntryRet.IsHomeCurrencyAdjustment.GetValue(); } //Get value of IsAmountsEnteredInHomeCurrency if (JournalEntryRet.IsAmountsEnteredInHomeCurrency != null) { bool IsAmountsEnteredInHomeCurrency16405 = (bool)JournalEntryRet.IsAmountsEnteredInHomeCurrency.GetValue(); } if (JournalEntryRet.CurrencyRef != null) { //Get value of ListID if (JournalEntryRet.CurrencyRef.ListID != null) { string ListID16406 = (string)JournalEntryRet.CurrencyRef.ListID.GetValue(); } //Get value of FullName if (JournalEntryRet.CurrencyRef.FullName != null) { string FullName16407 = (string)JournalEntryRet.CurrencyRef.FullName.GetValue(); } } //Get value of ExchangeRate if (JournalEntryRet.ExchangeRate != null) { IQBFloatType ExchangeRate16408 = (IQBFloatType)JournalEntryRet.ExchangeRate.GetValue(); } //Get value of ExternalGUID if (JournalEntryRet.ExternalGUID != null) { string ExternalGUID16409 = (string)JournalEntryRet.ExternalGUID.GetValue(); } if (JournalEntryRet.ORJournalLineList != null) { for (int i16410 = 0; i16410 < JournalEntryRet.ORJournalLineList.Count; i16410++) { IORJournalLine ORJournalLine16411 = JournalEntryRet.ORJournalLineList.GetAt(i16410); if (ORJournalLine16411.JournalDebitLine != null) { if (ORJournalLine16411.JournalDebitLine != null) { //Get value of TxnLineID if (ORJournalLine16411.JournalDebitLine.TxnLineID != null) { string TxnLineID16412 = (string)ORJournalLine16411.JournalDebitLine.TxnLineID.GetValue(); } if (ORJournalLine16411.JournalDebitLine.AccountRef != null) { //Get value of ListID if (ORJournalLine16411.JournalDebitLine.AccountRef.ListID != null) { string ListID16413 = (string)ORJournalLine16411.JournalDebitLine.AccountRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalDebitLine.AccountRef.FullName != null) { string FullName16414 = (string)ORJournalLine16411.JournalDebitLine.AccountRef.FullName.GetValue(); } } //Get value of Amount if (ORJournalLine16411.JournalDebitLine.Amount != null) { double Amount16415 = (double)ORJournalLine16411.JournalDebitLine.Amount.GetValue(); } //Get value of Memo if (ORJournalLine16411.JournalDebitLine.Memo != null) { string Memo16416 = (string)ORJournalLine16411.JournalDebitLine.Memo.GetValue(); } if (ORJournalLine16411.JournalDebitLine.EntityRef != null) { //Get value of ListID if (ORJournalLine16411.JournalDebitLine.EntityRef.ListID != null) { string ListID16417 = (string)ORJournalLine16411.JournalDebitLine.EntityRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalDebitLine.EntityRef.FullName != null) { string FullName16418 = (string)ORJournalLine16411.JournalDebitLine.EntityRef.FullName.GetValue(); } } if (ORJournalLine16411.JournalDebitLine.ClassRef != null) { //Get value of ListID if (ORJournalLine16411.JournalDebitLine.ClassRef.ListID != null) { string ListID16419 = (string)ORJournalLine16411.JournalDebitLine.ClassRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalDebitLine.ClassRef.FullName != null) { string FullName16420 = (string)ORJournalLine16411.JournalDebitLine.ClassRef.FullName.GetValue(); } } if (ORJournalLine16411.JournalDebitLine.ItemSalesTaxRef != null) { //Get value of ListID if (ORJournalLine16411.JournalDebitLine.ItemSalesTaxRef.ListID != null) { string ListID16421 = (string)ORJournalLine16411.JournalDebitLine.ItemSalesTaxRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalDebitLine.ItemSalesTaxRef.FullName != null) { string FullName16422 = (string)ORJournalLine16411.JournalDebitLine.ItemSalesTaxRef.FullName.GetValue(); } } //Get value of BillableStatus if (ORJournalLine16411.JournalDebitLine.BillableStatus != null) { ENBillableStatus BillableStatus16423 = (ENBillableStatus)ORJournalLine16411.JournalDebitLine.BillableStatus.GetValue(); } } } if (ORJournalLine16411.JournalCreditLine != null) { if (ORJournalLine16411.JournalCreditLine != null) { //Get value of TxnLineID if (ORJournalLine16411.JournalCreditLine.TxnLineID != null) { string TxnLineID16424 = (string)ORJournalLine16411.JournalCreditLine.TxnLineID.GetValue(); } if (ORJournalLine16411.JournalCreditLine.AccountRef != null) { //Get value of ListID if (ORJournalLine16411.JournalCreditLine.AccountRef.ListID != null) { string ListID16425 = (string)ORJournalLine16411.JournalCreditLine.AccountRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalCreditLine.AccountRef.FullName != null) { string FullName16426 = (string)ORJournalLine16411.JournalCreditLine.AccountRef.FullName.GetValue(); } } //Get value of Amount if (ORJournalLine16411.JournalCreditLine.Amount != null) { double Amount16427 = (double)ORJournalLine16411.JournalCreditLine.Amount.GetValue(); } //Get value of Memo if (ORJournalLine16411.JournalCreditLine.Memo != null) { string Memo16428 = (string)ORJournalLine16411.JournalCreditLine.Memo.GetValue(); } if (ORJournalLine16411.JournalCreditLine.EntityRef != null) { //Get value of ListID if (ORJournalLine16411.JournalCreditLine.EntityRef.ListID != null) { string ListID16429 = (string)ORJournalLine16411.JournalCreditLine.EntityRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalCreditLine.EntityRef.FullName != null) { string FullName16430 = (string)ORJournalLine16411.JournalCreditLine.EntityRef.FullName.GetValue(); } } if (ORJournalLine16411.JournalCreditLine.ClassRef != null) { //Get value of ListID if (ORJournalLine16411.JournalCreditLine.ClassRef.ListID != null) { string ListID16431 = (string)ORJournalLine16411.JournalCreditLine.ClassRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalCreditLine.ClassRef.FullName != null) { string FullName16432 = (string)ORJournalLine16411.JournalCreditLine.ClassRef.FullName.GetValue(); } } if (ORJournalLine16411.JournalCreditLine.ItemSalesTaxRef != null) { //Get value of ListID if (ORJournalLine16411.JournalCreditLine.ItemSalesTaxRef.ListID != null) { string ListID16433 = (string)ORJournalLine16411.JournalCreditLine.ItemSalesTaxRef.ListID.GetValue(); } //Get value of FullName if (ORJournalLine16411.JournalCreditLine.ItemSalesTaxRef.FullName != null) { string FullName16434 = (string)ORJournalLine16411.JournalCreditLine.ItemSalesTaxRef.FullName.GetValue(); } } //Get value of BillableStatus if (ORJournalLine16411.JournalCreditLine.BillableStatus != null) { ENBillableStatus BillableStatus16435 = (ENBillableStatus)ORJournalLine16411.JournalCreditLine.BillableStatus.GetValue(); } } } } } if (JournalEntryRet.DataExtRetList != null) { for (int i16436 = 0; i16436 < JournalEntryRet.DataExtRetList.Count; i16436++) { IDataExtRet DataExtRet = JournalEntryRet.DataExtRetList.GetAt(i16436); //Get value of OwnerID if (DataExtRet.OwnerID != null) { string OwnerID16437 = (string)DataExtRet.OwnerID.GetValue(); } //Get value of DataExtName string DataExtName16438 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType16439 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue16440 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } |