Invoice Doesn't Appear To Bring Over Ship To Location for Drop Ship PO - Location Null on Form
(Doc ID 1557771.1)
Last updated on AUGUST 24, 2021
Applies to:Oracle Payables - Version 12.0.1 and later
Oracle Purchasing - Version 12.0.1 and later
Information in this document applies to any platform.
- When AP invoices are created for a purchase orders created from a drop-ship sales order, the ship to location is not filled in.
- This will result in inaccurate or no tax calculation.
- The drop ship location is present on the Purchase Order.
- The ship_to_location_id is populated in ap_invoice_lines_all but fails to appear on the screen in the ship to field.
Match invoice to PO
Check invoice line ship to field... it's NULL
Why is it not showing on the form?
Where location_id = XX;
NOTE: if the above query doesn't return rows then check how is it being used in receiving when the location details are absent in HR.
As per current payables supported code, ship to location must be part of the inventory setups of an organization and hence should be present in HR_LOCATIONS_ALL.
HZ_LOCATIONS is for external suppliers and has least to do with ship to location. For drop ship sales order, we need information from purchasing which ship to location is being considered. Ideally it should come to the inventory or the ship to location defined in Financial options or at supplier site.
The drop shipment sales order is created first, the PO is created from the drop ship. If the PO has an invalid ship to location, then it is coming from the drop shipment.
For a drop-ship Sales order a PO created automatically inherits the location from the Sales order.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document