Dear Community,
We are dealing intercompany scenario, please find the details below
When we purchase from our second company, unit price on PO always equal to the average cost of inventory available at selling company.
Let say 2 companies, p1(purchasing side) and S1(Selling company).
I created a PO in P1 with 10 quantity. On hand inventory was 0 at S1 so i created a movement journal in S1 with cost 100 and qty 5 which means avg cost is 100 now.
Then i created a partial invoice in S1. After that i did i receipt in P1 for 5 quantity i.e. unit cost is 100.
Then i created a movement journal for 5 quantity with cost 200 and invoiced the remaining quantity in S1 with cost price 200. Complete SO is invoiced now.
then i receipted the other 5 quantity in P1 with unit price 200.
QTY Cost/Price
Sales invoice1 5 100
Sales invoice2 5 200
Product Receipt1 5 100
Product Receipt2 5 200
Now when i tried to create purchase invoice for receipt1, system is picking unit price 200. This 200 unit price system picks for both receipts.
Is there any parameter that can resolve this matter?
