Sage 100

​Good afternoon,

I am working in a 2019 JobOps system and I am trying to understand why all of the "Buy to Stock" items are showing as "Items to Buy" in CEM. There are a few different scenarios (On Hand > On SO/WT, On Hand + On Unlinked PO > On SO/WT) and what I am fighting with is that the "Addt'l Qty to Buy" is directly equal to the quantities that are open on work ticket. I either have more than enough physically on hand at the moment to cover my work ticket demand, or I have open purchase order lines with a Required Date that precedes the sales order line's Promise Date, with IM Options "Include in Quantity Available" set to include On PO, and I'm still being told by this utility to buy some more. The only thing I can suggest to my clients right now is to put the line on hold indefinitely so that it doesn't get a PO cut for it, but that means that the user has to manually review every single line to double-check calculations which means hours every time they decide to regenerate selections. What am I missing here?

A colleague told me that this worked the way that we would expect to see it back in 2017 but when 2018 came out, all open Work Ticket requirements wanted a new PO regardless of current available stock levels. Is that other's understanding as well? I am having a hard time accepting this is "working as designed" because it goes against everything MRP has always calculated.

Any thoughts or guidance would be appreciated. Thanks!​

------------------------------
Amber Prayfrock, Blytheco
------------------------------

When the PO check box field is checked for a part on a work ticket, that part defaults to purchase directly for the work ticket, and that is why CEM indicates purchase. If the work ticket was created from a template or copied from an open or historical work ticket, the PO check box defaults as it is assigned in the template, open, or historical work ticket. The PO check box field defaults to checked for parts that are added to a work ticket step manually or through the import parts function when a vendor is assigned on the Work Ticket main tab. The check box may also be manually checked, which is not required to cut purchase orders directly from the work ticket, but many users believe you have to check the box.

------------------------------
John Hoyt, Co-Founder
Next Level Manufacturing Consulting Group
johnh@nextlevelMCG.com
------------------------------

John - thank you so much for the quick response. I'm glad it was as easy as that. For some reason, all of their purchase items are set to Buy to Stock but they have manually selected to buy to order for many of the items on the templates. I tested deselecting the PO checkbox on some open WT's and regenerated CEM and the items were gone. Thank you for brightening my morning!!

------------------------------
Amber Prayfrock, Blytheco
------------------------------

Original Message:
Sent: 04-29-2021 20:59
From: John Hoyt
Subject: Issues with JobOps Component Exception Manager Calculations

When the PO check box field is checked for a part on a work ticket, that part defaults to purchase directly for the work ticket, and that is why CEM indicates purchase. If the work ticket was created from a template or copied from an open or historical work ticket, the PO check box defaults as it is assigned in the template, open, or historical work ticket. The PO check box field defaults to checked for parts that are added to a work ticket step manually or through the import parts function when a vendor is assigned on the Work Ticket main tab. The check box may also be manually checked, which is not required to cut purchase orders directly from the work ticket, but many users believe you have to check the box.

------------------------------
John Hoyt, Co-Founder
Next Level Manufacturing Consulting Group
johnh@nextlevelMCG.com
------------------------------