May I please get some help on this? Some of our Purchase orders are miscellaneous purchases (PUR-UKN), and we manually allocate a GL for those lines, I’m trying to build a BAQ that has all the GL distributions for each PO lines (we’re not down to release level).
I’ve connected TranGLC to APInvDtl as a start, but have the warning ‘There is no index for TranGLC which can be used in the join with APInvDtl.’, my links are:
I get 11 rows when I select 10 rows to return, or 101 rows when I select 100 rows to return; debit/credit and book debit/book credit are all zeros, and this error message: Severity: Error, Text: Bad SQL statement. Review the server event logs for details. Correlation ID: 5de08765-cc9a-4387-9597-d25899701c66.
Usually if you press analyze and get no error, but then run the BAQ and get an error, there is some run-time error, like a calculated field errors out only on some specific row.
If you look up that correlation ID in your Application Server Log, there will be more detail.
The index warning just means that there is no index that can be used. The query will still run, but it will be slower.
Maybe I’m missing something but, if you need the GL account from the PO, why are you using the AP tables? Also, I may be on a lower version or something, but I don’t have those accounts set on the PO lines, they are assigned on the releases.
With those in mind, the below works for me.
