i am fetching the deliveryno, del quantity , grno nd gr quantity for a purchase order.
but those r not coming in one row.
but i need in one row.
i am fetching from ekbe table.
first it is picking grno nd gr quantity, then in next row it is picking del no nd its quantiy.
i need to pick in-transit nd pending quantity.
how to fetch that, or any calculation needed?
if any one know give me an idea about this.