Skip to Content
avatar image
Former Member

Exchange Rate in Journal Entry

Jan 16, 2017 at 04:50 AM | 174 Views

Dear Gurus,

I am now working to deploy the SAP B1 to my client which is a trading company.

They would like to input the exchange rate in JE for buying foreign currency and mark as record.

However, they will input the currency table at the beginning of the month, so in JE it will calculate the Debit FC to Debit (LC) automatically. It is not wise to update the table daily as they take the average for sales and purchasing activities.

Do you guys have any idea to deal with my problems?

Best Regards

Daniel

SAP Business One | SAP Business One SDK
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Jitin Chawla
    Jan 27, 2017 at 09:17 AM

    Hi,

    Check the Indexes tab under the Exchange Rate & Indexes window in the Administration Module.

    Here you can define the Exchange Rate for the complete month at the beginning which would be used in the JE.

    Check if it works.

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Nagarajan K
    Jan 27, 2017 at 09:29 AM

    Hi,

    Refer attached picture to set exchange rate for full month.

    exchante-rate-setup.png


    exchante-rate-setup.png (112.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Nagarajan K
    Jan 27, 2017 at 09:29 AM

    Hi,

    Refer attached picture to set exchange rate for full month.

    exchante-rate-setup.png


    exchante-rate-setup.png (112.4 kB)
    Add comment
    10|10000 characters needed characters exceeded