web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Spareparts consumption...
Microsoft Dynamics NAV (Archived)

Spareparts consumption entries

(0) ShareShare
ReportReport
Posted on by KONSPEC ERP 129

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

I have the same question (0)
  • 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)

  • Suggested answer
    Community Member Profile Picture
    Community Member 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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans