• From: USA, Colorado
  • Registered: 07/19/2018
  • Posts: 25

Topic: COGS inflated

I have received 5 orders through the PO module and all devices for this inventory unit were entered at a cost of $28.

When I look at my G/L the COGS per unit on that item is $46 recently.

It was running smoothly at $28 for 2 months and suddenly it started with this new COGS.

I know that the system would use a LIFO or FIFO or Average cost method for COGS but all 5 orders were same price.

Any ideas why this happened???

scott.randall's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,182

Re: COGS inflated

There are some cost update entries  in it. Which are all related to the abnormal price change there. And also in the decimal points, if you have exponential in the decimals. It's calculating wrong cost , that's leads to this problem..

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: USA, Colorado
  • Registered: 07/19/2018
  • Posts: 25

Re: COGS inflated

How do I find "cost update entries" that are adding to my $28 for the device?

scott.randall's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: COGS inflated

There are a total of 93 fields(en_US-new.sql) that re "double" type that are good for binary base computations that mess with decimal computations where a decimal field type should have been used. But this should not create such a huge difference unless an additional mess with signed and unsigned field type attributes are in the same expression.

Post's attachments

MySQL Float vs Decimal field types.pdf 76.7 kb, 2 downloads since 2021-03-12 

You don't have the permssions to download the attachments of this post.

apmuthu's Website