Item Card - Unit cost not update after PO Posting

mpdevnav

Hi ,

We are using Nav 2016 and costing method is Average cost.

We have some challenge's in updating unit cost in real time that if you post any PO with Diff price, item card unit cost is not getting adjusted as per the last posted PO, unless we run the batch Job (Item cost -adjust entries, post inventory cost to G/L ) in the month end.

This leads so many adjusted entries ( Value entries, G/L ) at end of the month for the batch job process.

Refer our Inventory setup.

bostjan.les@gmail.com

You should use "Automatic Cost Adjustment", to automaticity run cost adjustment after any change in inventory that could change inventory value (like purchase invoice or production order).

Usually I set it to "Always".

mpdevnav

Thank you, let me try that option.

mpdevnav

Hi ,

I have changed to always, but still, it's not updating item card unit cost unless I ran the adjust cost -item entries and post inventory cost to G/L.

kindly advise.

rfajdiga

When you switch from never to always system doesn't adjust older entries and that is why you don't have cost adjusted.

When you switch to always and turn on "Automatic Cost posting" you need to run Adjust cost -item entries and after that, all costs will be adjusted on items and you will have a flag on it. After that, every invoice posting in PO will adjust item cost.

BR,
Renato.

mpdevnav

Dear Renato,

Thanks for your reply.

Yes, it's updating now.

I would like to know regarding adjusted entries ( Value entries, G/L ) , is it possible adjust the values on existing record instead of creating new entries.

We were using Nav 3.0 before on that its' was adjusted on existing record (values entries).

Management doesn't want to have additional entries on value entries.

please advise.