Foreign currency valuation about Sales order in foreign currency
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?