[QODBC-Desktop] Troubleshooting - How to Receive Inventory without Purchase Orders
Posted by Jack - QODBC Support on 27 September 2017 10:13 AM
|
|
Troubleshooting - How to Receive Inventory without Purchase OrdersProblem Description:Is it possible to register an item's arrival without the purchase order? If yes, can I insert the rows in the "ItemReceiptItemLine" table using the reference to Bill? Solution:Receiving Item does not require PurchaseOrder. You can receive it directly using BillItemLine & ItemReceiptItemLine table. If you want to reference Receive Item with Bill, then you need to create Bill using BillItemLine table. Please refer How to create Bills using QODBC for more details. You can Receive Item without PurchaseOrder by inserting records in “ItemReceiptItemLine” table. Examples of Creating Item Receipt using QODBCFirst of all please create new MS Access database & link ItemReceiptItemLine table. Please refer How to Use QODBC with MS Access 2016 / 365 / 2013 32-bit for more details. If you have 64-bit MS Office, Please refer How to Use QODBC with MS Access 2016 / 365 / 2013 64-bit for more details.
After linking table, we need to execute the query in MS Access query editor: It should popup for choosing the table, please click "close" button. Now, Please click on "SQL" from left top corner below File menu.
Create an Item Receipt with 2 LinesHere we create an Item Receipt with 2 lines by using 2 ItemReceiptItemLine INSERT commands (with the FQSaveToCache caching flag set true), which is automatically designed to pull in all cached ItemReceiptItemLine records and save immediately. First Line INSERT INTO ItemReceiptItemLine (VendorRefListID,RefNumber,Memo, ItemLineItemRefListID, ItemLineDesc, ItemLineQuantity, ItemLineCost, ItemLineAmount, ItemLineCustomerRefListID,ItemLineBillableStatus,FQSaveToCache) values ('B0000-933272656','1','Received items (bill to follow)','110000-933272656','Cabinets:Cabinet Pulls',2,50,100,'7D0000-1071526869','Billable',1) Second Line INSERT INTO ItemReceiptItemLine (VendorRefListID,RefNumber,Memo, ItemLineItemRefListID, ItemLineDesc, ItemLineQuantity, ItemLineCost, ItemLineAmount, ItemLineCustomerRefListID,ItemLineBillableStatus,FQSaveToCache) values ('A60000-1197760912','1','Received items (bill to follow)','130000-933272656','Hardware:Doorknobs Std',3,60,180,'940000-1071506775','Billable',0) Result in QuickBooks Related Data Location Information VendorRefListID Find ListID from Vendor Table ItemLineItemRefListID Find ListID from Item Table ItemLineCustomerRefListID Find ListID from Customer Table
| |
|