Infusion Knowledge Base

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.

    Multi Currency Cashbook Payments and Supplier Adjustments

    When Multi Currency is enabled, the Cashbook Payment screen will include a Currency section.

    The local currency is selected by default, and totals are shown only in the local currency.
     

    Users can choose a different currency, and when the selected currency is not the local currency, the Exchange Rate section appears. 

    The system automatically loads the exchange rate for the transaction date and selected currency, and users may override this rate if needed and this is a mandatory field. 

     

    Add the line details as usual in the section below.

     

    All amounts are displayed in the selected currency, and the footer shows the Net amount in both the foreign currency and the local currency.

    Please note: Cashbook payments use the Smart Grid functionality check Smart Grid on Transaction views - Article Editor to know more about how smart grid works on transaction views 

    FX Conversions Not Displaying Correctly 

    Description
    We have identified an issue affecting how exchange rates are displayed when switching between foreign and local views.

     When an exchange rate is entered (e.g., 0.59 USD per 1 NZD), the system displays the same value regardless of the selected display mode

    Example

    • Exchange rate: 0.59 AUD per 1 NZD
    • Expected Local Display: 1 / 0.59 = 1.67
    • Actual Local Display: 0.59

     

     

    Workaround

    • Ensure “Display Currency As” on the currency code is Foreign.
    • Enter the exchange rate as the foreign amount that 1 NZD purchases. For example, based on the scenario above, you would enter 0.59, as this is the amount of USD required to obtain 1 NZD. 
     
     

    Supplier Adjustments for International Supplier 

    To create an adjustment for a supplier:

    • Open the Supplier detail view.
    • Select More Options.
    • Click + Adjustments.

    This will open the adjustment screen where you can enter and process the required changes.

    When you select an International Supplier, additional fields for Currency and Exchange Rate will automatically appear

    The Currency field is a mandatory field and will default to the supplier’s default currency (as set on the Supplier Terms tab). Users may change the currency when creating a new transaction.

    When local Currency is selected the total will be displayed in the local currency. The system will not display the amount in the supplier’s default currency.

     


    Exchange Rate Handling and Amount Calculation for Supplier Adjustments

    The system loads the exchange rate for the adjustment date and the selected currency.  Users may override the exchange rate if required.

    If no exchange rate exists for the selected date and currency, the system blocks Save/Post and displays a clear error message. The exchange rate must be a positive numeric value within the allowed precision.


     

    When the transaction date on a Supplier Adjustment is changed, the system will, automatically update the exchange rate based on the new adjustment date and selected currency and prompt the user to confirm whether the exchange rate should be updated

     

    On update, the system recalculates and stores both local and foreign amounts using the exchange rate for the adjustment date.

     Amounts and the exchange rate are recalculated automatically whenever the adjustment date or currency is changed.

    Was this article helpful?

    Still can't find what you are looking for?

    Our award-winning customer care team is here for you.

    Contact Support

    Powered by