Adding a Lot Number field to the Period In-transit report

Hello,

My client is using Actual Costing, with a Valuation Structure of Cost Org-Inv Org-Lot.

They would like to customize the Period In-Transit Valuation report, by adding a Lot Number attribute, to be able to see exactly which Lots are being in-transit at the end of the accounting period, with their accosted cost.

Upon reviewing the in-transit tables (CST_INTR_ONHAND_VALUATIONS and CST_INTR_ONHAND_DETAILS) I couldn't find any field which I could use to match to a Valuation Unit (CST_VAL_UNITS_B).

I am looking to see - from an in-transit perspective - this this requirement can be fulfilled.