Knowledgebase: Tutorials
[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).