what amount in field A is a landed cost and what amount is the selling price in field B based on both fields’ gross profits in field C?
Hi @prasanth_nair,
As per my understanding of your scenario, to calculate the amount in field A (landed cost) and field B (selling price) in ERPNext based on the gross profits in field C, you can use the formula:
LC = GP/(1-GPM)
SP = GP/GPM
where ( LC ) represents the landed cost, ( SP ) represents the selling price, ( GP ) is the gross profit, and ( GPM ) is the gross profit margin percentage. By plugging in the known gross profit and gross profit margin percentage, you can determine the amounts for the landed cost and selling price accordingly. This method ensures that the gross profits in field C are used to derive the values for the landed cost and selling price.
2 Likes