I’m diong a BI project and trying to link the LedgerDimension (Main Account - Financial Dimension 1-Financial Dimension 2) string to a paticular financial dimension value. I’m essentially trying to pull all journal entries that have a paticular financial dimension on it. I’m stuck trying to see how the LedgerDimension field on the GeneralJournalAccountEntry table relates to the DimensionFinancialTag table. There are like 20 “dimension” tables and I havent figured out how they all link together. Has anyone figured this out before?
Also using X++ to parse the string is not an option, I need to figure out the joins through a SQL Query