Hello,
We'd like to know if Acumatica offers any rebate functionality that fits the following scenario:
We purchase products from certain vendors who offer rebates on specific products when those products are sold to specific customers. These rebates can be either a percentage of cost or a fixed dollar amount, depending on the vendor agreement.
The issue we're running into is that Acumatica calculates margin on sales orders using the item's Average Cost, which doesn't reflect these rebates.
For example: if a vendor offers a 2% rebate on a product when sold to a particular customer, and that product's average cost is $10, we'd want the cost reflected on the sales order (and resulting transaction) to be $9.80 for that customer, not $10. Our sales price and margin should then be calculated based on that rebate-adjusted cost, not the standard average cost.
We're not looking to change the item's actual Average Cost record, we just want to have the order/transaction use the rebate-adjusted cost for margin purposes when the customer/vendor/product combination qualifies for a rebate.
Is there a way to configure Acumatica to handle this, whether through built-in rebate functionality, cost adjustments, or another approach?
Thank you.