cancel
Showing results for 
Search instead for 
Did you mean: 

How to change exchange rates in sales documents?

SAPSupport
Employee
Employee

There is an issue with the exchange rate that is picked up by the system during billing and we would like to change the exchange rate in the sales document. Could you help how the exchange rate can be changed manually to resolve the issue?

The exchange rate determined by the system is through a triangulation method where SAR/EUR and EUR/USD is maintained and system derives SAR/USD rate automatically. The issue occurs when we use a "Time and Material" contract type projects where cost postings are in SAR and the billing is done in USD.


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee

1) 102762 - Define Copying Control for Sales Document to Billing Document

Here you can configure how data is copied from billable reference documents to billing documents.

In this configuration activity, you can modify how data is transferred from billable reference documents (sales documents, deliveries, and existing billing documents) to newly created billing documents. By using custom data transfer routines to manipulate specific header and item fields during the copying process from reference document to billing document, you can force invoice split or consolidation. You can also modify key attributes such as the pricing type, pricing source, and exchange rate type. In addition, you can update or clear a range of standard fields and any custom fields that have been added through extensibility.

2) Changing the exchange rate

Go to Manage Sales Order app, choose the required sales order, click on "Change" at the top then select item conditions, and billing document tab. Here the Exch.Rate Acct. can be found. This field is responsible for the following:

Exchange Rate for Postings to Financial Accounting

Specifies the currency exchange rate between document currency and local currency.

When a billing document is posted to financial accounting, the system also forwards this exchange rate to enable subsequent processing.

Usually, the system uses the billing document's billing date as the exchange rate date for determining this exchange rate. If, however, the exchange rate has been set as fixed (indicated by the Set Exchange Rate field), the exchange rate of the preceding sales or billing document (for example, the sales order) is used instead.

Answers (1)

Answers (1)

former_member132121
Active Participant

I have seen the exchange rate being determined based on maintained in the Currency exchange rates app. The manual way to change the exchange rate is in Sales order located in header details under sales tab>Pricing and statistics.

Thank You,

Nidhi