QuickBooks Integrator V6 - Online Help
QuickBooks Integrator V6
Questions / Feedback?

Invoice Control

Properties   Methods   Events   Configuration Settings   Errors  

An Invoice indicates that a CUSTOMER owes money to the QuickBooks company. An Invoice is the opposite of a CREDITMEMO .

Syntax

Invoice

Remarks

The Invoice control represents an invoice sent to a Customer. When an invoice is added, the total amount is automatically entered into the Accounts Receivable register.

An Invoice should only be used if the Customer does not make payment at the time of the sale. If payment is made at the time of sale, the transaction should be recorded as a SalesReceipt instead.

Required Fields (Add): Customer*, Items

Supported Methods: Add, Get (Id), Cancel, Delete

Example

Invoice1.CustomerName = "John Q. Customer"             '*
Invoice1.TransactionDate = "1/17/03"
Invoice1.ItemCount = 1
Invoice1.ItemName(0) = "Our Company's Product"         '*
Invoice1.ItemAmount(0) = "140.00"
Invoice1.ShipDate = "1/20/03"
Invoice1.Add()

'*: Item must already exist in QuickBooks.

The total of an Invoice is the total of its item lines. There is no total amount property; when the control represents an invoice returned from QuickBooks, the total amount is divided between AppliedAmount and BalanceRemaining.

Item Lines: Item lines are used to track the sale of goods or services. Line items may be added by first setting ItemCount. Then for each line set the Item Id (or Name) or Group. You may also optionally set the Rate/RatePercent/PriceLevel, Quantity, Description, Class, TaxCode, ServiceDate, and Amount for each item as well.

The control supports a variety of other operations as well. The control's Get, Cancel, and Delete methods may be used to retrieve, cancel, and delete Invoices, respectively. The ObjSearch Control may be used to search for Invoices in the QuickBooks database.

Property List


The following is the full list of the properties of the control with short descriptions. Click on the links for further details.

AppliedAmountAmount customer has paid on this invoice.
ARAccountIdReference to the Accounts Receivable account where money goes.
ARAccountNameReference to the Accounts Receivable account where money goes.
BalanceRemainingBalance remaining.
BillingAddressAddress to bill to.
CustomerIdA reference to the customer or customer job.
CustomerMessageIdReference to message to appear to customer.
CustomerMessageNameReference to message to appear to customer.
CustomerNameA reference to the customer or customer job.
DueDateDate when payment is due.
FinanceChargeIf true, this invoice includes a finance charge.
IncludeLinkedTxnsIndicates whether to include linked transactions in the response.
IsPaidIndicates whether this invoice has been paid.
IsPendingIf true, this transaction has not been completed.
IsToBePrintedWhether this transaction is to be printed.
ItemCountThe number of records in the Item arrays.
ItemLineIdIdentification number of the transaction line, used for Updates.
ItemAggregateContains an XML aggregate of the line item.
ItemNameLine item property: Reference to the kind of item.
ItemIdLine item property: Reference to the kind of item.
ItemDescriptionLine item property: Description of item.
ItemQuantityLine item property: Quantity of item or item group.
ItemUnitOfMeasureUnit of measure describing the Quantity .
ItemRateUnit rate of item.
ItemRatePercentLine item property: A markup or discount percentage.
ItemPriceLevelNameLine Item property: Specify custom pricing for specific customers.
ItemPriceLevelIdLine Item property: Used to specify custom pricing for specific customers.
ItemClassNameLine item property: Reference to the class of the item.
ItemClassIdLine item property: Reference to the class of the item.
ItemAmountLine item property: the total amount of this item.
ItemServiceDateLine item property: Date of service.
ItemTaxCodeNameLine item property: Sales tax information for this item.
ItemTaxCodeIdLine item property: Sales tax information for this item.
ItemOverrideAccountNameAn account which will override the default account for the line item.
ItemOverrideAccountIdAn account which will override the default account for the line item.
ItemOther1Standard QuickBooks Custom Field available for transaction line items.
ItemOther2Standard QuickBooks Custom Field available for transaction line items.
ItemGroupNameReference to a group of line items.
ItemGroupIdReference to a group of line items.
ItemLinkToTxnIdA link to an existing SALESORDER transaction.
ItemLinkToTxnLineIdA link to a specific line of an existing SALESORDER transaction.
LinkedTxnCountThe number of records in the LinkedTxn arrays.
LinkedTxnAmountThe amount of the linked transaction.
LinkedTxnDateThe date of the linked transaction.
LinkedTxnLinkTypeIndicates the nature of the link between the transactions.
LinkedTxnRefNumberThis is the reference number assigned to the linked transaction.
LinkedTxnIdThis property can be used by another component to reference the original transaction which is linked to the current response.
LinkedTxnTypeThis property indicates which type of linked transaction has been returned.
LinkToTxnIdThe LinkToTxnId property allows you to link to an entire transaction, pulling in all of its line items.
MemoMemo to appear on internal reports only.
PONumberP.O. number.
QBConnectionStringAn aggregate consisting of various QuickBooks connection properties.
QBRequestAggregateThe request aggregate.
QBRequestIdThe Id of the next message to be sent to QuickBooks.
QBRequestModeDefines whether the request is made online or stored offline.
QBResponseAggregateThe last QBXML response aggregate received from QuickBooks.
QBXMLVersionThe version of QBXML used in the outgoing message.
RefIdAn alphanumerical identifier generated by the server.
RefNumberReference number for the transaction.
SalesRepIdReference to (initials of) sales rep.
SalesRepNameReference to (initials of) sales rep.
SalesTaxTotalTotal amount of sales tax.
ShipDateDate of shipping.
ShipMethodIdReference to preferred method of shipping.
ShipMethodNameReference to preferred method of shipping.
ShippingAddressAddress to ship to.
SubtotalGross subtotal; doesn't count taxes/amount already paid.
TaxItemIdReference to detailed taxation information.
TaxItemNameReference to detailed taxation information.
TemplateIdSpecifies how to print Invoice transactions.
TemplateNameSpecifies how to print Invoice transactions.
TermsIdReference to terms of payment.
TermsNameReference to terms of payment.
TransactionDateDate of transaction.

