We are a Motorcycle parts retail shop. "Motorcycle" is categorized as an Inventory Asset in Chart of Accounts. We do not itemize the inventory, we just purchase and sell Motorcycle inventory.
When we purchase parts, it is entered as a new Expense and the Product/Service is Motorcycle.
When something is sold, it is entered as a new Sales Receipt and the Product/Service is Motorcycle.
I ran a Cost of Goods Sold for the year-to-date, and there are 100+ consecutive lines showing the same amount in the last couple months. The Sales receipts they are all tied to in the report are all different sales amounts. Previous to the last couple months, this occurred just a couple of times but only 4 consecutive same amounts. I referred back to my Sales & Expenses tabs and tried to find something that stood out as a reason, but I'm unable to figure it out.
Thanks for reaching out to the Community for support, and sharing a screenshot of your report. I can see how frustrating it can be when your reports aren't showing the correct data that you need.
To clarify, if you click one of the $318.72 amounts, the transaction that opens doesn't contain that number whatsoever? If so, I recommend clearing the cache from your web browser. Web browsers collect cache to save time when loading repetitive data and images. These files can often become outdated and corrupted, causing issues like the one with your report. I've included the links for all supported browsers that contain the steps to clear the cache below.
Correct, when I click on one of the consecutive amounts, that number is nowhere. Clearing the cache helped change the numbers, but now the repeated amount is $159.38. I'm attaching that new report here.
Currently I'm using a desktop at the office. I haven't tried downloading another browser yet.
There are also 2 to 3 repeated amounts of $3,800 here and there. I'm attaching one view of when I click into a $159.38 amount (10/22)... It's the same scenario when I open a $3,800 entry. I would attach that also but I can only attach one file at a time.
Thank you for your prompt reply, as well as sharing those PDF files for additional information.
At this point, I suggest you contact our Technical Support team for further assistance. They have the tools to remotely access your computer with your permission. Then they can investigate the root cause of the issue, along with providing a solution for it.