Friday, November 23, 2012
One of the setup issues is performing correct dimensions values setup for the automatic transactions accounts. For example: Accounts structure for the Currency exchange unrealized profit and Loss accounts that are used for currency revaluation differences in Accounts payable and Accounts receivable.
The problem appears when the requirements for dimensions on Customer or Vendor balance accounts differs from the dimensions requirements on Currency exchange rate Profit and Loss accounts in the Accounts structure.
Figure 1
Figure 2
At the moment of Exchange rate revaluation, the following error appears.
Figure 3
This error occurs because the Invoice was posted to the Customer (Vendor) account without a dimension value and the voucher for the Exchange rate revaluation requires it. And it becomes more sensitive if the Exchange rate revaluation is run on a live system and was not tested beforehand.
To avoid this issue, the Account structure of Customer and Vendor balance accounts and Currency exchange rate Profit and Loss accounts must be the same. If the Account structure setup is complicated, the best approach is to put the Currency exchange rate Profit and Loss accounts into one separate account structure.
The sample setup would be (accounts 59101, 59102, 69101 and 69102 are realized and unrealized Exchange rate profit and loss accounts):
Figure 4
Figure 5