When using "DESCRIPTION" as one of the column outputs in the [Select] argument of the SI.Query function, it seems to return the descriptions on journal entries only. Is there a way to include descriptions for other types of transactions such as A/R invoices, A/P bills and credit card transactions? I was hoping to get everything that would appear in the Memo/Description column of a standard Intacct GL report.
0 Votes
3 Comments
Sorted by
T
Terry. holtposted
5 days ago
Hi Gabriel,
Yes, I found that template and it was very helpful. I was hoping to get the descriptions from the transaction lines on the query.
In your screenshot, the description column has the description of the GL batch entry. If you run the same GL Report, but select "DETAILS" instead of "SUMMARY", the report would show the individual memos/descriptions for each line item. This is the information that I was hoping to obtain.
As Harry Lewis hinted at, that info is available in the DESCRIPTION field of the APBILL, ARINVOICE, and other objects. I created a query to pull the DESCRIPTION field on the CCTRANSACTIONENTRY object and got the information I was looking for, but only for credit card transactions, of course.
I am trying to re-create a detailed GL report in Excel. Is it possible? If not possible in one query, is it possible with multiple queries for the different types of transactions and then combining them using Excel functions? The multiple query option would only work if the GL entry query only had direct general ledger entries and did not include the batch entries from the other types of transactions. Thanks!
0 Votes
When using "DESCRIPTION" as one of the column outputs in the [Select] argument of the SI.Query function, it seems to return the descriptions on journal entries only. Is there a way to include descriptions for other types of transactions such as A/R invoices, A/P bills and credit card transactions? I was hoping to get everything that would appear in the Memo/Description column of a standard Intacct GL report.
0 Votes
3 Comments
Terry. holt posted 5 days ago
Hi Gabriel,
Yes, I found that template and it was very helpful. I was hoping to get the descriptions from the transaction lines on the query.
In your screenshot, the description column has the description of the GL batch entry. If you run the same GL Report, but select "DETAILS" instead of "SUMMARY", the report would show the individual memos/descriptions for each line item. This is the information that I was hoping to obtain.
As Harry Lewis hinted at, that info is available in the DESCRIPTION field of the APBILL, ARINVOICE, and other objects. I created a query to pull the DESCRIPTION field on the CCTRANSACTIONENTRY object and got the information I was looking for, but only for credit card transactions, of course.
I am trying to re-create a detailed GL report in Excel. Is it possible? If not possible in one query, is it possible with multiple queries for the different types of transactions and then combining them using Excel functions? The multiple query option would only work if the GL entry query only had direct general ledger entries and did not include the batch entries from the other types of transactions. Thanks!
0 Votes
Gabriel Michaud posted 5 days ago
Hi Terry,
Is this the field that you are looking for?
It is named BATCHTITLE in the GLENTRY object.
I don't know if you're familiar with our templates, but we have this one that can be a good baseline for a GL Transaction details report: https://community.velixo.com/support/solutions/articles/153000171653-si-gl-rt12-gl-transaction-details
0 Votes
Harry Lewis posted 15 days ago
Hello.
Various Intacct objects contain various field name.
For instance, all the objects you mention (APBILL, ARINVOICE, and CREDITCARD) contain a "Description" field:
Your Sage Intacct partner may have insight into where specific data is located.
0 Votes
Login or Sign up to post a comment