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 ?
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
