PO Receiving Value
Hi
Please explain how to get PO receiving value with condition unit of measure PO and unit of measure receiving is different and master convertion rate has been change after that transaction.
I use query bellow, but the problem it will use the new connvertion rate.
SELECc gcc.segment4, 'Purchase' sumber, rsh.receipt_num grn_no,TO_CHAR (rt.transaction_date, 'DD-MON-RRRR') grn_date, pha.segment1 po_number,sum(inv_convert.inv_um_convert (pla.item_id,4,case when rt.transaction_type = 'RECEIVE' then rt.primary_quantity else rt.primary_quantity*-1 end ,null,null,rt.primary_unit_of_measure,rt.SOURCE_DOC_UNIT_OF_MEASURE)*rt.po_unit_price*nvl(rt.currency_conversion_rate,1)) grn_amount FROM rcv_shipment_headers rsh inner join rcv_transactions rt on rt.shipment_header_id = rsh.shipment_header_id inner join po_distributions_all pda on pda.po_distribution_id = rt.po_distribution_id inner join po_lines_all pla on pla.po_line_id = pda.po_line_id inner join po_headers_all pha on pda.po_header_id = pha.po_header_id inner join gl_code_combinations_kfv gcc on gcc.code_combination_id = pda.accrual_account_id WHERE 1=1 and rsh.receipt_num = '210211100017' AND rt.transaction_type in('RECEIVE','RETURN TO VENDOR') group by gcc.segment4,rsh.receipt_num, TO_CHAR (rt.transaction_date, 'DD-MON-RRRR'), pha.segment1