Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Join question, non 1:1 relationship

Hi All,

I'm working in Microsoft Dynamics GP.

I'm trying to join the inventory table and the GL table.   I found that IVSLIDSX from IV00101 (Inventory) and ACTINDX from GL00100 (general ledger) contain pieces of the same data.  However, I've discovered that it's not a 1:1 relationship. The inventory index only contains inventory items, and the GL index contains everything.

I've found that this causes some issues when making selections. The selections do now work both forward and backward.  It appears that this is the only field where the data is shared between the tables.  It doesn't seem like this would be an issue in SQL (I'm an accountant by trade, my SQL knowledge is limited)  based on my conversations with some members of GPUG (link below).

Open Forum - GPUG - Dynamics GP User Group Community

Is there work around to this?


0 Replies