Saved search to import data from inbound shipment page

Jira code: ME-150

This saved search is used to filter out the data from the inbound shipment page as there is no standard report for this. To select a single inbound shipment page and all the line item details will be listed in that saved search. Due to the multiple currency features by standard, the columns in this page will show converted base currency values.

Saved search record type: Inbound shipment

Criteria: internal ID

Available result : internal ID

Result:

Shipment Number
Items – PO
Items – Item
Items – Description
Items – Vendor
Items – Receiving Location
Items – Quantity Received
Items – Quantity Expected
Items – Unit
Items – Unit Landed Cost
Items – Total Unit Cost
Items – Currency
Items – Exchange Rate
Formula (Numeric)- ROUND(NVL({porate},0)/{itemexchangerate},2) label : PO rate
Formula (Numeric)- ROUND(NVL({expectedrate},0)/{itemexchangerate},2) label :Expected rate
Formula (Numeric)-ROUND(NVL({quantityexpected}porate},0)/{itemexchangerate}, 2) label: Amount.

Leave a comment

Your email address will not be published. Required fields are marked *