Sage 100

 View Only
  • 1.  MAS 90 user sells small parts. These are packaged

    Posted 02-03-2012 13:39
    MAS 90 user sells small parts. These are packaged into packs. Quantity per pack varies by both customer and the inventory item. Best practice to handle this short of creating a few hundred obtuse UOM conversions?


  • 2.  RE: MAS 90 user sells small parts. These are packaged

    Posted 02-03-2012 14:57
    I've seen add on modules (maybe EDI) that hold a CasePack in each inventory item. Maybe you can borrow that idea and put a UDF CaseQty in each item. Then add that UDF into Sales Order entry along with a UDF for NumberOfCases. Then add a script to the PostVal or each of these UDFs where QtyOrdered = UDF_NumberOfCases * UDF_CaseQty.


  • 3.  RE: MAS 90 user sells small parts. These are packaged

    Posted 02-03-2012 15:17
    Could a customer order an item with different pack counts?


  • 4.  RE: MAS 90 user sells small parts. These are packaged

    Posted 02-03-2012 15:18
    Are there default pack sizes?


  • 5.  RE: MAS 90 user sells small parts. These are packaged

    Posted 02-03-2012 16:39
    Thanks - from what I understand for a particular item we may package it into a UM referred to as a ""Pack"" with varying quantities. For example customer AA may order item ABC in a pack - where the pack holds 10 items. Customer BB orders the same ABC but a pack holds 25.


  • 6.  RE: MAS 90 user sells small parts. These are packaged

    Posted 02-03-2012 17:40
    This sounds like a job for a UDT and scripting.


  • 7.  RE: MAS 90 user sells small parts. These are packaged

    Posted 02-06-2012 07:05
    Sounds like each Qty pack to me is a different SKU (I.e., ABC10 and ABC25) why go down the road of customization if this is an inherent process. I see a lot of potential problems with costing if they don't do it this way. They could also use Bill of material to record outside processing or internal labor associated with making these pack configurations, and to print labels to put on packs if required.


  • 8.  RE: MAS 90 user sells small parts. These are packaged

    Posted 02-06-2012 08:04
    Instead of Bill of Materials it could also be done using exploded kits.