Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI have inventory in Quickbooks that sells at a fixed cost. We don't do assemblies. My issue is that the Profit and Loss line for Finished Goods Shipped (COG) when run in detail shows some items at 0.00 and others for over $200.00. The first should have a dollar value of about $4.22 while the second should be $8.10. I've checked the calculated average on the Inventory Valuation reports and the Cost under the Item List; both are correct. So my ultimate question is where does the P&L pull that number from, and second, why would the number change?
Any help is most appreciated. Thanks
Thanks for sharing the details with us, @captesq.
I can share with you some insights on how we can isolate this issue. Let’s start by updating your QuickBooks Desktop (QBDT) software to the latest release. This way, we can ensure your software is up to date with the latest features and security.
Outdated software causes unusual behavior that affects the performance of your software. To update it, you can follow these easy steps:
You can also see this link for more details about the process: Update QuickBooks Desktop to the latest release.
Additionally, you’ll want to ensure the date range of the report is correct. This way, we can guarantee the data shown in the report is accurate and precise. There’s a possibility that the information shown in your Profit and Loss reports is inaccurate due to an incorrect report date.
Furthermore, I'm adding this article that you can read and utilize in case you need to learn how to generate a report to show the data that matters to you: Customize reports in QuickBooks Desktop.
In case you need further assistance managing your reports in QBDT, tag me in your reply and I’ll sprint back into action. It’s always my pleasure to help and keep in working order. Have a good one and keep safe.
@JasroV Thanks, however, I did all of the above and nothing seems to have changed. It did do a minor upgrade but the error is still there. I closed and re-opened the company file after the update.
I appreciate you doing the troubleshooting steps to fix the issue, @captesq.
Let me provide few ways on how to get rid of the error. You can start to repair your company file using the Rebuild Data tool.
Here's how:
If QuickBooks doesn't find any problems, select OK. Otherwise, select Rebuild Now if QuickBooks finds an issue with your company file.
However, if the issue persists, let's repair your data using the QuickBooks File Doctor to fix your company file.
For more details, feel free to browse this article: Fix data damage on your QuickBooks Desktop company file.
Meanwhile, let me add these resources to help you manage reports in QuickBooks Desktop:
Please continue to reach out to me if you have any other QuickBooks-related concerns. I'm always here to help you out. Have a wonderful Tuesday.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.