Summary
When you run your monthly California Material Report you might have duplicate lines for the same material used in the same county.
Key Points
The duplicate materials have different dilution rates applied
Update the material default dilution rate across all Work Orders
This happens when different dilution rates are used on the same material. For example, you might have two lines of Contrac All Weather Blox where:
One line lists all the dilution rates that used None
Another line lists all the dilution rates that used 0.
The dilution rates need to be the same to eliminate duplicate lines. The easiest way to do this is to update the material default dilution rate across all Work Orders.
To do this, follow the instructions in Bulk Update Materials - Update incorrect entries for your Materials reports.