Tracing items back

omyahamburg — Thu, 12 Jul 2012 07:07:35 GMT

Hello all,

I have 2 tables, one is listing all item transactions with its entry numbers and the other one shows the corresponding

application entries with inbound and outbound entries.

Item Ledger Entry Table
Entry No_	Article No_	Source No_	Transaction	Description	Quantity
125236	10030	70408	Purchase	my Article	189.000,00
125238	10030		transit to location 1	my Article	-189.000,00
125239	10030		transit to location 1	my Article	189.000,00
127316	10030		transit to location 2	my Article	-189.000,00
127317	10030		transit to location 2	my Article	189.000,00
127811	10030	10012	Sales	my Article	-24.000,00
127812	10030	10012	Sales	my Article	-24.000,00
127818	10030	10869	Sales	my Article	-10.000,00
127872	10030	10027	Sales	my Article	-20.000,00

Item Application Entry
entry	Inbound Item Entry No_	Item Ledger Entry No_	Outbound Item Entry No_	quantity
128914	125236	125236	0	189.000,00
128916	125236	125238	125238	-189.000,00
128917	125239	125239	125238	189.000,00
131015	125239	127316	127316	-189.000,00
131016	127317	127317	127316	189.000,00
131513	127317	127811	127811	-24.000,00
131514	127317	127812	127812	-24.000,00
131520	127317	127818	127818	-10.000,00
131574	127317	127872	127872	-20.000,00

My goal is to trace back my sales items to its origins. In this case, the entries 131513, 131514, 131520 + 131574 of the Item Application Entry table have their origin in Entry no 125236 in table Item Ledger Entry. Of course I have to link the tables, but I have no clue how to manage this multiple entry track back. Furthermore the number of movements (transfer to ...) shown in table Item Ledger Entry can be N (never a fix number).

Does anybody have an idea ? Would this in general be possible ?

I do attach the sample qvw.

Thanks for your help.

Cheers

Re: Tracing items back

Jason_Michaelides — Thu, 12 Jul 2012 07:23:46 GMT

Err...I may be missing something obvious but from the sta provided above I can't for the life of me see how 131513 etc link back to 125236! What's the logic that determines the origin?

Re: Tracing items back

Thu, 12 Jul 2012 07:41:13 GMT

i believe if you change 'Item Ledger Entry No_' in the Item Application Entry to Entry No_ you should be able to accomplish what you are looking for. Regards RL

topic Tracing items back in QlikView

Tracing items back

Re: Tracing items back

Re: Tracing items back