Average Item Cost is wrong - Company file condensed

Hello there, @EL34.

The Condense Data utility helps streamline your company data file. If you are having performance issues, the Condense Data utility should help you improve your QuickBooks performance.

However, before condensing, make sure it's the best option for your company. Condensing cannot be undone at a later point. 

Here are some valid reasons to Condense:

• You have a large data file.
• You are nearing a list limit.
• You have upgraded all your hardware.
• Your accountant and your technical support have discussed other options and are willing to proceed with Condensing.

Please check out this article for your reference to learn more about this process, p: Use the Condense Data utility.

If there's anything else that I can help you with, please let me know in the comment section down below. 

What are you talking about?
Did you read my post?

I condensed my company file at the end of 2019?

@EL34 

We had a few client with similar issues like yours. We had them purchased a 3rd party supercondense service. You may make a deal with the vendor that you will only pay the service if you don't find any similar issue with the condensed data file.

I would rather have some sort of utility that can set the average cost to whatever the current cost is.

Then Quickbooks can do it's average cost calculations going forward from today

I use the QB SDK and QBXML to do all sorts of things, but you can't get access to the average cost through QBXML

Thanks for keeping me updated about this, @EL34.

To verify why you're unable to access the average cost through the QBXML, I recommend reaching out to our Intuit Developer. This team is the best resource for such concern as they have the tool to check your software libraries. 

You can visit them through this site: Intuit Developer

I'm also adding here a link about using the QBXML in QuickBooks Desktop for reference: qbXML Message structure

In the event that you have any other questions with QuickBooks, let me know. I'd be happy to help. Have a great day!

I can read average cost via QBXML

But you cannot change the average cost via QBXML

Hey there, @EL34.

Thanks for updating us. A QBXML file cannot be directly edited, you must use the QB SDK as outlined on our Intuit Developer site. As @BettyJaneB mentioned, I'd recommend reaching out to their Support Team for further assistance editing the values in that file.

I'd also recommend contacting our QuickBooks Desktop Customer Support Team so that they can determine if a request to repair the file with our Data Services department might be necessary.

Wishing you and your business continued success in all that you do.

No one is doing that
I have been using the SDK for 15 years and QBXML

I swear, that answers I get here are answered by robots

I ended up setting up new items for all the items with the crazy Average cost
First I renamed the original item adding _old to the end ot each item
Then a new item was set up using the original name

The new items were all created by QB with the same average cost as the real cost figure
What a pain this was
Quickbooks has no idea how to manage Inventory
I also agree with everything Rustler had to say about this inventory bug on his web site here.
http://onsale-apparel.com/Rustler/warning-inventory-bug

Rustler seems to be the only person I have found that know how screwed up the average costing practice is in Quickbooks

has the same issue,

to solve it you need to the Item Receipt and Delete the receipt of item that the average cost start to change.

( you don't need to delete the PO)

the simplest way to do it is going to the purchase order and clicking CTRL+H it will show the item receipt 

and delete that item in the receipt or delete the entire receipt.

... and then save everything should balance.

Don't forget to create a new item receipt.

Sorry the rabbit hole goes a bit deeper.

so there are 3 that changes the item "average cost"

A) when you create a PO and the item is not received yet ( new items)

C) when you receive the item. --> secondery use the PO price 

B) when you create a BILL for PO --> this one seem to the that quickbook use the most if created

still digging in but people who have advance inventory might have an option with "landed cost" 

if the average cost is faulty see if it is when you created a BILL and you did not add the correct value, 

if you are sure it is an error I'd delete the BILL +  Item receipt... it will then balance out

I don't use PO's