Ideas

Below are few scenarios because of which the Inventory Movement is not able to pick proper Rate in transaction creating mismatch in valuation / GP related report.

Scenario-1

Goods Send from Org Site A to POS Site B

POS Site B is returning the goods to a Return Org Site C

As there was no Advice , Rate Pool available against Org Site C in POS Site B it will pick RSP / MRP (+/-) Factor from Site Master. 

Thus the Transfer Document will be create difference in between the Inventory & Finance related posting.

Solution:

Instead of checking Site Master the definition of Replenishment Return Rate should be checked in case of GR transactions. In case of Last Inward Rate it should be not consider the Advice against any specific Org or POS Site.

Scenario-2

Goods Send from Org Site A to POS Site B (Franchisee Site)

POS Site B is returning the goods to a Return Org Site C

As there was no Advice , Rate Pool available against Org Site C in POS Site B it will pick as per the Return Rate Logic from Replenishment Source.. 

Against this record the INVSTOCK Cogs would be populated as per Standard RATE, whereas it should consider the Last Inward Rate. Thus difference between Standard RATE & Actual Landing Rate is giving wrong Stock Valuation and corresponding transactions are also wrong from Org SIte C.