SI.Query for GL data (GLEntry vs GLDetail)

Created by Harry Lewis, Modified on Mon, 08 Apr 2024 at 03:11 PM by Harry Lewis

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).




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article