Question: Spike in Dailys report

Spike in Dailys report

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 pur

SF

Saif Fuad

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
  • MS

    Mian Saleem

    Answered
    Hello,

    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
  • MS

    Mian Saleem

    Answered
    Hello, Which product id? I can't see any product with huge cost as your modal showed it :(
  • RF

    Ricardo Flotte

    Answered
    I'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
  • MS

    Mian Saleem

    Answered
    **[Ricardo Flotte](/u/ricardoflotte)** Thank you provided your valued thoughts. I am checking this and will fix in next update.
  • Login to Reply