I am currently facing an issue with my inventory profit margin report and would greatly appreciate your assistance in resolving it.
Here are the details of the situation:
On 20th January 2025, I recorded a purchase invoice for 3,240 items at a unit cost of 35,000 shillings, resulting in a total cost of 113,400,000 shillings (as shown in the attached screenshot).
On the same day, I sold a portion of these items, generating total sales of 1,715,000 shillings (as per the attached screenshot).
However, when I navigate to the Inventory Profit Margin Report, the entire 113,400,000 shillings from the purchase invoice is being reflected as the cost of sales. Additionally, the sales value is being calculated as 113,400,000 shillings + 1,715,000 shillings = 115,115,000 shillings (as shown in the attached screenshot).
To troubleshoot this, I have already tried the following steps:
Restarting the cloud server.
Using the Recalculate button in the inventory items section.
Unfortunately, these actions did not resolve the issue. I am currently using version 25.2.5.
Could anyone kindly advise on how to address this issue?
Have you recorded purchase invoice on the same date. It is purchase invoice amounts which shows up to the inventory profit margin. Please note the following paragraph from my explanations . However, when I navigate to the Inventory Profit Margin Report , the entire 113,400,000 shillings from the purchase invoice is being reflected as the cost of sales . Additionally, the sales value is being calculated as 113,400,000 shillings + 1,715,000 shillings = 115,115,000 shillings (as shown in the attached screenshot).
Show your Inventory Items Tab and Sumary Transaction of Cost of Good Sales.
Make sure you have click Recalculate button in Inventory Tab.
Also check your Inventory Item Valuation method. i use FIFO for this test.
Go to Summary and then Inventory Cost and click Recalculate for both opening and closing inventory. Click it a few times as sometimes it is needed if you are using production orders. Also make sure the period selected on Summary Tab covers the period selected on Inventory Profit Margin Report.
Hi- Did you figure this out? I have the exact same thing.
It may have to do with the Sales Receipt form and the checked items (If uncheck unit price, then the report values change; but then sales = inventory cost and inventory cost is accurate and profit =0)
It may have to do with FIFO and the fact that these transactions include the same items but at different prices
In my case I do not have any opening inventory
Somehow the report calculates Sales = inventory cost + profit. Inventory cost is accurate
Hello I have issues with the inventory profit margin report.
The value sales under sales is different from the sales of the period defined
The value of Cost of goods sold does not reflect the cost of sales for the items
The the profit instead equals the sales value for the defined period
This issue is being highlighted since the day developer started to play unnecessary with the inventory starting balance. From then onwards we have inventory items related issued in one way or the other.
Perhaps its now beyond developer to handle it. Unfortunately, we have to live with it…
