Knowledgebase: Data & Table
[QODBC-Desktop] How to Create a Transfer Inventory record using QODBC
Posted by Rajendra Dewani (QODBC Support) on 12 March 2019 02:13 PM

How to Create a Transfer Inventory record using QODBC

Note: The following example uses the QuickBooks USA Sample Rock Castle Construction company file.

To Create a new Transfer Inventory record

Please refer to the below-listed samples.

 

INSERT INTO TransferInventoryLine (RefNumber, FromInventorySiteFullName, ToInventorySiteFullName, TransferInventoryLineItemRefFullName, TransferInventoryLineQuantityToTransfer,FQSaveToCache) 

Values ('9', 'Drop Ship,' 'Inventory Test,' 'Hardware,' 3,1)

 

INSERT INTO TransferInventoryLine (RefNumber, FromInventorySiteFullName, ToInventorySiteFullName, TransferInventoryLineItemRefFullName, TransferInventoryLineQuantityToTransfer,FQSaveToCache) 

Values ('9', 'Drop Ship,' 'Inventory Test,' 'NewItemInventory,' 2,0)

 

 

OR

 

Insert Into TransferInventoryLine

(TransferInventoryLineItemRefFullName, FromInventorySiteFullName,ToInventorySiteFullName, TransferInventoryLineFromInventorySiteLocationRefFullName,TransferInventoryLineToInventorySiteLocationRefFullName,

TransferInventoryLineQuantityToTransfer) 

VALUES

('NewItemInventory: Test - 123', 'MySite,' 'MySite,' 'MySite: Drawer-01', 'MySite: Drawer-03',3)

 

or

 

INSERT INTO TransferInventoryLine (FromInventorySiteFullName, ToInventorySiteFullName, TransferInventoryLineItemRefFullName, TransferInventoryLineFromInventorySiteLocationRefFullName, TransferInventoryLineToInventorySiteLocationRefFullName, TransferInventoryLineQuantityToTransfer) 

VALUES ('Distribution Center,' 'San Jose Warehouse,' 'AN spring,' 'Distribution Center: B18', 'San Jose Warehouse: SS14', 10)

 

(0 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).