SI.Query for GL data (GLEntry vs GLDetail)

Applies to:

• Velixo NX
• Sage Intacct

Summary

It is generally best to query the GLENTRY object rather than the GLDETAIL object.

Overview

When using the SI.QUERY function to access general ledger data, oftentimes it is much better to use the GLENTRY object rather than GLDETAIL.

GLENTRY is an actual Sage Intacct object (it is the line level of GLBATCH).

GLDETAIL, on the other hand, is a reporting [SQL] view that is a combination of subledger information and journal entry information.

From a performance perspective, querying GLENTRY can be substantially faster than querying GLDETAIL and is almost always preferred.

Keep in mind:

• The two objects have 95% of the same properties.
• GLENTRY query is quite fast.
• GLDETAIL query is comparatively slow (due to the SQL view needing to be populated).