We would like to be able to see the Line Item Description for Transactions on our GL Transaction queries. Currently Line Item Description is only available in an AP Invoice query and there is no join key between the AP Invoice and GL Transaction queries.

Strangely, when you look in the backend of the database the Line Item Description is kept in the BBDISTRIBUTIONS table which can be joined to the GL7TRANSACTIONS table through the GL7TRANSACTIONSID. It looks like making it available on GL Transaction queries should be no problem. Can you please do this?

We have added the Line Item Description as part of our Journal Reference posting so that it will be available going forward but we would like to be able to see if for all transactions in the past and this is clearly possible because I have done it through queries in the backend of the database, I just can't do that anymore because we are now hosted on NXT.

Thanks,

Ben