Sales invoice margin discount as per customer

This discussion explores how to automatically apply different margin discounts to sales invoices based on the customer. The goal is to have the system calculate the correct supply price (e.g., Rs 75 for a 25% margin on a Rs 100 MRP product) for each customer without manual intervention. Users are seeking detailed instructions on setting up formulas, potentially within accounting software or spreadsheets like MS Excel, to manage these customer-specific pricing rules.