Check to see if an Office Brands unit is available
Create a new view variant "Product unit review" on your price book list view
Filter your list view to only show price book entries where the product is not blank
Right click on filter editor and paste the following filter into the filter editor
[Product] Is Not Null And [Product.Default Sell Unit.Quantity] <> 1.0m
Add a report footer to your report and count the number of rows
Add the following fields to you list view:
- Default Sell Unit Code
- Sell Unit Quantity
- Fixed sell 1
- Then from product add
- Product.OB Sell Unit Available
- Product.Use OB Sell Unit
- Product.defaultsellunit
- Product.defaultsellunit.code
- Product.defaultsellunit.quantity
- Product.ignorebuyunitandcost
- Product.Ignorecataloguesellunitand price
- Product.Quantityonhand
- Product.Quantityonhandysellunit
From product.primary product supplier, add:
- Cost price 1
- Default buy unit
- Supplier
Add some conditional formatting to highlight the products that can be actioned using OB sell units
Your list view on the price book should look like this:
Add some conditional formatting so you can see the products you can address using the Office Brands units