select (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.vendor_id = ap.vendor_id order by creation_date fetch first 1 row only)) “Entity_OU”, TO_CHAR(ap.creation_date,’DD-MON-YYYY’) “Vendor_Creation_Date”, fu.user_name…
Read MoreUn-Ordered Receipts Allow Unordered receipts allows to receive the goods without a PO. But these goods can only sent to receiving area and not for the sub-inventory. Later we have…
Read MoreSubstitute Receipts This option can be used when we can receive the substitute item. Means we can receive item B, where as we ordered item A. Firstly for this we…
Read MoreExpress Transactions The express transaction function is a quick method of entering receipts and receiving transactions. Step1: Create a PO. Create a purchase order and go to line level shipments…
Read MoreCascade Receipts The Cascade function facilitates the distribution of a given quantity of an item and UOM from a single supplier across multiple shipments and distributions When you select the…
Read MoreBlind Receiving This type of receipting allows the quantity as zero quantity while receipting no matter what is mentioned in the Purchase order. The purpose behind it is to count…
Read More