re-adjust inventory costs

(0) Share

Report

Posted on by Community member

Hi,

We sometimes get a sum of money from a vendor to put against an item to bring the cost price down, is there a way to handle this in BC. I have seen charge items and that's fine against a full PO but we want to apply a cost adjustment against just the items in stock and post a purchase credit menu to a ledger.

Example

Item A

Unit Cost £100

Costing method = Average

Qty = 20

item A costs £100 been buying and selling for over a year, but sales over the last 6 months have slowed down so we speak to the vendor who offers a sum of money to bring the costs down to help us sell them.

Vendor gives us a credit for £400 which we want to apply to bring the Unit Cost down to £80 each.

This is just for current stock not previously posted sales invoices.

Thanks

Categories:

Business Central

All responses (1)

Answers (0)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

re-adjust inventory costs

For this you will have to use item revaluation as i describe in my blog article here:

Item Revaluation In Microsoft Dynamics 365 Business Central • Business Central Explained (bc365.co)

Then you will have to manually post a creditmemo through a journal against the vendor or through a purchase creditmemo posted to a G/L account.

You could also assign an item chare to part of a purchase receipt as described here.

https://learn.microsoft.com/en-us/dynamics365/business-central/payables-how-assign-item-charges?WT.mc_id=email&sharingId=DX-MVP-5005315

But the revaluation method might give you better control over what is going on.