Plugin to prevent 0.00 FX Amount transactions being saved where Amount > 0.00 - 7.00.175 only

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

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.

When the transaction batch is activated a warning is displayed and the batch can't be activated until the issue(s) is corrected.

 

  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