Corrected Question: How can the Trial Balance upload function be used with denominated accounts mixed in with the company’s natural currency accounts?
Using V 23.110.0025
The company currency is MXN and the parent company is USD. Two separate tenants - parent co in one and Mexican in another tenant so that the Mexican localization can be used. The parent wants one Cash Account in the Mexican company to be USD and the Fixed Asset Accounts to be denominated as well (USD). I'm trying to upload historical balances. If I use all MXN in the YTD balance on the Trial Balance Upload, the cash balance is not correct in the USD Cash Account. If I use USD in the TB upload, the TB does not balance; therefore, won't release. Suggestions besides journal entries with net changes vs the TB upload with YTD balances?