Sage 100

Question related to the ""item pricing by total quantity"" feature in 5.x if anyone has ever implemented this: is there any way to exclude items/product lines form being included in the calculation? Client had a custom enhancement back in 4.20 that did the total pricing but allowed for exclusions, and we're trying to get to a vanilla system now if possible. Thanks in advance for any thoughts!

Hi, Amber. I've implemented this in what sounds like the same scenario. Name one of the four Inventory Categories. All items that are included in that category for pricing discounts would have one answer (perhaps INCLUDE) and for the other items leave it blank. When the process is run, it will group all items in a single category (INCLUDE) together to do it quantity calculation. Once it calculates the total quantities for INCLUDE items, it then looks at the price codes for each individual item to come up with each individual item cost. Is this what you're looking to do? For my customer, we had an inventory group for TINS, for PLASTICS and blank. It's been over a year since I've done this, so I hope I remember correctly.

Aha - so it will ignore blank values instead of rolling those up separately? I will try that shortly! Thanks!!

I'm pretty sure ""yes,"" it ignores blanks. If not, just enter the item ID for items you don't want to include, so that you don't have any duplicates, but I think it just ignores blanks. I'm leaving shortly and wanted to get you an answer before I left and didn't have time to test, which is what I usually would do.

No, that's beautiful, Roberta. I like that trick about the category value the same as the item code too!