Method List


The following is the full list of the methods of the control with short descriptions. Click on the links for further details.

AddAdds the record into QuickBooks.
CancelCancels (voids) the transaction.
CheckRequestStatusChecks whether or not the specified request was processed by QuickBooks.
CloseQBConnectionCloses a persistent connection to QuickBooks.
ConfigSets or retrieves a configuration setting .
DeleteDeletes the record from QuickBooks.
GetGets a single record from QuickBooks.
GetCustomFieldGets a custom field value from QuickBooks.
ImportQBXMLImports a QBXML response aggregate.
OpenQBConnectionOpens a persistent connection to QuickBooks.
ResetResets all properties to their defaults.
SetCustomFieldSets a custom field value within QuickBooks.
UpdateUpdates the invoice in QuickBooks.

Event List


The following is the full list of the events fired by the control with short descriptions. Click on the links for further details.

ErrorInformation about errors during data delivery.
SSLServerAuthenticationFired after the server presents its certificate to the client.
SSLStatusShows the progress of the secure connection.
StatusShows the progress of the QuickBooks connection.
WarningFired when a warning occurs.

Configuration Settings


The following is a list of configuration settings for the control with short descriptions. Click on the links for further details.

SendRawXMLSends specified XML to quickbooks without modification.
AppendAfterAppends an XML tag after the specified QBXML element.
TimeCreatedThe time the object was created.
TimeModifiedThe time the object was created.
EditSequenceAn identifier for this copy of the object.
TemplateNameThe name of an existing template to apply to the transaction.
TemplateIdThe ID of an existing template to apply to the transaction.
SuggestedDiscountAmountA suggested discount amount for the Invoice.
SuggestedDiscountDateA suggested discount date for the Invoice.
ExchangeRateCurrency exchange rate for this invoice.
FinanceChargeIf set to True, a finance-charge item has been added to the invoice.
BalanceInHomeCurrencyBalance remaining in units of the home currency.
CurrencyNameName of the currency code used for this invoice.
CurrencyIdId of the currency code used for this invoice.
IsTaxIncludedDetermines if tax is included in the transaction amount.
IsToBeEmailedWhen true, if no email address is on file for the customer the transaction will fail.
CustomerSalesTaxNameReference to sales tax information for the CUSTOMER.
CustomerSalesTaxIdReference to sales tax information for the CUSTOMER.
SalesTaxPercentagePercent paid as sales tax.
FOBFreight On Board: the place from where shipped.
ClassNameA reference to the class of transaction.
ClassIdA reference to the class of transaction.
Items[index].OverrideItemAccountNameAn account which will override the default account for the line item.
Items[index].OverrideItemAccountIdAn account which will override the default account for the line item.
StopOnErrorSpecifies how QuickBooks is to proceed if an error occurs in processing of the current request.
SSLAcceptServerCertThe SSL certificate being used by the Remote Connector.
SSLAcceptServerCertFileThe SSL certificate file being used by the Remote Connector.
EnforceMaxLengthIndicates whether to enforce max lengths for QB Fields.
AuthFlagsConnection Flags (use for QuickBooks Simple Start).
GetHighestVersionHighest QBXMLVersion supported by the installed instance of QuickBooks.
GetSupportedVersionsReturns a list of QBXMLVersions that are supported by QuickBooks.
GetRequestProcessorDLLVersionReturns the version of the QB Request Processor that is installed on your system.
IsReadOnlyThis causes the QuickBooks authorization dialog to display text informing the user that its access will be read-only.
UnattendedModePrefWhether connecting while QuickBooks is closed is required or optional for the user.
PersonalDataPrefWhether the connecting application will require access to personal data such as SSN or credit card information.
QBOpenCompanyFileThe file currently open in QuickBooks.
QBConnectionModeThe mode of connection to QuickBooks.
QBFileStatusThe status of the company file as it pertains to accepting connections.
WarningCodesA comma-separated list of QuickBooks warning codes that should not result in an exception.
Tax1TotalCanadian field used for Goods and Services Tax, or GST.
Tax2TotalCanadian field used for Provincial Sales Taxes, or PST.
ExchangeRateIndicates the exchange rate for the transaction.
CodePageThe system code page used for Unicode to Multibyte translations.

 
 
Copyright (c) 2017 /n software inc. - All rights reserved.
Build 6.0.6240.0