Skip to Content

Foreign currency valuation about Sales order in foreign currency

Hi all:

We have foreign currency issue. In our company, local currency is TWD.

About Sales, most of cases we use to quote in USD and got paid by customer in TWD.

Now sales person key in sales order(Billing->Act Doc) using currency USD and it works fine, but finance are complaint about "foreign currency valuation" because there are too many sales docs no need to be valuate but it existed in foreign currency valuation(FAGL_FC_VAL).

I know we can exclude those docs which we don’t want to valuate in FAGL_FC_VAL, but there are too many docs, so it need a add-on program to do it and the rule is not clear ...

**

We have tried to change sales order's header currency as TWD and net price in items remain USD.

But sales person (&customers) are expected the total amount in TWD should be ( "total amount in USD" multiple "exchange rate" ) and as we know total amount in SAP is summarized ( Item’s net price in USD * exchange rate * quantity). So there is some difference after transfer as local currency.

And in our business, there are more than 10 items per sales order and the net price (USD) include decimal, so the difference in total amount will be more than 10$ in local currency per doc.

**

Any suggestion about this case?? Standard or customized are welcome.

Is any enhancement can be use while billing released to act doc?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • May 15, 2015 at 01:31 PM

    You should be aware, any FI postings from SD billing document on exchange rate, would be based on VBRK-KURRF. If the user key in manually in Sale Order from top menu bar Goto -> Header -> Accounting (VBKD-KURRF), then it is copied into VBRK-KURRF; else, it would be determined from transactions like OB08, OB22 etc.,

    Nevertheless, you need to discuss with your FI team who have to look into this requirement.

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • May 16, 2015 at 04:38 AM

    If Your requirement is All the sales Docs should be in TWD-Then What About your Customer Master settings(XD02>>>Sales Area data>>>Currency in sales section..(Then checking at OB08 level)

    Dear Lakshmipathi sir,

    Interested to know-in which business scenarios-System has to carry different currencies at Header & Item??..Thank you sir for your helping hand..

    Phanikumar

    Add comment
    10|10000 characters needed characters exceeded

  • May 18, 2015 at 03:52 AM

    Hi all, thanks your reply...

    I think I will ask sales key in in local currency (TWD) and tried to print out a foreign currency version to send to customer otherwise I cant think any other way to avoid the exchange rate difference.

    Thank you...

    Add comment
    10|10000 characters needed characters exceeded