fionad
27th September 2012, 21:28
when a receipt for a sales return order is processed, the cost of goods normally gets logged in whina113 (Inv Rec Trans - Cost details).

i would like to know the linked tables from which whina113 gets its details since i have archived the data backend in datawarehouse for orders more than two years.

i retreive the following data if i need to create a sales return against any of the orders

tdsls400 (sales order header)
tdsls401 (sales order line)
whina114 (inventory receipt transaction consumptions)
whina115 (inventory receipt transaction consumptions cost details)

but when i confirm the receipt the inventory receipt transaction line (whina1512m000) shows zero amount. Also the costs are not logged in whina1513m000.