I’m setting up a new company from scratch in our test environment from BAQ exports out of our PILOT environment.
I’m getting a Currency cannot be active unless all Conversion Rules are defined on active Rate Type(s) error when DMT’ing the Currency table. What did I forget to do? I’m not a finance guy, so conversion rules and rate types are new to me.
2019-05-10T16:49:42 Company REDACTED CurrencyCode USD Table: Msg: Currency cannot be active unless all Conversion Rules are defined on active Rate Type(s).
Here’s the input csv:
Company | CurrencyCode | CurrDesc | CurrSymbol | DocumentDesc | Note | CurrName | CurrencyID | DecimalsGeneral | Inactive | DecimalsPrice | MaintRate | DecimalsCost | BaseCurr | RoundMltpUnitPrice | RoundMltpUnitTax | RoundMltpExtPrice | RoundMltpExtTax | RoundMltpTotalAmt | GlobalCurr | RoundMltpTotalTax | GlobalLock | RoundRuleUnitPrice | ScaleFactor | RoundRuleUnitTax | CountryNum | RoundRuleExtPrice | ReportCurrPos | RoundRuleExtTax | RoundRuleTotalAmt | RoundRuleTotalTax | RoundTolerance | ISONumber | StoreID | RoundMltpAnnualCharge | RoundMltpPeriodCharge | RoundRuleAnnualCharge | RoundRulePeriodCharge | AGAFIPCode | ISOCurrCode | EntityGLC#RelatedToFile | EntityGLC#Key1 | EntityGLC#GLControlType | EntityGLC#GLControlCode |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
REDACTED | USD | USD | USD | USD | USD | 2 | FALSE | 5 | TRUE | 5 | TRUE | 0 | 0 | 0 | 0 | 0 | FALSE | 0 | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Thanks for the help!