Make sure to receive the lines first, then it will appear in the Receiving Transactions form.
The lines are received but not delivered, thats I trying to do but cant find them in receiving transactions form.
If you have access to backend, please query the table RCV_TRANSACTIONS_INTERFACE against parent_Transaction_id -- which the transaction_id in rcv_transactions table for the transaction_type of "Receive".
(some times, online - pending - pending transactions might not appear on the transactions status summary form).
The best way to check for pending transactions is to query the parent transaction id.
Do let me know, if you need further assistance.
I have queried the interface table against transaction_id but cant find the item, item is also in table 'rcv_shipment_lines' but cannot deliver it using 'Receving Transaction Form'. is there anyway?
Please review my earlier update, you need to query the RTI table against the parent_transaction_id and not transaction_id
Select * from rcv_Transactions_interface
where parent_Transaction_id in (select Transaction_id
where shipment_line_id = &problematic_shipment_line_id)
thanks , there is no record. Could you tell me what is the process for making RECEIVE transactiona nd then finally DELIVER transaction for an item.
So if the purchase order line is open I will do the whole process again for problematic items.
Q: Could you tell me what is the process for making RECEIVE transactiona nd then finally DELIVER transaction for an item.
A: You need to query the Receipt in the "Receiving --> Receiving Transactions" form to perform the inspection\Delivery.
If you have performed a receipt and not delivered, you wont be able to close\ cancel the po line.
It appears there is some corruption in the data.
please upload the RCV11i by following the below steps:
a. Review Note 402245.1 (Receiving Transactions Data Collection Script rcv11i_sa.sql
b. Download script
c. Run script
**Document Number=enter PO Number
|*take all other defaults except Output Directory; for it, select UFD for output then select an appropriate Directory
d. Upload script output
I will review the details and update you.
How to delete PO lines in Transaction Summary screen:
1. Go to Responsibility of PO Superuser Navigate to Receiving->Transaction Status Summary
2. Input the PO number, click FIND
3. Highlight the first PO line then click the DELETE icon in tool menu, then SAVE.
4. Repeat step 3 for all other PO lines.
After successful deletion, please try receiving again. This time the amounts should no longer reflect as 0.