The Cost Entry Validation feature allows you to be notified within an invoice if the product margin is less than a set minimum or exceeds a maximum as set by the customer. Enabling this feature can help prevent errors by recording the base cost as you receive inventory.
Navigate to Configurations > Config Page > Inventory
Workflow
To help prevent errors recording the base cost during receiving, enable the cost entry validation to be notified within the invoice if the product margin is less than the minimum or exceeds the maximum configured.
Margin % is calculated as (Price - Cost) / Price
When the margin is outside of the acceptable range, the affected invoice line’s base cost cell will be highlighted red.
When cost entry override is enabled (set to ‘YES’), a warning and tooltip is displayed on the invoice line and the invoice can still be accepted.
Disable the cost entry override (set to ‘NO’) to prevent an invoice from being accepted until the margin is within the acceptable range. Only an error message alert appears right now.
To correct the margin % calculated on an affected invoice line, either update the base cost or the retail price in the product card.
Margin % is calculated as (Price - Cost) / Price.