/
Creating a new Jiwa database where Australian Dollar is not the local currencies sets both as Local

Creating a new Jiwa database where Australian Dollar is not the local currencies sets both as Local

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

Creating a new Jiwa database and selecting any currency other than Australian Dollar, sets both currencies as Local.  Attempting to correct this in the application errors.

Solution

SQL skills are required

Sound SQL knowledge is required to complete this task

This situation can only be corrected via SQL

  1. Select the records from the FX_Currency table




  2. Update the field IsLocal for the currency that is NOT the local currency e.g. Australian Dollar
    update FX_Currency set IsLocal = '0' where RecID = 'AAC8BD6A-A686-40C8-B052-EF4AF089E699'

Related articles

Related content