Purchase cost is higher than Customer price in Item Card using FIFO costing method

Business Central/NAV User Forum
1

Can anyone help me to explain why this calculation turns out to be this way : Supplier Cost is higher than Price to Customer

Was this due to multiple transactions in adjustment with the incorrect unit cost ?

Attached 2 png files demonstrated the outcome.

I am using NAV5.

Regards,

Lee

2

Hi Lee,
You didn’t include the PNG files? (you can just drag-drop them into the editor).

3

Item Card.PNG

Item Ledger.PNG
Item Ledger.PNG997×146 14.1 KB

4

Hi Lee,
That price setup looks very customized to me, there are no such fields in standard NAV. May just be the field captions, but not to say for sure. So if it is customized code, then you may be better of talking to the partner who helped build it.
But when that’s said, then messing up in the purchase costs, will also “mess” up the item cost.
What costing method are you using?

5

Hi Erik,
Thank you for your time.
We are using average costing by item by day.
I was doubtful on one of the CN that was posted before purchase receipt of 1400 that caused the net-off of quantity.
Meaning the inventory was at negative balance.
That is my wild guess.

Regards,
Lee