How to Fix Sage Error Amount Paid in Foreign Currency Disagrees with Total Paid in Allocations?

troubleshoot account out of balance

Because of the wide array of functionality they provide, all the software from the Sage family are extremely popular among the business community and professionals all over. The Sage accounting platform has indeed helped businesses accomplish their accounting needs more effectively. No wonder why all the software from the Sage family are used extensively by businesses and professionals across the globe.

Many businesses these days have gone global. This has led them to trade in different currencies. Sage 50 has offered its helping hand in this aspect as well. This premier accounting software has indeed made foreign trade easier. With it, businesses can set up customer and supplier profiles and process transactions in multiple foreign currencies, without any manual intervention.

However, some users of Sage 50 have intimated that they have got the error message that says – ‘Amount paid in foreign currency disagrees with total paid in allocations’. If you are also troubled by this issue, we can be of great help. In this blog, we will discuss multiple methods to troubleshoot this error.

Let’s proceed then!

How to Fix Amount paid in foreign currency disagrees with total paid in allocations error message in Sage 50

Here, we will provide a couple of methods to fix this issue-

Total Time: 22 minutes

Method 1: Check for warnings in the Maintenance section

Please follow the steps below-
💠 Open Sage 50
💠 Go to the Transactions section 
💠 Choose the relevant transaction
💠 Now click on the Unallocate tab 
💠 Click Yes.
💠 Repeat these steps for all the transactions with this error.
💠 Now go to File
💠 Click on Maintenance 
💠 Click on the tab named Check Data.
💠 Next, click on the Warnings tab 
💠 Check if you are getting any of the following warnings:
💠 The purchase aged balance disagrees with Debtors control by (amount)
💠 The sales aged balance disagrees with Debtors Control by (amount).
💠 If so, note down the amount mentioned in the error message for ready reference
💠 Now, click on the Technical Information tab 
💠 Go to the Dataset Information section
💠 Note down the number of Splits.
💠 Next, click on Recovery Tools 
💠 You will be prompted to create a data backup.  Follow the instructions to do so.
💠 Go to Recalculate Transaction History
💠 Click OK to proceed
💠 Click on Recalculate Period Values
💠 Click OK
💠 Click Close.
💠 You will be prompted to check the data again
💠 Click Yes.
💠 Please note: If the error still exists, you should restore an error free backup and process the data again 
💠 Click on continue.
💠 Click on the Warnings tab again 
💠 Note down the amounts on the Aged Balance warnings.
 
Please note: if you can’t see any warning, move to the next step. 
 
💠 If the amounts differ to step 12, you should restore an error free backup and process the data again. else, continue
💠 Now, click on the Technical Information tab 
💠 Go to the Dataset Information section
💠 Check the number of Splits. If the number differs from that in step 15, you should restore an error free backup and process the data again.

Method 2: Restore to an earlier backup

Restoring an earlier backup taken before the occurrence of this error can help fix the issue. Here are the steps to do so:
💠 Go to the File section
💠 Click Backup.
💠 Perform the instructions shown on your screen to back up your data normally.
💠 Go to the File menu again 
💠 Click on Restore.
💠 Click on Browse 
💠 Specify the backup file you need to restore.
💠 Click OK to proceed with the restoration process.
💠 On being prompted, click OK to overwrite your existing data.

Also Read: Learn how to fix Sage HTTP 500 Error

Final Words!

We hope the above discussion would help you troubleshoot the ‘Amount paid in foreign currency disagrees with total paid in allocations’ Error message in Sage 50. In case you are still having any issues related to foreign currency transactions in Sage 50, we would recommend you to get in touch with some of the Sage experts 1800 964 3096.

contact us 1 18

FAQs

How can I enable foreign currency transactions in Sage 50?

Here are the steps to follow-
💠 Go to Settings
💠 Click on Business Settings 
💠 Go to the Financial Settings section 
💠 Click Currencies.
💠 Choose Enable Foreign Currency Transactions.
💠 To use the latest exchange rates from the ECB automatically, checkmark the box next to ‘Use Live Exchange Rates’
💠 If you want to add a new currency on the next available line, select the currency of your choice from the drop-down list.
💠 Select /provide the following information:
💠 Exchange Rate Gain and Losses Ledger Account
💠 Bank Charges Ledger Account
💠 Select Save.

What causes the Sage Error Code 12: Invalid Transaction?

Some of the prominent reasons for the occurrence of this error code are-
💠 The user may have typed the wrong card number
💠 The card may have got expired 
💠 The user may have provided an incorrect card expiry date
💠 The spending limit for your credit or debit card may have got crossed
💠 The user may not have activated the card
💠 The card is not current on payments
💠 Incorrect card details may have been entered by the processor
💠 Issues with the AVS or Address Verification Service 
💠 Some fraudulent activity has been tried with the card
💠 You may have tried using the card multiple times in a row and the card association may have considered it a sign of fraud
💠 The card may have got damaged
💠 The card reader may not have been working properly

What are the reasons behind the Sage 50 decline code 000006 Error 0008?

💠 Some of the major causes of this issue are as follows-
💠 Attack by Virus/Malware
💠 Improper shutdown of the system.
💠 Some of the Windows system files may have been corrupted/damaged.
💠 Improper/incomplete installation of any file/ application

Related Posts

Further Reading