Skip to main content

Stock Booked In At US Dollars Price not GBP Sterling when viewing LOT records

Written by Charnjit Singh Dharival

For Part 1234A and Purchase order 12345, this product is purchased in US Dollars (USD). Checked the Purchase Order (PO) and it shows USD. But when the item was booked in, it had been booked into stock at the USD PO price of £3.30 rather than the Sterling price of £2.50. We received 10500 against this item and the nominal is showing a value of £50k which is the correct sterling value, but the stock is showing as valued at the USD Price.


The LOT cost is 3.30 (the USD/foreign price) rather than 2.50 (the GBP/base price), since the goods receipt code correctly references POR-VAL (base currency), this means POR-VAL on the PO line record for PO 12345 contains the foreign currency value (3.31000) rather than the converted base currency value (2.51272).

This is a data-level issue on the POR record for this purchase order. The most likely cause is one of the following:

  1. The PO was created through a code path that didn't apply the exchange rate conversion to POR-VAL. For example, both POR-VAL and POR-FOREIGN-PRICE are initially set to PMA-COST-MAT (the same value). If the subsequent currency conversion logic was bypassed (e.g., price source wasn't "1", or the currency code wasn't properly set at that point), POR-VAL would remain equal to POR-FOREIGN-PRICE.

  2. The exchange rate was modified on the PO header after the lines were created, but the recalculation of POR-VAL on the individual line items was not triggered or completed.

  3. The PO was imported or created through an automated process that set POR-VAL to the foreign price without conversion.

Did this answer your question?