Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / To reduce inventory co...
Finance | Project Operations, Human Resources, ...
Answered

To reduce inventory cost price of an item

(0) ShareShare
ReportReport
Posted on by NPriyanka 40

Hey Experts,

Is there any way out to reduce the cost price of an item from a particular month?

Our customer uses Inventory model group as weighted avg. date.

I have an item X where cost price of an item was 440 till March and from March it is 357.72 Dirhams. They wanted to revise cost price of existing stock at 357.72 dirhams per item from March.

Also, they have received credit note for the difference amount, our customer wanted to settle the credit invoice amount given by the vendor.

Month Cost price of Item Before Month Cost price of Item after
JAN 440 March 357.72

Requesting to provide a solution to resolve this issue and what must be offset account to settle the invoice amount.

Any help is appreciated.

Thanks in advance.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: To reduce inventory cost price of an item

    Hi Piryanka,

    Thanks for the update.

    Moving average costing is quite different one for the others.

    Yet, you can still adjust also those costs.

    The following post provides you how this can be achieved.

    shafeaa.blogspot.com/.../ax-2012-moving-average-costing-method_30.html

    Best regards,

    Ludwig

  • NPriyanka Profile Picture
    NPriyanka 40 on at
    RE: To reduce inventory cost price of an item

    Hi Ludwig,

    Sorry I mentioned Inventory model as incorrect it's basically Moving average.

    I am unware of the answer why they didn't choose standard cost pricing.

    I tried making adjustments from closing and adjustment form, I'm not clear in following the steps.

    1. When I tried fetching transactions from the adjustment -> transactions it does not show any transactions related to the item number.

    2. I tried from Revaluation of moving average -> edited the unit cost price and posted but there is no impact on inventory transactions. I had ran the recalculation after updating the cost price but it still shows previous value.

    Also wanted to know while posting adjustment transactions in posting form

    there is field called Specifications which has three values -> Total, item number, item group.

    May I know the impact of these 3 options.

    Thanks & Regards,

    Priyanka.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: To reduce inventory cost price of an item

    Hi NPiryanka,

    The inventory and closing workspace can help you making those adjustments.

    After you run your inventory close you can adjust prices and values as needed.

    Related to your description provided I would like to know why you are using a weighted avg date valuation principle.

    If I read your description then it sounds more like a fixed price that you have for a specific period.

    Wouldn't a standard cost pricing valuation model fit better here?

    Best regards,

    Ludwig

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,814 on at
    RE: To reduce inventory cost price of an item

    Hi

    Ax does not allow to change cost for issue trans, instead you can change received trans cost that ultimately will change issue cost.

    Navigate to inventory closing - adjust transaction to adjust purchased trans cost. then recalculate cost.

    Best regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,034 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans