I'm trying to create a query that displays items that have been received but not delivered to capture what's intransit. These are non-inventory items and are expense items (one-time goods). Can anyone assist with this? I'm tryng to reconcile this witht the intransit account balance shown in GL. Thanks!
The following query can be used to filter out intransit shipments
Select * from RCV_TRANSACTIONS_INTERFACE where TRANSACTION_TYPE=RECEIVE
Please check if the attribute DESTINATION_TYPE_CODE exists in this table, if yes, pass the parameter RECEIVE.