I want to pull GL# Date onto my report but the results is null, why is this ?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you're trying to pull the GL# Date onto your report but the result is null. This could be due to a few reasons: 1. The GL# Date field might not be included in the data set that you're pulling from. Make sure that the field is included in the data set. 2. There might be no data available for the GL# Date for the specific records that you're pulling. Check the records to ensure that there is data in the GL# Date field. 3. There might be an issue with the way you're pulling the data. If you're using SuiteQL or ODBC, make sure that your query is correct. If you're using a built-in report, make sure that you've configured the report correctly to include the GL# Date field. 4. If you're joining tables, make sure that you're joining on the correct fields and that the GL# Date field is available in the joined table. If you're using SuiteQL or ODBC, you might need to join to the

TransactionAccountingLine

table to get the GL# Date. Here's an example of how you might do this:

sql
SELECT GL#, Date
FROM TransactionAccountingLine
WHERE ...

Please replace the

...

with your specific conditions. If you're using a built-in report, you might need to customize the report to include the GL# Date field. You can usually do this in the report builder. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******