Skip to Content
0

Implementing UDF - exchange rate - in JE

Dec 20, 2016 at 08:29 AM

34

avatar image

Dear Gurus,

I am trying to make UDFs in JE and I am looking for some advices.

My client is an international company trading company, he has to buy some currencies for preparing and completing the transaction.

My client is Hong Kong based, so the local currency and system currency are both set to HKD. In some cases, he will buy RMB from USD and any other ways.

However, SAP B1 only use the predefined exchange rate from the table, which my client will input the value at the beginning of the mouth as for reference. For more precise accounting reporting, and printing out the exchange rate for reporting uses, my client would like to change the exchange rate in JE level for the above scenario. I am now trying to do in the row level of JE:

1. UDF 1 - Currency option - which provide a list of currency available as predefined - and this will apply a FMS as some account in CoA are currency specified.

2. UDF 2 - Exchange rate - the exchange rate is obtained (by FMS) after the user select the currency (UDF1) and it show the exchange rate on that day.

3. UDF 3 - Debit FC - I know the system has this column but the FMS in Debit(LC) cannot trigger by the Debit(FC) - that's why I am using a UDF for it. When user input the value, it trigger a FMS and it input a value (combining the currency code and amount) into the REAL Debit(FC) and calculate net amount based on the exchange rate for the Debit(LC)

4. UDF 4 - Credit FC - same reason and logic as stated as #3

However, I am facing the following problem:

a. If I did not alter the field in exchange rate, the debit(LC) will not show.

b. I can now input both debit and credit (UDF) on the same row, which is out of control and would like to fix it.

Can I have some suggestions for my solution? Or can I have some better solution for my client's case?

Thank you the kind attention.

Best Regards,

Daniel

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers