with suiteql, for a transaction line, how do I retrieve the target account for an amortization connected to a line. transactionline.expenseaccount holds the same value as transactionaccountingline.account.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the account you are looking for is not directly accessible via SuiteQL for a transaction line that is connected to an amortization. The

transactionline.expenseaccount

holds the same value as

transactionaccountingline.account

, which is usually the prepaid or deferred asset account when an amortization template is selected in the Vendor Bill. However, there are a couple of workarounds suggested in the threads: 1. You can create a custom transaction line field that copies the selected expense account. When saving, the account value should remain fixed and would not become prepaid. This custom field can then be accessed in your SuiteQL query. 2. You can start with a saved search in the UI, and start adding columns like the account and amounts to see how saved searches represent accounting impacts. This might give you more insight into how to retrieve the target account for an amortization connected to a line. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******