Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

Base Document Exchange Rate Copied to Target Document

SAP Business One Tips Document Exchange Rate Copied to Target Document

When you create a document on SAP Business One with foreign currency then you need to set a foreign exchange rate based on the current date exchange rate. If you create a sales order (for example), then you create an AR Invoice on different day, so your rate on invoice will be set differently with a previous rate on sales order.

If you didn’t want a different on exchange rate when copying from base document to target document, you can go to menu Document Settings (Administration > System Initialization > Document Settings)

Then, please tick on option “Use Document Exchange Rate When Copying to Target Document”
SAP_Business_One_Tips-Using Base Document Exchange Rate on Target Documenton SAP B1_01

You can see on the exchange rate table for AUD to USD

SAP_Business_One_Tips-Using Base Document Exchange Rate on Target Documenton SAP B1_01

 

Then, create a sales order with a posting date on August 6, with rate 0.68
SAP_Business_One_Tips-Using Base Document Exchange Rate on Target Documenton SAP B1_01

next, Copy to A/R Invoice

SAP_Business_One_Tips-Using Base Document Exchange Rate on Target Documenton SAP B1_01

 

So, system will automatically change rate on A/R Invoice, it will follow the base document’s rate even there’s a posting date difference.

If you not set on Document Setting, so, the rate on system will always automatically set based on current date when that document will be post.

 

Available on SAP Business One version 8.8 and higher.

, , ,