Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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