You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hello,
QuickBooks Online has released a new feature that was available in QuickBooks Desktop. One of the features we lost switching over to QBO was how inventory receiving was handled compared to QBD. The difference was that K9 received inventory that was exported to QBD through QBWC module to Item Receipts which functionally is inventory received without a bill. Since going to QBO this functionality was instead handled like inventory received with a bill which essentially created a bill in QBO even though it didn't represent the correct invoice number or the true bill from vendor amount or terms. This has caused us to try and catch these bills before they get paid so we can edit them with the correct details from the vendor invoice.
Is it possible to alter the QBO module to integrate with "Items Receipt" functionality now that it's available in QBO? This might be usefull for others to be able to receive inventory in this way since I would imagine that most businesses likely receive their vendor invoices after inventory is already received in.
Thank you ![]()
Offline
They changed a ton with QBO as compared to QBD. You've noticed one of those changes - how item receipts are logged in QBO. Basically QBO is making it "easier" for you by creating the bill automatically from item receipts rather than having you do it as an additional step like with QBD.
I suggest contacting Intuit support about this as there may be a setting on the QBO side to adjust this behavior. Let me know what they say. I don't see any way via the QBO API to do an item receipt any other way than the way it is being done now.
Offline
I’m revisiting this to get clarification to see if the new QBO Item Receipts feature will work once turned on (irreversible) while items are received in K9 that are exported to QBO. I’m asking so many questions because the function is irreversible but if it works would save us a ton of time and confusion editing invoices that QBO auto creates now. In QBD (QuickBooks Desktop) the data exchange was via QBWC and the options in QBD was to receive items with a bill and item receipts only without a bill.
When we started using QBO it was a game changer for us on many levels except the only receiving function at the time was essentially Receive Items with a bill which has been a significant pain-point. Then more recently QBO finally released Item Receipts as a feature in QBO much to the celebration of many users I’m sure but that little condition labeled as irreversible causes a moment of pause turning it on because we still want to keep using K9 to manage receiving inventory.
I hope to start a dialogue to see if any other K9 users have tried turning on Item Receipts in QBO with successfully handling data from K9 to Item Receipts instead of items received with QBO automatically creating a bill. My hope is that the entire function is executed inside of QBO to either Receive Items with a bill auto created or Item Receipts only if that’s what you chose to turn on which will then allow for an invoice to be added later.
It doesn’t appear, at least from my understanding, that the QBO API has changed so I’m not sure if that connection is merely a tunnel that sends data through that navigates to whatever direction I’ve set up in QBO or if the connection from K9 is specifically telling QBO to create an item receipt with a bill auto created and can go nowhere else because QBO won’t allow it thus breaking my connection from K9 going into QBO with item receiving.
Several queries I’ve made with both QBO Developers Forum and Ai chats suggest different answers none of which secure my confidence since some say it’s a UI function only so would work while other information suggests that there is no direct connection to item receipts from the API which both may be saying the same thing but feels like a fragmented workflow to me at this point.
Any clarification from Nick or other users could be helpful since I feel like I need a full understanding of how K9 handles the data and how QBO directs data coming in from third party developers when it comes to Item Receipts. Either it works because QBO makes the decisions based on settings or this function is 100% useless unless you use it specifically inside QBO which breaks our receiving workflow process from K9 to QBO.
Please share your knowledge, questions or experience with this new feature in QBO. Thank you.
Offline
It appears from the code that the receiving logic in the QBO module already contains "Item Receipts" without any likely change needed to send the data to QBO...
// +--
// | Item Receipts - Handled in groups based on timestamp.
// +--
$sql = 'SELECT id, purchordid, epochcreated FROM ecom_purchorditemsrec WHERE ' . $acctsysstorage . '=' . $this->CORE_DB->quote('');
$res = $this->CORE_DB->sql_do(array('sql' => $sql, 'table' => 'ecom_purchorditemsrec', 'order' => array('purchordid' => 'ASC', 'xinvid' => 'ASC', 'epochcreated' => 'ASC')));
if ((!($this->isError($res))) && (!(empty($res)))) {
$purchordids = array();
foreach ($res as $num => $data) {
if ((empty($data[$acctsysstorage])) && ($data['epochcreated'] < $this->acctsysdata['queue_firsttransdate'])) {$this->acctsysdata['queue_firsttransdate'] = $data['epochcreated'];}
if (!(isset($purchordids[$data['purchordid']]))) {$purchordids[$data['purchordid']] = array();}
$purchordids[$data['purchordid']][$data['epochcreated']] = 1;
} // End of foreach statement.
foreach ($purchordids as $purchordid => $purchordrec) {
ksort($purchordrec);
foreach ($purchordrec as $pordatetime => $porone) {$savequeuesec[] = array('action' => 'additemrec', 'xid' => $purchordid . '-' . $pordatetime, 'status' => 'READY', 'data' => '');}
} // End of if statement.
} // End of if statement.In further reading about QBO Item Receipt Feature where we want to Receive inventory without a bill it appears from documentation that a bill is no longer needed to update the QOH in QBO...
Use Item receipts instead of Bills if you received the items but the vendor didn't provide the Bill yet. This increases your Inventory Asset account only. Bills will no longer update the quantity on hand.
https://quickbooks.intuit.com/learn-sup … V_US_en_US
Is my understanding about how K9 sends the data correct so far and does it appear QBO can take the same Items Received data from K9 and update QOH for the purchase order and not require a bill except for updating the Inventory Value COA? My question would be that if this is true could QOH sync between QBO and K9 remain accurate so that when items are received in K9 that the QBO sync doesn't create a negative adjustment in K9 since the bill is not needed to update QOH anymore? This is the scenario given if QBO is the authority if making a manual adjustment to sync to K9 but could also be affected if K9 is the authority on QOH adjustments upon sync.
Offline