Sage 100

 View Only
  • 1.  Exploding Kits on SO, but seeing parent item on SO in IM Inquiry - Sage 100 v2016

    Posted 12-09-2021 09:10
    Any solutions?  I am not seeing any settings.   Will be migrating to v2021 in January.

    Long time user question - Someone orders an assembly that we don't have in stock, so we "explode" the assembly on the order for the warehouse to build but when we go to Mas under the assembly number it does not show we have these on order.  How do we correct this?   The order is pulling parts when we explode and nowhere is the assembly number, so it does not appear that they are on order which is a big problem.



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: Exploding Kits on SO, but seeing parent item on SO in IM Inquiry - Sage 100 v2016

    Posted 12-09-2021 09:40
    If they don't explode the assembly in order entry, I assume the assembly shows on order?  Then the whs has to go through the process of building the assembly to fulfill the order?  

    --
    Randy Marion * Software Systems Engineer *






  • 3.  RE: Exploding Kits on SO, but seeing parent item on SO in IM Inquiry - Sage 100 v2016

    Posted 12-09-2021 09:49

    Jeff,

    What they are seeing is working as designed,  If they explode the kit, Sage is creating the "on SO" for the Component quantities, and is expecting the warehouse staff to pull the components during the shipping/picking process. If Sage also created demand for the Kit item, it would essentially be doubling up the demand.  

     

    Do they have bill of materials also?  Are they building the kits and putting them on the shelf for shipping later? If so, I would have them answer NO to the question on exploding the kits so the warehouse can see the demand for the kit and build it. Shipping would then pick the completed kit item from inventory.

     

    If they don't use BOM to build the kits, and they just need to see the demand for the Kit items after exploding. I think a custom report from SO Detail to show all kits on order might be the better answer.

     

     

     

    Do you need a Sage 100 year-end processing refresher?

    Join us Dec 16th at 1:00pm to learn tips to prepare for year-end.  Reserve your seat today!

     

     

    Thanks

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     






  • 4.  RE: Exploding Kits on SO, but seeing parent item on SO in IM Inquiry - Sage 100 v2016

    Posted 12-09-2021 10:10
    Perhaps this

    During data entry when a kit item is 'exploded' resulting in the kit's component items being added to
    the order or invoice, the following processing changes take place:

    The Sales Kit Item Line is handled according to the Kit Item Retention method noted in Setup.

    • Retain Kit as Special Item: A special item (* followed by the first fourteen characters of the Kit's
    Item Number) will be added to the Sales Order at the position where the Kit Item was deleted. The
    special item's description will consist of the Kit Item's description from the Inventory Masterfile.
    The Price and Cost fields will be set to zero.

    • Retain Kit as Discounted Item: The Kit item will remain on the order after explosion, but 100% will
    be placed in the Line Item Discount field. This forces the Extended Amount to equal zero, but
    leaves the Unit Price value unchanged.

    Retain Kit as Regular Item: The Kit item will remain on the order/invoice with its Unit Price and
    Extended Price. Items that were once components will have their Unit Prices set to zero.

    • Retain Kit as Non Discounted Item: The Kit item will remain on the order after explosion and no
    changes will be made to the discount field. The Unit Price and Extension will remain unchanged.
    Items that were once components will also have Unit Prices

    • No Kit Item Retention: The Kit item will be removed from the Sales Order.
    The original component items are no longer components lines of a sales kit, they are now standard
    Inventory items. During Sales Journal update every Inventory line's Sales Order Invoice value for
    'Std/Kit Bill' will be copied to A/R Invoice History.

    https://www.dsdinc.com/enh/downloads/S068700.pdf

    ------------------------------
    Wayne Schulz
    Schulz Consulting
    860-516-8990
    ------------------------------