Margin is getting Updated on change of Currency Exchange Rate

[venkat102]

Information about bug

When the user creates a sales invoice from a sales order, the item Rate of the Sales Invoice Item updates when the Currency Exchange Rate Changes, for items that had a Price List Rate on the Sales Order

To reproduce the issue follow the below steps:

1. Create items and add item prices to each item (either manually or through the Auto Insert Check box on the Stock Settings)

2. While creating a sales order, for example, if the item "iPhone 15" has an item price of 100 USD, but the user enters the price as 105 (Margin Amount = 5 USD, since Item Price is 100 USD), and for other items, the price remains the same, then user submits the sales order.

3. The user creates a Sales Invoice from a Sales Order by clicking on Create > Sales Invoice.

4. Before saving the sales invoice, the exchange rate does not update automatically (by default it takes the exchange rate from the sales order). To update the exchange rate, the user must first save the document and then either change the date or change the exchange rate manually on the Sales Invoice

5. The main issue arises when the appropriate exchange rate is fetched. At this point, the item rates are also updated (because the Margin Amount is being converted for Multi-Currency, please note the Document is in USD, and the Company currency is INR).

However, the item rates need to remain the same as they were in the sales order and the Rates are finalized in USD with the customer at the time of Sales Order creation.

Module

accounts

Version

Frappe: Version-15
ERPNext: Version-15

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response