US - Texas (Dallas/Fort Worth)

Expand all | Collapse all

Kit and component sales reporting

  • 1.  Kit and component sales reporting

    Posted Oct 23, 2018 10:41 AM

    We use kits from time to time and the issue comes when reporting on Sales using the Analysis Cubes or even a smartlist.  The kit reports sales and cost but the component item only reports cost, it does not receive credit for the sale when it is a kit.  If the component is sold by itself reporting shows the extended price and extended cost.   Here is a sample of the Sales Analysis Cube, note the -252% GM of the component and the positive GM of the kit.

    Here is the result of using the drill through for sales detail, row 5 is sale of the component item by itself, the others sold as part of a kit.

    I am not sure if we have something set up wrong in the distributions, or when setting up the kit, we select cost of the kit from components, or if there is a problem somewhere else.  If anyone has run into this before I would appreciate some insight.  Kits are much faster for order entry and picking in the warehouse.

    Michael Sumner
    IT Manager
    Nation's Best Sports
    Fort Worth TX

  • 2.  RE: Kit and component sales reporting

    Posted Nov 06, 2018 04:32 PM
    Hi Michael -

    I take it you're using the manufacturing module correct?   We have several chapter members who use the manufacturing module who might be able to help. @Keith Paul or @David Flowers​ are you both using manufacturing​​​ and does Michael's issue sound familiar?

    Sean Reynolds
    IT Accounting Manager & MS Dynamics GP System Administrator
    MIC Global Services
    Plano TX

  • 3.  RE: Kit and component sales reporting

    Posted Nov 07, 2018 08:51 AM
    Nope sorry, can't be much help here. We don't use Manufacturing or Analysis Cubes.

    David Flowers
    System Admin -GP and Salesforce Support
    RMG Enterprise Solutions
    Addison TX

  • 4.  RE: Kit and component sales reporting

    Posted Nov 07, 2018 12:55 PM
    We have used kits, but have not used the Analysis Cube.  My understanding is that Manufacturing is not required to use kits.

    Your price is based on the kit. Your posting of CoGs is based on each of the component items  per your settings.  We have this similar set-up.  Reviewing the actual distribution reveals that CoGs are only posted once.  However, price comes from the kit. the components will not have a Sales Price for the sales generated by the kit as you noted.

    So this appear to be more of reporting issue, possibly driving the need to segregate individual sales from those generated by the kit. Profitability by component based on the kit sales would require an allocation of price from the kit to each of the components in the kit.   Depending on your Sales Order Processing set-up, your price for the kit  may be calculated based on the component cost or set separately.

    I'd recommend the following:
    • Confirm that your distribution accounts  are posting properly to the GL based on spot checks of actual sales using the GUI .  They should be based on what you've described.
    • Understand how pricing is being set for kits in order to determine how to allocate the sales price to the components sold resulting from the kit sales.  Then determine margin for components sold in kits, components sold separately and then combined ; this requires different reporting.  

    GP Inventory and Sales Order Processing  documentation address this:

    Quantities aren't tracked for items you designate as kits. However, current costs are associated with the items associated with the kit, and the quantity sold is tracked when these items are used at the time of sale. When you post a transaction that contains a kit item, amounts are posted to the Cost of Goods Sold account specified-you can choose to use the Cost of Goods Sold account for each component item in the kit, or a separate Cost of Goods Sold account defined for the kit itself.

    Calculate Kit Price Based on Component Cost If you're using a percent markup or percent margin pricing method and you mark this option,
    the current or standard cost of the kit components will be used to calculate the total cost for the kit. The percent markup or percent margin will be calculated on that cost.

    Hope this helps.

    Keith Paul
    VP Business Management Systems
    UNICOM Engineering, Inc.
    Plano TX

If you've found this thread useful, dive deeper into User Group community content by role