Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

NAV 2009 R2 - Accounting for parts/labour cost associated with warranty jobs?

(0) ShareShare
ReportReport
Posted on by 135

Hello,

I was wondering if someone might be able to help me regarding a desire we have to better account for our costs of warranty.

Our current situation is we have a provision for warranty costs on our balance sheet which is calculated as a percentage of our sales figures for the previous 12 months. We then post any movement to our P&L for the month.

We would like to use Navision in order to record a much more accurate cost every month which takes into account the cost of providing the parts and labour directly related with warranty and post this to a separate warranty g/l in our cost of sales.

On looking at what happens now, I notice that whenever we post a service invoice for a warranty job (this may be either a zero value/free of charge dummy invoice or a purchase invoice for whichever amount), the cost of the parts is transferred from inventory to the regular cost of goods sold account. There is no journal for labour costs. We do use a service management element within NAV 2009 R2 which handles all our service invoicing. When the warranty invoice is raised, there are line items for parts and labour however this information doesn't seem to be associated with the cost of these.

Ideally, we would like Navision to post the cost of the part, if this is a warranty job, to the warranty g/l code (not the COGS account as with other non-warranty parts) and also to post an entry for labour cost (perhaps based on a standard cost per hour depending on how long is spent on the site). Obviously the possibility of double counting labour costs would need to be avoided as these would have been already posted to overheads. Also, labour costs would be originally posted to more than one g/l. i.e. pensions, national insurance as well as overheads like the cost of running the vehicle).

Would anyone please be able to tell me if this is possible?

I've looked into the service management part of Navision but I cannot see how the item and resource codes can be used to calculate the cost of warranty.

Any help or advice would be greatly appreciated.

Thank you,

Jennifer

*This post is locked for comments

  • jenniferyoung Profile Picture
    jenniferyoung 135 on at
    RE: NAV 2009 R2 - Accounting for parts/labour cost associated with warranty jobs?

    Dear Saurabh,

    Thank you very much for your very helpful reply.

    I will look into the Gen. Prod. posting group as you suggested, this would solve the issue with regards to where the costs of the parts are being posted.

    However, unlike for parts, there is no entry currently being made for labour.

    For example, if we have a free of charge service invoice raised for a warranty job, there is a resource line for labour and an item line for the part(s) however only the cost of the part is actually posted to the general ledger. We don't currently account at all for the cost of the labour.

    What would be ideal is that when we post the service invoice, a journal entry is made for the cost of the part (from inventory to warranty costs as you describe) and an entry made which posts the labour cost based on a standard rate times the amount of time specified in the resource line (on the service invoice).

    My guess is that this would be complicated further by the fact we don't use standard costing otherwise and also that we would effectively double count the labour costs as we would have already posted them to overheads.

    It's just that right now, we don't account for labour in warranty jobs, the only way I can think of is that we manually enter an allocation posting from overheads to warranty costs and this wouldn't be very practical. If we could have Navision do it automatically then that would be far more useful!

    I hope I have made more sense in what I am looking to do. Any further advice you may have would be much appreciated.

    Thank you again,

    Jennifer

  • Suggested answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: NAV 2009 R2 - Accounting for parts/labour cost associated with warranty jobs?

    Hi,

    As I understood, Correct me if I am wrong. You want to post the value in separate GL account if the posting is under warranty. if this is the case then you can create a new Gen. prod. posting group like "Warranty" and create the setup in Gen. Posting setup where you can select the Warranty COGS GL account against it.

    If you want to fix this on item and resource (if it is predefined as warranty items or resources or GL) then you can select the product posting group on the respective card and if it is not possible to select in the master then you select this against the each service line. there is a field available in service line so you can do choose column and pick the Gen. Bus. posting group and Gen. Prod. posting group so if the service order is a warranty order then you can modify the existing Gen. prod. posting value in line so when you post that order for invoice. it will post into warranty COGS account which you have defined in Gen. Posting setup.

    Let me know if you still need any more information on this.

    Regards,

    Saurabh Shah

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans