0

Report based on an entry in the reservation Entry Table

I already have a report which gives me an overview of outstanding sales ordes lines (qty to ship >0).

Now i want to refine the report by showing only the lines for which the item on the line has a reservation entry which is linked to an item which is currently in stock.

This is where the problem begins, I need to create a link to the reservation entry table, but I discoverd that eacht sales order line for which a reservation was made has 2 entries in the reservation entry table, whit de same entry No.
The problem is that I don't know how to do this.

A small example to explain:

Sales Order 72356 has two entries in the Reservation Entry table,

Item No. Variant Code Source ID Source Ref. No. Entry No. Quantity Source Subtype
MCPVC 001 72356 10000 916575 -1 1
MCPVC 001 21500000 916575 1 0

How can I filter the sales Orders Lines based on the Source ID from the second line, which is blanco.

I realley hope somebody can help me.

0 comments

Please sign in to leave a comment.