Knowledgebase
[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 Orders

Problem 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 QODBC

First 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:
MS Access >> create tab >> Query Design

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 Lines

     Here 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

 

(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).