How to fetch transactions basis GL codes?
# ask-stanley-aiv
Vaibhav Jain
09/04/2024, 6:15 AMHow to fetch transactions basis GL codes?
c
Celigo AI
09/04/2024, 6:15 AMAI generated answer (using internal Slack threads):To fetch transactions based on GL codes, you can create a saved search in NetSuite. Here are the steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction from the list. 3. In the Criteria subtab, set the following filters: - Account: set this to the GL account number(s) you are interested in. - Posting: set this to True. - Main Line: set this to Both. 4. In the Results subtab, you can select the fields you want to display in your search results. Some common fields might include Document Number, Account, Debit Amount, and Credit Amount. 5. Save and Run the search. This will give you a list of all transactions that have impacted the specified GL account(s). Remember, the GL impact of a transaction can be checked by viewing the transaction and clicking on the 'GL Impact' button. This can be useful for understanding which GL accounts are affected by different types of transactions. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
09/04/2024, 6:15 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823840618
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814232528
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.813055396
Celigo AI
09/04/2024, 6:15 AMPlease provide your feedback on this answer.
v
Vaibhav Jain
09/04/2024, 7:21 AMI'm using suiteQL to fetch transactions. Can you help with the table and data field where GL code information is stored?
13 Views