PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

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.

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , ,