Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Spareparts consumption entries

Posted on by 125

Hi

We procure store items and spare parts for different warehouses and maintain a Minimum stock level of these items.

Procedure:-PO-> warehouse receipts->Purchase Inv, simultaneously physical stock & Inventory value is updated.

Whenever there are any machine (FA) breakdowns, the maintenance team will replace the faulty spare part available at particular warehouse or via the stock transfer.

Now kindly provide me a solution to post the consumption entry for those replaced spares.

The inventory stock & value of that spare part should be will be decreased. The consumption value along with fixed assets code has to accounted under machine maintenance expenses (Operational expenditures).

This has to be without carrying out any item journal +ve or -ve adjustments.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Spareparts consumption entries

    Hello,

    You are trying to consume spare parts for your own equipment, which are Fixed Assets. I know if you had an EAM (Equipment Asset Maintenance) Addon the consumption of Spare Parts Inventory during Maintenance Work Orders, are reduced and tracked. Since I am guessing you do not have an EAM addon, what I teach my customer to do is to record an Item Journal, type Sale. Enter the Quantity and 0.00 Unit Price. When you post, it will reduce Inventory and book the Cost to the COGS GL Account on the GPPG General Posting Setup for the Item. Since you are using internally, you can enter a GL Account for operational expenses.

    Thanks,

    Steve

  • meelan Profile Picture
    meelan 5 on at
    RE: Spareparts consumption entries

    Hi

    Were you ever able to find a solution for this? 

    We have been using G/L accounts in the P.O for these and whenever invoice posted, the ledger is updated and no inventory held.

    But, now new finance head wanted to change this. Wanted to maintain inventory and consume as and when they are issued for use. (This includes spare parts, cement and many consumable items)

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans