Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Kit's accounts distribution and cost effectiveness of components

Posted on by Microsoft Employee

Hi,

We currently have an issue with the sales of Kits when the components are from different product lines. The distribution of the accounts in the invoice of the Kit is associated with the Class ID of the kit item, and we assign the Class ID based on the main product of the Kit (which has a different Class ID from the other components), we are not affecting the accounts of the other components, therefor the cost effectiveness of all components is being disturbed. What we need is that the invoice affects the right product lines’ accounts with the proportionate amounts corresponding to each component.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Kit's accounts distribution and cost effectiveness of components

    We've been using Fixed Allocation accounts for kits, as Heather suggested, but now we're facing a new problem: we have several variances (we often have to add/remove components from the kit) and, in consequence, the percentages of the Fixed Allocation accounts have to be updated frequently. We've come to the solution of creating different accounts and kit items for the most common settings but we now have 20 different settings and counting...

    I think the ideal solution would be a Variable Allocation account that automatically calculates the percentage of each product line based on the cost of the components of the kit item, but the examples I've seen so far for the Variable Allocation Accounts only uses units accounts as breakdown accounts.  

    Is there a third party product we can purchase to convert the cost of components to unit accounts? or could you recommend a simpler solution?

  • Suggested answer
    Patrick Lauzière Profile Picture
    Patrick Lauzière 467 on at
    RE: Kit's accounts distribution and cost effectiveness of components

    Another option could be adding all the kits items on the invoice. But this mean that the customer will have all the items from the kits and all selling price from those items on his invoice.

    To enter all those items on the invoice you maybe want using the COPY fonction from the invoice.

    For exemple, you create your kits as a Quote with Quote number like KIT_ABC_123 or KIT_BCA_321. In each Quote you add all the items of the kits.

    Instead of adding the kits items on the invoice, you copy the items from the "kits Quotes" in your invoice. You can copy as much quote as you want in your invoice.

    Positives points

    - Your account will be has you want

    - All the items from the kits on the invoice (maybe your customer want to see it)

    Negatives points

    - All the items from the kits on the invoice

    - All the selling price from the items kits on the invoice

    - Having to maintain Quotes X quantities. Quote for selling kits quantity of 1, 5, 10 or ...

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Kit's accounts distribution and cost effectiveness of components

    Hi

    I don't believe there is standard functionality in GP that would do this.  A couple of thoughts spring to mind.

    There is an option on the Kit about the Cost of Sales account - have you selected that as component item?  And does that then mean that you are getting the correct cost of sales going through to each product line?

    That then leaves the Sales value.

    What about using a Fixed Allocation account?  Now this would depend on how many kits we are talking as to whether this is feasible.  You could use a Fixed Allocation account for each kit (or each variation of value) that holds the percentage split per item.

    E.g.

    Product 1 - 20% - GL Code xxx-xxxx

    Product 2 - 40% - GL Code xxx-xxxx

    Product 3 - 10% - GL Code xxx-xxxx

    Product 4 - 10% - GL Code xxx-xxxx

    Product 5 - 10% - GL Code xxx-xxxx

    Product 6 - 10% - GL Code xxx-xxxx

    I have no other ideas that could be done with the core.  If this doesn't give the desired result, you may need to see if there is a third party product that would do it or consider a customisation.

    Cheers

    Heather

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