KP Administrator Cost Kits From Components Report overview

Kit Production > Administration > KPA Reports > KPAC

Function acronym: KPAC

Use this report to combine individual component values to determine the same values for the finished kit product. This process is called rolling.

On the report, you can select theses types of values to roll:

  • Costs
  • Addons
  • Surcharge
  • Prices
  • Weight
  • Cube

The Product Warehouse Product Setup and Product Setup records for the kit are updated with the rolled values. To roll base or list prices, the Price field in KP Component Setup and KP Group Setup must be selected. The price for each component is multiplied by the unit conversion quantity and added together to determine the price of the kit. If the Price option is not selected, the record is skipped.

If a kit exists in multiple warehouses, the rolled detail is calculated independently for each kit and warehouse that fall within the specified ranges.

If a component has a variable quantity, the quantity from KP Component Setup is used in the calculation. If a component is not required, it is rolled. If a kit has options or keywords, the options and keywords are not included in the calculation. You must manually adjust the default values that are used in the calculation.

These conditions must be met for a kit product to be rolled:

  • The kit product and components must be active products in Product Setup and Product Warehouse Product Setup.
  • The kit product must be a build-on-demand or prebuilt kit.
  • Components cannot be a core charge or a build-on-demand kit.
  • Units must be valid in Product Extended Unit Conversion Setup or SA Table Code Value Setup.

If your kit components consist of special cost types, the associated cost or price is converted before it is rolled. Unit conversions are based on the records in Product Setup, Product Extended Unit Conversion Setup, and SA Table Code Value Setup. To roll the components' weights and cubes, you must select the associated options.

When you roll costs for a dirty core component, market cost is used instead of the cost that updates the General Ledger. The market cost is specified in SA Administrator Options-Products-Cost.

This report also updates the dates that are associated with these values in Product Warehouse Product Setup-Costs for the kit product:

  • Replacement
  • Standard
  • Price change

If a component meets one of these conditions, KPSK Sequence # is Invalid, Kit not Rolled is displayed on the report, and the kit is not rolled:

  • The component is a Do No Reorder product.
  • The component does not have a Product Warehouse Product Setup record for the appropriate warehouse.