How do I consolidate data from GL?

I am trying to summarize data based on a database table that contains thousands of GL entries. The problem I am trying to solve it summarizing the data based on part of the GL.


For example: I have a GL that is 16 numbers long and I want to summarize data based on numbers 1-10. Is this possible? So any record with a GL value of 1234567890xxxxxx should sum together as a single value.

Best Answer

  • Tomo
    Tomo 🟢
    Accepted Answer

    BEAST MODE example


    1234567890123456 -> 1234567890

This discussion has been closed.