Power BI Connector for QuickBooks

Build 24.0.9062

BuildAssemblies

Insert, Update, delete, and query QuickBooks Build Assembly transactions.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier.

TxnNumber Integer True

An identifying number for this transaction.

ItemInventoryAssemblyRef_ListID String False

Items.ID

255

A reference to the Id of an inventory assembly. Either ItemInventoryAssemblyRef_ListID or ItemInventoryAssemblyRef_FullName is required when inserting a BuildAssembly.

ItemInventoryAssemblyRef_FullName String False 1000

A reference to the name of an inventory assembly. Either ItemInventoryAssemblyRef_ListID or ItemInventoryAssemblyRef_FullName is required when inserting a BuildAssembly.

InventorySiteRef_ListID String False

InventorySites.ID

255

A reference to the Id of an inventory site.

InventorySiteRef_FullName String False 31

A reference to the name of an inventory site.

SerialNumber String False 5000

The serial number of the asset. This cannot be used with LotNumber.

LotNumber String False 40

The lot number of the asset. This cannot be used with SerialNumber.

TxnDate Date False

The date of the transaction.

RefNumber String False 21

A reference number identifying the transaction. This does not have to be unique.

Memo String False 5000

A memo about the transaction.

IsPending Boolean True

If IsPending is set to true, the transaction in question has not been completed.

QuantityToBuild Double False

Specifies the number of assemblies to be built. The transaction will fail if the number specified here exceeds the number of on-hand items.

QuantityCanBuild Double True

Indicates the number of this assembly that can be built from the parts on hand.

QuantityOnHand Double True

The number of these items in the inventory. To change the QuantityOnHand, you would need to add an inventory adjustment.

QuantityOnSalesOrder Double True

The number of these items that have been sold (as recorded in sales orders) but not delivered to customers.

MarkPendingIfRequired Boolean False

Allows the build assembly to be marked pending if there are insufficient quantities to complete the build assembly. This field requires QBXML Version 7.0 and is not returned in the response from QuickBooks.

ExternalGUID String True

A user-defined GUID value. Requires QBXML Version 9.0.

BuildAssemblyLineAggregate String True 5000

An aggregate of the line item data which can be used for adding a transfer inventory and its line item data.

TimeCreated Datetime True

The datetime the transaction was made.

TimeModified Datetime True

The last datetime the transaction was modified.

EditSequence String True

An identifier used for versioning for this copy of the object.

ExpirationDateForSerialLotNumber String True 1099

The expiration date for serial lot number of this item. This requires QBXML version at least 16.0.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062