...
Create a new view variant "Product unit review" on your price book list view
| Expand |
|---|
|
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
| Note |
|---|
[Product] Is Not Null And [Product.Default Sell Unit.Quantity] <> 1.0m |
| Expand |
|---|
|
Add a report footer to your report and count the number of rows
| Expand |
|---|
|
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
| Expand |
|---|
|
| Expand |
|---|
|
Add
...
From product.primary product supplier, add:
- Cost price 1
- Default buy unit
- Supplier
| Expand |
|---|
|
Add some conditional formatting to highlight the products that can be actioned using OB sell units
| Expand |
|---|
|
Your list view on the price book should look like this:
| Expand |
|---|
|
Add some conditional formatting so you can see the products you can address using the Office Brands units