Kryptronic Software Support Forum

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.

#1 05-21-2024 10:47:32

polarize
Member
Registered: 11-15-2004
Posts: 295

Received items on purchase order not updating inventory tables or QB

We have a purchase order that already had some items received early last week and the remaining items yesterday which closed the purchase order with all items now received.  This morning we tried to sell an item that was on the second receiving operation that shows zero inventory on hand even though we had received two cases yesterday.  We then checked the closed to purchase order to see if this affected any other items that were received yesterday to discover that all of those items have not been updated to the inventory tables either.  We also noticed that the receiving record has not exported to QuickBooks when synced this morning.

Is there a delayed function we need to be looking at that might be preventing this receiving record from updating QOH in inventory?  We suspect this might be happening to other purchase orders as well because it seems we often run into having more inventory on hand with some items than what K9 says we have.  Please advise.  Thank you


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#2 05-21-2024 11:44:20

polarize
Member
Registered: 11-15-2004
Posts: 295

Re: Received items on purchase order not updating inventory tables or QB

Upon further investigation, I ran QBWC again and it through an error.....

The following errors were encountered while processing requests for the QBWC accounting system. Reported errors will persist until resolved.

QBWC.additemrec.O2405133:

The "LinkToTxn" field has an invalid value "TxnID=89DF8-1715703207, TxnLineID=89DFD-1715703207".

I looked up the record in Raw Database ecom_purchorditemsreq for this purchase order and found the TxnLineID that was referenced but couldn't figure out what the invalid value is nor has this item been an issue in the past.

What is confusing is why the inventory tables were not updated immediately upon receiving the purchase order showing it as available with the QOH.

Next, I went into QB and reviewed the purchase order and discovered it had been closed without receiving these items so I unchecked the boxes for the three items that were received yesterday resulting in the purchase order being open again in QB.  After resetting the QB connection ran QBWC again and the error cleared and the purchase order is now properly closed in QB and the inventory is showing in K9. It appears to be resolved even though my question remains about what workflow process and timing is used to process received inventory till how and when it should show in K9 as available in the inventory record. Please advise. Thank you


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#3 05-21-2024 16:15:23

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19818
Website

Re: Received items on purchase order not updating inventory tables or QB

Reopen purchase order O2405133 in QB and then run your synch.  The PO was closed out in QB before the last item receipt could be logged.


Nick Hendler

Offline

 

Board footer