Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
It is not allowed to match directly (using the matching function) entry lines in different currencies when the account is setup to be carried forward in currency. You should:
- Either use the AP/AR payment processes (that automate the accounting schema)
- Or book manually journal entries using intermediate accounts and match each of them. Look at what happens when processing by AP/AR payments
The journal entries generated by the fiscal year end process will be generated in the ledger currency, not the original currency. It will not help the understanding of amounts to pay/to be paid when checking BP accounts. I don't know the version you use, but it could not help the reevaluation of the accounts at the end of the month due to currency rate changes due to these balances in "wrong" currencies.
The question is why you have to match such entries manually: the best way is to use AP/AR payment processes, because as I said, such question is completly automated.
The journal entries generated by the fiscal year end process will be generated in the ledger currency, not the original currency. It will not help the understanding of amounts to pay/to be paid when checking BP accounts. I don't know the version you use, but it could not help the reevaluation of the accounts at the end of the month due to currency rate changes due to these balances in "wrong" currencies.
The question is why you have to match such entries manually: the best way is to use AP/AR payment processes, because as I said, such question is completly automated.
Thanks a lot for the detailed response . Just one more thing , if we are to use AP/AR payment processes for different currencies can you please tell how can it be done ?
Oups, large question.
Each currency (open item, bank account and payment) may be different. For example, you can pay a GBP invoice using $, and post it on a bank account that is managed in Swiss franc.
If you enter a payment transaction, you select these 3 elements
If you use mass processes, each steps (payment proposal, bank allocation, posting) enables you to act on how to select, generate and post entries.
For example, the payment proposal allows you to select open items in one currency (or a group of currencies) and only this currency.
Thanks buddy for the help . So basically if its different currency the reconciliation should be done at the AP/AR level , only same currency transaction could be handled through manual matching right ?