Hey all,
I have a small amount of pre-payment invoices that are refusing to go through the AP Open Load, all throwing the same error:
Currency conversion exchange record was not found for currency code ConvertAmt to currency code AUD.
This is the call stack on the server.log (I've cut it down to the last few calls, looks like it has something to do with calculating the Reporting currency values):
at Erp.Internal.Lib.ConvertAmtEF.ConvertAmt(Decimal Amount, String FromCurr, String ToCurr, List`1 ttConvertChainRows, Boolean FromDoc) in c:\_Releases\ERP\UD10.1.400.1\Source\Server\Internal\Lib\Shared\ConvertAmountEF\ConvertAmtEF.cs:line 99
at Erp.Internal.Lib.RoundAmountEF.ConvertAmtRoundDecimals(Decimal Amount, String FromCurr, String ToCurr, List`1 ttConvertChain, Boolean FromDocToBase, String ipTableName, String ipFieldName) in c:\_Releases\ERP\UD10.1.400.1\Source\Server\Internal\Lib\Shared\RoundAmountEF\RoundAmountEF.cs:line 116
at Erp.Internal.Lib.Rptfieldscalc.rptfieldscalc(IceRow& ttIceRow, LinqRow& ttTable, String RFunction, Boolean RCalcBase, String RFieldList, String RCurrList, String RTableName, String RCurrencyCode, List`1 ttConvertChainRows, String RRoundTableName, String RRoundField, Decimal ipDocAmt, Decimal& ipBaseAmt, Decimal& ipRpt1, Decimal& ipRpt2, Decimal& ipRpt3) in c:\_Releases\ERP\UD10.1.400.1\Source\Server\Internal\Lib\Shared\RptFieldsCalc\rptfieldscalc.cs:line 143
at Erp.Internal.Lib.Rptfieldscalc.ConvertAmtRoundDecimalsUsingIceRow(IceRow ttIceRow, Boolean RCalcBase, String RFieldList, String RCurrList, String RTableName, String RCurrencyCode, List`1 ttConvertChainRows) in c:\_Releases\ERP\UD10.1.400.1\Source\Server\Internal\Lib\Shared\RptFieldsCalc\rptfieldscalc.cs:line 341
at Erp.Services.BO.APInvoiceLoadSvc.ChangeInvoiceBalance(APInvoiceLoadTableset& ds, String ipChangeType) in c:\_Releases\ERP\RL10.1.400.0\Source\Server\Services\BO\APInvoiceLoad\APInvoiceLoad.cs:line 1230
at Erp.Services.BO.APInvoiceLoadSvcFacade.ChangeInvoiceBalance(APInvoiceLoadTableset& ds, String ipChangeType) in c:\_Releases\ERP\RL10.1.400.0\Source\Server\Services\BO\APInvoiceLoad\APInvoiceLoadSvcFacade.cs:line 267
It is also worth noting that pre-payments worked a dream if the currency was not AUD (the reporting currency).
Our base currency is USD, with the first reporting currency being AUD.
Any help or workarounds are greatly appreciated.
Cheers,
Dave.