Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XLR: How To Exclude Year End Closing JEs from GL

Does anyone know how to exclude all JEs related to the Year End closing in XLR?

Example, I'm pulling in Financials Amount on an expanding row on GL Accounts. Then there's an expanding column on YTD @Period.

The problem is that the last period includes the Year End posting, which causes the YTD Total to be $0.

Any help is appreciated.

Thanks,

Brad Windecker

replied

Hi Brad,

You can try TransType != '-3' which is closing balance.

FYI, type. '-2' is opening balance.

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question