Skip to Main Content
Sage 200 Evolution ZA Ideas Portal

Welcome to the Sage 200 Evolution ideas Portal

Created by Guest
Created on Sep 5, 2025

Foreign Balance to be zero for Local Currency Customers and Suppliers

Foreign Balance on a no-foreign currency customer is misleading.

Multicurrency Database

Customer Maintenance Grid - Customize Grid column - Add Balance and Foreign Balance fields

Customer users this screen along with the Age Analysis and Statement to reconcile the Customer and Supplier balances


If Local currency Customers/Suppliers have a Foreign balance that never gets cleared it throws the users off



What is the workaround for the problem today?

Update the PostAR table

Updated PostAR/PostAP set fExchangeRate = 0 where iCurrencyID = 0

Update Postar/PostAP set fForeignDebit = 0, fForeignCredit = 0, FForeignOutstandig = 0 where iCurrencyID = 0

Your Designation/Role Customers Services
Email.
  • Attach files