Skip to Content
0
Jan 22, 2023 at 12:49 PM

Query for GRPO and Inventory Transfer

55 Views

Hello,

I'm trying to create a query where I can list the items that have been transfered from one warehouse to another, along with the GRPO receipt date.

Reason is when items ship from the offshore warehouse, they're received into a transit warehouse. When they arrive, they're transferred from the transit warehouse to finished goods. Need to query how long from receipt date to transfer date. Items are also lot controlled.

Tried joining OPOR, OWRT, and OIBT tables, but cannot find names to join.