Expected cost to actual cost without invoice

vanrofi

Hi All,

I have a customer (NAV 4.0 SP 2 BE) who has some receipts, where no purchase invoice is expected anymore.

On inventory level there is no issue, except for the inventory valuation. The cost of these lines stay known as 'expected cost'.
I understand how Navision works with these costs, so please no replies explaining why Nav creates value entries with expected cost etc...

Is there a workaround for this without changing codes, making reports, etc...?
I can of course create an invoice for these and adjust the total of the invoice to 0 with extra lines with G/L account...but I was curious on how this could be done without...


In this implementation there is no inventory integration to G/L.


Many thanks in advance!

ara3n

I don't see any way with standard Navision to do this. You have to invoice with zero Amount or modify the system.

Alex_Chow

Don't mess with costing.

Proper way (and the easiest way) to do this is to post the invoice for those receipts.

vanrofi

Putting cost to zero on the invoice is then again dangerous.
The item still has a value, even if I don't receive an invoice, I don't want to mess with my inventory value (fifo!)

So this is what I did :

I made an invoice for these lines, with a different invoice number serie, so that they can be identified as 'correction' invoices, and I added an G/L account-invoice Line to it, with the same value in negative (and same product posting groups, dimensions, etc...). This way the invoice has no value, my expected cost has become actual cost and my customer is happy!

Many thanks for helping out...regards,