Sounds like you have set up two items, one for each UPC code.  The program does allow you to use one code for the product and set either by the case or by the unit.  In fact, you can buy by the skid, stock by the box and sell by the unit in the program.  This would be the ideal setup based on how the program is designed because it allows for reporting in each unit.

However, if you have it set up to us the case UPC and don't have the unit UPC when you sell, then you have to find it, which can slow down data entry.

To get your units and cases with two item codes, reporting under one, you will have to implement some custom reporting of some kind.  Eg.use one of the Additional Info fields to link the same products together and dump to Excel and merge the reporting using the features of Excel to combine the quantities.  There are other ways of doing it but they all require customisations outside of Sage 50.

As far as I know, there is no way to combine the reporting of two item codes together within the program.  The program is design such that two different item codes are two different items.

However, you could theoretically receive the product in by the most salable unit.  eg. you do more sales by the case than by the unit.  Then use item assembly or builds to split a case when you wish to sell by the item.  This would keep most of it under one item code until you sell, then you only move roughly the amount to be sold to the other unit.

Thanks, Richard.

Thanks, Richard.