Grace,
I appreciate your help, and not trying to be disrespectful, but that is absolutely not it. I have been working with and am very knowledgeable about QBO. The issue is in ONE product, in the report that you run per product. The problem I have, for this one instance, and I have found another, is that the system is correct in how many units we sold i.e. 7, but it is only removing 1 unit from inventory and increasing COGS by 1 unit.
In the first example I changed the units from 7 to 1 and saved the invoice, then I went back and changed it from 1 to 7 and ran the report again. It changed to the correct amount, but it was split into three entries for Inventory and COGS, so it decreased inventory by 1 unit, 3 units, and 3 units, and the same for the increases of COGS. It is correct, but why it splits it up I dont know, maybe because of the 7 units sold it came from 3 bills in the system?
Then I came across another one, same problem. We had sold 2 units of a product and Inventory and COGS were only affected by 1 unit. THIS time, I had our priority support team on the phone, sharing screens, and all I did this time was change the date, saved it, went back in to change the date, and everything was correct, except this time just like the last, it split the 2 units into 2 instances of Inventory decrease, and 2 instances of COGS increase.
The support team was stumped. Of course they gave me the typical "Weve never seen this before" speech, but unless this is a BRAND NEW problem, I cant imagine that I am the only one who has said anything about this... Waiting to hear back from them on this one. I am so upset about this because in all of the problems and nuances you have to deal with when it comes to accurately tracking inventory the LAST thing you want to have to deal with is your accounting system being broken and doing something on the back end that messes up your counts.
Effectively what this is causing is us paying tax on profit that never existed in the first place and having to go back and adjust inventory in that should have been adjusted out in the first place... Will keep the forum posted on what is found here
