JDBC Driver for QuickBooks POS

Build 22.0.8462

InventoryQtyAdjustmentItems

Create and query QuickBooks POS Inventory Quantity Adjustment Items.

Table Specific Information

Select

QuickBooks POS allows many of the columns to be used in the WHERE clause of a SELECT query. These columns can create either Single or Range filters, as defined in the table schema.

Single Filters Single filters make direct comparisons by using the = comparison.
Range Filters Range filters can search only ranges that have an inclusive lower bound, specified by the >= operator, and an exclusive upper bound, specified by the < operator.

To apply a single bound to a string column that has the Range filter type, the = or LIKE operators are available.

To apply a single bound to a numeric or datetime column that has the Range filter type, the >, >=, <, <=, or = operators are available.


SELECT * FROM InventoryQtyAdjustmentItems WHERE Associate LIKE '%George%' AND TimeModified >= '1/1/2014' AND TimeModified < '2/1/2014'

Insert

Insert can be used to add an item to an existing InventoryQtyAdjustment record. To add an item to an existing record, the TxnId column of the InventoryQtyAdjustment record that the item is to be added to, ItemListId, and ItemNewQuantity are required.

INSERT INTO InventoryQtyAdjustmentItems (TxnId, ItemListId, ItemNewQuantity) 
VALUES ('-1234567890123456789', '-1000000000000000004', '10')

Columns

Name Type ReadOnly Filter Type Description
TxnID String True Single

The unique identifier, generated by QuickBooks POS.

Associate String False Range

The employee making the adjustment.

Comments String False Range

Contains a description of the transaction.

CostDifference Decimal True

Difference in cost for the items. The value displayed is equal to the new cost minus the old cost.

HistoryDocStatus String True Single

Indicates the current status of the cost memo created as a result of inserting the transaction. Possible values are Reversed (this memo is the corrected version of the original memo), Reversing (this memo caused an older memo to be reversed), and Regular (the document has been corrected).

InventoryAdjustmentNumber Double True Range

The adjustment number, assigned by QBPOS when an adjustment is successfully added to QBPOS.

InventoryAdjustmentSource String False Single

The action or functionality that created the adjustment. Possible values are Manual (manually created memo), Physical (physical inventory), and Assembly (Assembly item).

ItemsCount String True Range

The number of line items in the insert that added the transaction.

NewQuantity Double True Range

The new quantity of the items being adjusted.

OldQuantity Double True Range

The quantity of the items prior to the adjustment.

QtyDifference Double True

Difference in quantity for the items. The value displayed is equal to NewQuantity minus OldQuantity

QuickBooksFlag String False Single

The status of data export for a memo. This element is used only if QBPOS is being used with QuickBooks Financial Software. Possible values are NOT POSTED (not yet sent to QuickBooks), COMPLETE (sent to QuickBooks), and ERROR (attempting to send the memo to QuickBooks resulted in an error). No default value.

Reason String False Range

Enter the reason for the adjustment or select from the following predefined reasons: Cycl Cnt (cycle count), Vend Chg (vendor change), Prc Line (price line), Seas End (end of season), Annual, Shrink, Stolen, Damaged, and New Item.

StoreExchangeStatus String True Single

In multistore configurations, if the customer information has changed, this information is updated at the headquarters store. This response field indicates whether the customer information was successfully updated or not. Possible values are Modified, Sent, and Acknowledged.

StoreNumber Double False Range

This is used only for multi-store versions of QBPOS. The value is between 1 and 10, since a maximum of 10 stores are currently supported.

TxnDate Datetime False Range

The date of the transaction. In some cases, if this value is not specified, QBPOS will use the current date or pre-fill TxnDate with the date of the last-saved transaction of the same type.

TxnState String False Single

The current state of the transaction. Possible values are Normal (the transaction is complete) and Held (the transaction has not yet been finalized).

Workstation Double False Range

Workstation from which the transaction was made.

CustomFieldsOwnerID String False Multi

Identifies the owner of the CustomFields to be returned in the response. The default value of '0' is sent which refers to a public custom field that is exposed in the QuickBooks POS UI. All other values are GUID's that are created by the owner and are private custom fields (not exposed via the QuickBooks POS UI).

CustomFields String False

Custom fields returned from QuickBooks POS and formatted into XML.

TimeCreated Datetime True Range

When the transaction was created.

TimeModified Datetime True Range

When the transaction was last modified.

ItemListID# String False

The unique identifier for the item, generated by QuickBooks POS.

ItemNewQuantity# Double False

The new quantity for each inventory item being adjusted.

ItemOldQuantity# Double True

Inventory quantity for this item before updating this memo.

ItemQtyDifference# Double True

Difference in quantity for the item. The value displayed is equal to ItemNewQuantity minus ItemOldQuantity.

ItemNumberOfBaseUnits# Double True

The item serial number, used for purposes of warranty tracking or meeting legal requirements. Once recorded, former documents can be quickly located by searching by serial number.

ItemUnitOfMeasure# String False

If the company is using only a single unit of measure, this specifies the unit of measure for the item. If the company is using multiple units of measure, this specifies the base unit of measure for the item.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462