Posting DMBTR and WRBTR forcefully

[former_member550384]

Hi FI people,

As an ABAPer I have a requirement , where I need to post the Document Currency AMount and Local CUrrency Amount same as coming in IDOC , ignoring the exchange rates maintained in SAP .

e.g. in IDOC

DMBTR is 500 USD

WRBTR is 1000 INR

System should post the same amount , without considering the exchange rate .

Kindly help .

Thanks,

Sachin Sharma

[frederik_weber]

Hello sachin sharma,

i am not realy sure which IDOC you actual use, but have a look at the "Currency Types".

Sometimes it is a little bit confusing to fill the IDOC correct. Make sure that you have filled an entry for every currency type you need. Often i used "Document Currency" and "Company Code Currency".

If you will fill the IDOC with both of them, the exchange rate will not check anymore.

Best Regards!

Frederik

[iklovski]

Hi,

You have possibility to introduce forced exchange rate when you post a document, whether it's done via IDOC, BAPI or manually. So, calculate your desired rate, based on two amounts, and introduce it in the document.

Regards,

Eli

[former_member191939]

Hi Sachin,

If you want to post the document other than local currency then system will check exchange rate maintained in OB08 as said by

Now if you want to post both the amounts force fully then you can give your own exchange rate  according to your file and this rate will overwrite the rates stored in OB08 and then you will achieve your desired result.

For Eg:-

In IDOC

DMBTR is 500 USD

WRBTR is 1000 INR

Then give currency as USD and rate as 2 at the header level of the document in SAP then you will get

WRBTR  required result.

Hope this solves your issue.

Regards

Eugene

[former_member550384]

Thanks for the reply , I tried this case and found out one problem ,

e.g.

DMBTR is 345.65

WRBTR is 5678.35

exchange rate would be 345.65 / 5678.35 = 0.060871555997781

SAP can have only upto 5 decimal points , so exchange rate will be 0.06087.

So SAP will calculate DMBTR as 5678.35 * 0.06087 = 345.6411645 and will post 345.64 .

So there will be a difference in both DMBTR i.e. 345.65 and 345.64 .

So how to avoid this difference in amounts.

~Sachin Sharma

[former_member191939]

Hi Sachin,

If you give your own rate and then you give FC and desired Local currency then you will get your desired result.

For Eg.

DMBTR is 345.65

WRBTR is 5678.35

Exchange rate would be 345.65 / 5678.35 = 0.060871555997781

SAP will calculate DMBTR as 5678.35 * 0.06087 = 345.6411645 and will post 345.64 .

So give  DMBTR i.e. 345.65 and system will overwrite the calculated DMBTR of 345.64 and you will get the desired result.

Means give your calculated rate your DMBTR and WRBTR.

Hope this helps you.

Regards

Eugene

[former_member550384]

It is not posting the same amount .It is posting the calculative amount i.e.345.64

[former_member191939]

Hi Sachin,

I did the posting in sap and it allowed me to post.

I do not understand why it is not happening in your case.

Regards

Eugene

[former_member198650]

Hi Sachin,

If you post the document other than local currency, then system will check exchange rate maintained in OB08 and use it to converting it in local currency. If you want to post in same amount, then use local currency as doc.currency.

Regards,

Mukthar

[former_member550384]

Hi Mukthar,

I want to post like as below :-

Amount 500 USD as Document Currency

and

Amount 1000 INR as Local Currency

Changing the Local currency to Document currency will not work.

~Sachin