Hi. I am trying to update prices. I have QB Enterpise 2017 and OpenSync 2.0.80
I get this: This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
I have done this before successfully but now I can’t. Attached is a view of the error table and below is and error that seems related in the CoreOBjXDB Log.
ERROR: Item cannot be found in the collection corresponding to the requested name or ordinal.(GenMakeDBRecs: Item cannot be found in the collection corresponding to the requested name or ordinal.: Dessicato:Postulator Sauvignon 89833 Box Max in table itemin
Hi Yudel, all the errors are the same. I have a few hundred items to update (700+) but am trying it just on 39 or 40 while I troubleshoot.
When I go to the error table, it says:
Field quickbooks response:
Date/Time 03/28/2018 12:38:13
This feature is not enabled or not available in this version of QuickBooks.
Then as I arrow down, the only thing that changes is the IDKEY.
I have just tried updating custom prices and I got the same except this time it was only one error (since I was updating multiple items from only one level). I am attaching those logs as well even though I realize they may not shed much light.
Before trying the latest update to sales price, I repopulated Items, but no luck.
Hi. I have tried something else that I hope sheds light into what the solution will ultimately be.
I created a new database and populated just the items list. I then wrote to the mysql table iteminventory the new prices. I then tried to update the prices to our QB company file via Opensync just as I have been doing from our production db. But I get the exact same error as before. (This is with a rebuilt company file, patched QB, restarted server, all windows updates, etc.)
Hi Yudel, I was able to update hundreds of custom prices via the 2nd database that I created as a test. While I still got the “not supported in quickbooks” error when trying to update standard prices to the items list, I was able to update pricelevels via this test database. I went ahead and used Excel copy and paste into the “add/edit multiple list entries” interface to update standard prices.