on 11-17-2006 2:48 AM
Hi,
A new requirement has come for me ... the existing form for statement of account is using RF140-WRSHB (foreign currency) to display the open items of the customer ... but when a customer is having two different currency... then the users want to display the local currency on the first page & on the second page they want to display foreign currency + local currency
for e.g ... Cust A has open item in SGD($160) & USD ($100)...
then on page 1
Foriegn currency USD - $100 <-- This is already coming ...
on page 2.
Currency | local currency
100 USD | 160 SGD <-- I need to display this... please tell me how can I do this ...
Thank You,
SB.
CONVERT_TO_LOCAL_CURRENCY
Try this FM
call function 'CONVERT_TO_LOCAL_CURRENCY'
exporting
DATE = sy-datum
FOREIGN_AMOUNT = IS_FINAL-NETWR
FOREIGN_CURRENCY = IS_VBAP-WAERK
LOCAL_CURRENCY = 'USD'
importing
LOCAL_AMOUNT = L_AMOUNT_USD.
Regards
- Gopi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI SB
For creating a new page, please follow below steps:
1. Open the form in change mode via transaction SE71.
2. Select Pages from Application Toolbar.
3. Use menupath: Edit->Create Element
4. Enter details for Page and description.
With this page, now you can create page windows and print the amounts and their currencies.
Hope this helps.
Kind Regards
Eswar
Hi Eswar,
It is taking currency Key from BSID ... & BSID here for that customer is having 2 currency Key ... one for SGD & one for USD ... the only way to get the right currency key in page 2 is through the right BELNR ... but how do I write .. Select WAERS where
bukrs = "____ " and
kunnr = "____" and
belnr = "____".
This is what is written for Page 1...
&ULINE(71)&,,
<K>Doc.,,Doc.,,Invoice,,Text,,Amount in</>
<K>Date,,Type.,,Number,,,,&BSID-WAERS&</>
&ULINE(71)&
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.