[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 QODBCNote: The following example uses the QuickBooks USA Sample Rock Castle Construction company file. To Create a new Transfer Inventory recordPlease 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)
| |
|