Sage 100

 View Only

  • 1.  Is there a way to enter a bill of material item on

    Posted 10-02-2017 13:23
    Is there a way to enter a bill of material item on an invoice and when the invoice is updated, have the component items relieve inventory, create the finished good item, and simultaneously relieve finished goods? What we are trying to do is eliminate Production Entry step. Sort of like phantom blow through for SO invoicing. We want to see raw material back flush, the cost roll up to finished goods, and the sale / reduction of finished goods without having to enter Production Entry.


  • 2.  RE: Is there a way to enter a bill of material item on

    Posted 10-02-2017 13:33
    You could set them up as kit bills then set the items up to Explode Kit Items. It won't put a finished good into and then relieve it but it will relieve components. You may have to play with the SO forms or you can make sure Print Components is deselected in Bill maintenance.


  • 3.  RE: Is there a way to enter a bill of material item on

    Posted 10-02-2017 13:45
    @ThereseLogeais That is what they are doing now. The issue is that they have very elaborate reporting requirements and trying to accumulate the quantity sold and cost by kit each month is very challenging. They have to report sales statistics to some big customers and vendors.


  • 4.  RE: Is there a way to enter a bill of material item on

    Posted 10-02-2017 13:58
    Sounds like you are producing reports from IM history. By exploding the kits in SO entry, you would have to pull data from AR History. A different perspective but you would still get the data it appears you need.


  • 5.  RE: Is there a way to enter a bill of material item on

    Posted 10-02-2017 14:07
    What version? In 2017, it records the sale and the COGS in the parent item. If you need to work on the reports, that's probably easier than having to do production entries. Depends on volume, of course.


  • 6.  RE: Is there a way to enter a bill of material item on

    Posted 10-02-2017 14:20
    Yet another reason to read the what's new section of the release. Multiple times!


  • 7.  RE: Is there a way to enter a bill of material item on

    Posted 10-02-2017 15:30
    Thanks. Terrific news on v2017. They are on 2014 but I just gave them a quote for an upgrade. Now they have another reason to get current.


  • 8.  RE: Is there a way to enter a bill of material item on

    Posted 10-03-2017 05:12
    @ThereseLogeais Do you know if the new 2017 recording the sale and COGS in the parent item of a kit is documented? I have the ten page What's New in Sage 100 2017 pdf and I can't find it.


  • 9.  RE: Is there a way to enter a bill of material item on

    Posted 10-03-2017 05:19
    This may have been earlier, v2016 or v2015?


  • 10.  RE: Is there a way to enter a bill of material item on

    Posted 10-03-2017 05:23
    Yep, works in 2016 as well.


  • 11.  RE: Is there a way to enter a bill of material item on

    Posted 10-03-2017 05:28
    Is this AR_InvoiceHistoryDetail?


  • 12.  RE: Is there a way to enter a bill of material item on

    Posted 10-03-2017 05:45
    No, IM_ItemWhseHistoryByPeriod. Also in IM_ItemCustomerHistoryByPeriod.


  • 13.  RE: Is there a way to enter a bill of material item on

    Posted 10-03-2017 05:50
    Thanks.


Related Content