SF
Asked
Dear Brother,
good day, i just noticed that there is a spike in the daily sales report.
The spike shows a huge amount in the products purchased cost.
I cheeked all the products cost and purchases there is not such thing, any idea what to do next ?
Regards,
Saif
good day, i just noticed that there is a spike in the daily sales report.
The spike shows a huge amount in the products purchased cost.
I cheeked all the products cost and purchases there is not such thing, any idea what to do next ?
Regards,
Saif
Attachments
- MSAnsweredHello,
That's really big number. You can check the `sma_costing` table and see which product_id caused this. Then can investigate that product.
Thank you - MSAnsweredHello, Which product id? I can't see any product with huge cost as your modal showed it :(
- RFAnsweredI'm having the same problem, the issue is caused when the purchase unit is not a base unit, the costing table records the wrong cost, it's not converting the cost to base unit, so when the daily sales shows the products cost it shows a big number because it's multiplying wrong numbers,
for example:
I purchase a dozen eggs for $12 ($1 a piece), so when i sell those eggs, the sma_costing table registers 12 in quantity and $12 in purchase_unit_cost, but the purchase unit cost should be $1, by the way the sales unit cost is registered correctly.
So what the daily sales profit shows it's 12 eggs multiplied by $12 = $144 products cost, when it should be $12.
Please fix this - MSAnswered**[Ricardo Flotte](/u/ricardoflotte)** Thank you provided your valued thoughts. I am checking this and will fix in next update.
- Login to Reply