Proforma Invoice - custom report - API to derive transfer price
Requirement is to develop a CUSTOMS PROFORMA invoice report. Need to derive the transfer price of the item for an intercompany invoice. Tried with the below two APIs, but not able to get the correct result.
- QP_PREQ_PUB.PRICE_REQUEST API, it returns NULL most of the times; some time it returns incorrect correct transfer price.
- MTL_INTERCOMPANY_INVOICES.GET_TRANSFER_PRICE API, with transaction id, but it returns NULL as result.
- Also, if required currency conversion has to be taken care.
Kindly guide us if anything wrong in the above approach and suggest if any other API that is available to derive the transfer price.