Multi-Currency Workarounds in Elliott

Multi-Currency Workarounds in Elliott

Q - I know Elliott doesn't have a Currency Management module, but I'd like to know if there's any effective "workaround" to simulate multi-currency processing in Elliott? Maybe another customer has shared with you some external method they are using to emulate multi-currency processing?

We've got a very simple, low volume scenario, and I was just curious if anybody has figured out a way to "game" the system a bit to get the financial results desired -- emulating multi-currency transactions in a system that doesn't inherently support multi-currency.

A - We have a Canadian customer doing it this way if your scenario is as simple as you described: 
If your particular customer and related selling item can be isolated, you may create separated group of GL Chart Account to handle that. 

For example (using separated Profit Center)

1. Cash in Bank (Canadian Dollar) 
2. Accounts Receivable (Canadian Dollar) 
3. Sales, Freight, Misc (Canadian Dollar) 
4. Inventory (Canadian Dollar) 
5. COGS (Canadian Dollar) 
6. Accounts Payable (Canadian Dollar) 

For each GL account, you have a US Dollar conversion variance account associated with it. For example, Cash-In-Bank balance 1300.00 (CND) with a conversion variance account -300.00 (USD) to present a balance in  USD of 1000.00. 

For reporting purposes, you should set a unique Customer ID (start from C00001), Product Category, and Material Cost Type to help GL account settings and other sales history reports.

You should realize that this is not a perfect solution, but it can be managed.  See the following article for more details:




    • Related Articles

    • Multi-Currency Exchange Handling in Elliott

      Release Date: 08/30/2017 Multi-Currency Exchange Handling in Elliott Introduction Elliott is not designed as a multi-currency package. However, there are common practices you can use that have been adopted by Elliott users to perform multi-currency ...

    • Feature - Invoice History Printing with Currency Conversion

      Release Date - 11/8/18 This feature allows history invoices to be printed using currency conversion rates.This applies to any amount field, such as the unit price, extended amount, total sales, freight, misc. charges, tax amount, grand total, payment ...

    • Warehouse Replenishment - Multi-Bin Environment

      Generate Replenishment Transfer Batch Updated: 11/18/21 Before running the Restocking Suggestion Report, the PICKBIN attribute must be set up for all items that require replenishment from a secondary bin. For more information on how to set this up go ...

    • Feature - Multi-Bin Physical Count Enhancement

      Release Date: 10/31/2022 Version: 8.5 & Up This project enhances the physical count processing for multi-bin users. It is not applicable to non-multi-bin users. Multi-bin users can now perform the following two new functions: Cycle Count by Bin ...

    • Should I Implement Multi-Bin or Warehouse Management System (WMS) in Elliott?

      Release Date: 6/30/2021 Version: 8.5 & Up Q - I'm curious to know how difficult it would be to switch from a single-bin environment to a multi-bin environment. We are running Elliott 8.2. Is there an alternate solution while staying in the single-bin ...