Reporting Currency - Slot ID

Epicor ERP 10
1

Okay, I’ve learned that flipping the ReportCurr to true in Erp.Currency will turn on Reporting Currency for a currency code moving forward, and I know the Add Reporting Currency action retros the converted currency values into the Rpt currency fields in all existing records. What I haven’t found is where the Slot ID resides. Does anyone know the table where this value is being stored? Thanks.

image

bb

2

Erp.Currency.ReportCurrPos is what you are looking for, combined with

SELECT [Company]
,[CurrencyCode]
,[CurrDesc]
,[CurrSymbol]
,[DocumentDesc]
,[Note]
,[CurrName]
,[CurrencyID]
,[DecimalsGeneral]
,[Inactive]
,[MaintRate]
,[BaseCurr]
,[ReportCurr]
,[GlobalCurr]
,[ReportCurrPos]
FROM [DATABASE].[Erp].[Currency]

3

Thanks. I also discovered it just before you posted.

1 Like