We have a requirement in vendor consignment process , Generally in MB1B -411K movement type price will pick from Purchase info record . But here our client requirement is system should pick the price of GR 101k date .
For example PIR maintained 01.10.2017 to 31.12.2017 is 10 USD and 01.01.2018 to 31.03.2018 is 15 USD .
Schedule agreement created on 10.10.2017 for 1000 qty and material received till 31.12.2017 with movement type 101K is 600 qty as a vendor consignment and with MB1B -411K transfer posting to own is 400 qty and price picked from PIR is 10 USD .
Now my client wants to receive remaining 200 qty with MB1B-411K on 10.01.2017 for this system will pick the pir price 15 USD , But client requirement is price should pick based on the GR 101 K document date . That means GR done on 10.10.2017 and pir price maintained in that period is 10 usd .
So finally the requirement is MB1B -411K transaction should pick price from PIR based on the GR 101K date not on MB1B -411K document date .So please guide me how to achieve this requirement .