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.
Pages: 1
Hi Nick,
I’m trying to understand whether K9 can support a cleaner and more accurate integration workflow with QuickBooks Online based on two key concepts:
1. Updating the PO in QBO for receiving (non‑posting)
Instead of K9 creating Bills or Inventory Adjustments during receiving, the idea is:
• K9 receives inventory
• K9 updates the Purchase Order in QBO (QtyReceived / QtyRemaining)
• QBO does not post inventory yet
• K9 keeps the received inventory available for sale and shipping immediately
This mirrors how QBO is designed: PO updates are non‑posting, and inventory is only posted when the vendor Bill is entered.
2. Manual Inventory Adjustments in QBO should be the only adjustments K9 accepts
Right now, when QBO syncs, K9 doesn’t appear to distinguish between:
• A posting event in QBO (Bill or Inventory Adjustment)
• A non‑posting event (PO update or raw QOH value)
This causes problems because QBO’s QOH stays at zero until the Bill arrives, and K9 may overwrite its own receiving quantities with QBO’s stale QOH.
What we need K9 to do
K9 needs to be able to tell the difference between:
A. Posting events in QBO (should update K9 QOH):
• Vendor Bill posted in QBO
• Manual Inventory Adjustment posted in QBO
These are authoritative financial events.
K9 should accept QOH changes from these.
B. Non‑posting events in QBO (should NOT update K9 QOH):
• PO updates (QtyReceived / QtyRemaining)
• Raw QOH values in QBO before the Bill is entered
These should not overwrite K9’s operational inventory.
Why this matters
Example scenario:
• K9 receives 10 units → K9 QOH = 10
• K9 ships 6 units → K9 QOH = 4
• QBO still shows 0 QOH because the Bill hasn’t been entered from the vendor yet
• If K9 syncs and accepts QBO’s 0 QOH, it wipes out the received inventory
• Or if K9 later accepts QBO’s 10 QOH after the Bill, it would incorrectly jump back to 10 even though 6 have already shipped
To avoid this, K9 needs logic like:
“Only accept QBO QOH if the change came from a Bill or Inventory Adjustment AND K9 has not already received/shipped those units operationally.”
What I’m asking:
Is it possible for K9 to implement:
1. Receiving → update PO in QBO only (non‑posting)
2. K9 keeps received inventory available for sale/shipping immediately
3. K9 ignores QBO QOH unless the change is tied to a Bill or Inventory Adjustment
4. K9 does NOT overwrite its operational QOH with QBO’s pre‑Bill QOH
5. K9 does NOT push Inventory Adjustments to QBO during receiving
This would allow:
• Accurate operational inventory in K9
• Accurate financial inventory in QBO
• No double‑counting
• No negative inventory issues
• No overwriting of received stock
• No need for Item Receipt functionality (which QBO doesn’t support anyway)
Goal
I’m trying to confirm whether K9 can support this architecture so that:
• Receiving stays operational in K9
• Posting stays financial in QBO
• K9 only updates QBO via PO updates
• K9 only accepts QBO QOH when it’s a true posting event
Let me know if this is feasible or if there are limitations in the current integration that prevent this.
Thank you
Offline
To do what you're looking to do, it sounds like shutting off the K9 PO postings from K9 to QBO would fill your requirements. That would require you to comment out the code block in the QBO module which sends over PO updates (or the block the queues them). We can handle this for you as a quick custom job, if you want. Once that's shut off, you'll need to create bills and receive all inventory for those bills manually in QBO.
Additionally, you may want to set 'Inventory Update' to Manual under Store / Component / Settings / Extension Module: QuickBooks Online in order to stop inventory adjustments from happening. That's just a setting change.
Offline
Pages: 1