Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

Adding an FX creditor to any creditor sourced transaction (except EFT/Cheque payments) is not populating Foreign Currency Trans when Trans Amount and Disp. Amounts are entered instead of the FX amounts. The batch can be activated and it results in incorrect gains/losses being posted when allocations are made for these transactions.  The issue has occurred in client databases where the FX fields are not visible in the grid. This plugin prevents activation of the batch if the Foreign Currency Trans is zero.

Solution

The plugin attached to this article will prevent a creditor transaction being activated for a FX Creditor where the Foreign Currency Trans. field is 0.00.  Where the Foreign Currency Trans is visible in the grid, a warning icon with a message will be displayed.

...

Panel
bgColor#fff
  1. Download and save the plugin
  2. System Settings > Plugins > Plugin Maintenance
  3. Utilities tab > Import from XML
  4. Save and exit out of Jiwa
  5. Log back in again and the plugin is now active

Note:  Plugin has been updated (16/06/2017) to address an 'Object reference not set ...' error when loading creditor sourced transaction batch from the creditor Transaction tab

View file
namePlugin Prevent 0 FX Amounts in Creditor Batches.xml
height250

Filter by label (Content by label)
showLabelsfalse
max5
spacesJ7UG
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-troubleshooting-article" and type = "page" and space = "J7UG"
labelskb-troubleshooting-article

...