IM31 Assortment Items (IM31)

The Assortment Items Maintenance screen lets you assign the components for the assortment product that is maintained as AI (Assortment Item) type in Maintain Inventory Master (IM13).

An Assortment Item is a product consisting of a pre-defined group of products that are sold, packaged and delivered together.

  • Assortment Items are sold and invoiced by the piece (each).
  • They are identified at the time of sale as an assortment of items and are simultaneously thought of as both the assortment and the individual items.
  • The items are packaged assorted. The inner carton and the master carton each contain a defined quantity of the individual items in the defined ratio.
  • There is no pricing distinction between the items in the assortment. All items are priced the same. The customer buys 'the assortment'.
  • An assortment is invoiced as a single line - quantity 'XX' times the unit price, NOT as multiple lines (not as one line per item in the assortment).

An Assortment Item product is first set up in IM13 as an AI Type.

Component products are then assigned to an Assortment product in IM31 and different importance (or weighting values) are assigned to each component depending on how each component relates to the royalty calculation of the entire Assortment.

Here is an example of typical Assortment Item scenario:

  • A selection of Action Figures is set up as an Assortment Item (AI) in IM13. The single Assortment Item product code is actually comprised of a series of 'related or like items' in the following configuration: 2 Superman figures, 2 Batman figures, 1 Wonder Woman figure and 1 Hulk figure.
  • More royalties are paid on the sale of each Batman figure than on each of the other figures in the Assortment. The weighting value of the Batman figure is increased over the other action figures in the Assortment.
  • When the Assortment product is entered on a Sales Order, it does not display the component products that are attached to it. The Assortment product just references the AI Action Figures unit instead, for example the Sales Order is for 144 Action Figures
  • During the Invoice update, the Royalty calculation logic applies to the component lines rather than the Assortment Item itself.
  • When the Purchase Order prints, the component products are listed, including the UPC code from the Master Carton as maintained in PO13. In this example, a Purchase Order for 144 Action Figures lists:
    • 48 Superman
    • 48 Batman
    • 24 Wonder Woman
    • 24 Hulk

Creating an Assortment Item:

  1. In the Product field, enter the Product code created in IM13 with type AI. Following our example, enter Action Figures.

  2. In the Total Pieces field, enter the number of pieces in the Assortment. Following our example, enter 6 pieces (2 Superman, 2 Batman, 1 Wonder Woman, 1 Hulk).

  3. In the Component field, enter the Product Code from IM13. Following our example, enter SUPERMAN.

  4. Tab to the Quantity field and enter the number of items for this Assortment. Following our example, enter 2.

  5. Tab to the Weighted Value field and enter the value that is associated with this item in the assortment. This value is used in the Royalty calculation. The system calculates the percentage associated with each item in the Assortment. This percentage is used to determine the amount of Royalties to pay for each item.

  6. Click on Update to add this information to the Assortment Item. As each item is updated, the list box displays the information.

  7. Repeat steps 3 to 6 until all products are entered in the Assortment.

IM31
IM31

Other programs that are affected by these Assortment Items:

  • Schedule Invoices/Credits(IN43) - In calculating the royalty, for products that are type 'AI', the system does not calculate the royalty for the Assortment Item, but instead, calculates the royalty for the components of the Assortment Item.

    The formula for calculating the royalty for each of the components is:
    INVOICE LINE $ AMOUNT * SA05 % * IM31 %

  • Print Purchase Orders(PO42) - Immediately after printing the Purchase Order detail line for the Assortment item "Action Figures", it prints the components that make up the assortment and the number of each that will be included. In our example, when we order 144 Action Figures we know that 48 of them will be Batman.

IM31
Sample of a Purchase Order printout