Purchase Invoice Posting - Not hitting Inventory Account

sriram_venkat

Hi

We have a weird situation here..We are implementing NAV 2009 R2 with LS retail 6.4. The user is receiving the goods using the Retail receiving. The setup on Instore Management setup is full posting which means it will receive and as well as post the purchase invoice for the goods.

Now for certain invoices, the Inventory account is not getting updated and also the cost amount (Actual) =0 in the value entry. This is happening for some invoices and most of it is updating correctly. Due to this, the last direct cost field on item card is blank and the Average cost field on Item card is also not updated....When i navigate the Posted purchase invoice, i can see the Vendor account and the Purchase accounts are affected. The inventory account and Direct cost applied account are not updated.

The inventory setup is Automatic cost posting = ON, Automatic cost Adjustment = ALWAYS, Average cost calc type = Item, Average cost period = DAY

Any idea why this should fail?

Marije_Brummel

I would get your partner or LS Retail involved.

The options you have swiched on are not best practice on large systems and should be swiched off, repleaces by asynchronous batch functions.

sriram_venkat

HI Mark

Thanks for the reply. There has been no customization on the product and its a vanilla implementation. Then where it could have gone wrong? How can system ignore posting to Inventory account on Purchase invoice posting?

As per your email, i will switch off those options and run the ACIE and Post cost to G/L....

Thanks

Venkat