How can I pull just the account number in as a column in the trial balance report?

AI generated answer (using internal Slack threads):

To pull just the account number as a column in the trial balance report, you can use the "Name (GL-style)" field. However, whether it displays the full hierarchy or just the child node is determined by your preferences under Home > Set Preferences. Make sure to uncheck the "Show Hierarchy" option. If you are still seeing the full hierarchy, it might be because of the layout preferences for each section in your report. You need to check the "show hierarchy" preferences there too. This can be found in the financial layout section when customizing reports. If you want to separate the account number and the account name in a saved search, you can use a Formula (Text) field with the following formula:

SUBSTR({account},INSTR({account},':')+2)

. This formula will return the account name without any hierarchy. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******