You’re offline. This is a read only version of the page.
Announcements
100
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?
Hi Arslan,
I see.
Where did you get the cost price of $200 for your transfer order?
How can the system pick up such a price if you have entered before a cost price of $100?
Do you have other transactions posted apart from the ones that you listed or is this the result of a modification or possibly a bug?
Best regards,
Ludwig
valution method is moving average and i didn't run recal
Unit price on ICO PO was 100 at the time of first receipt and 200 at the time of second receipt.
It always picks the cost from SO as unit price on PO
Hi,
Can you share details about those movement journals and how you entered the data?
What about the valuation principle of the item in both companies? What method have you setup (FIFO, LIFO, etc.)?
Have you run an inventory recalculation in both companies to see if this makes a difference?
Best regards,
Ludwig
Hi Arslan,
Cost in P1 may be driven by running average cost of the item in S1 (except for standard costed items) but the price on PO invoice is determined either by base sales price or trade agreement one in S1.
What's unit price on that ICO PO before and after the second product receipt?
#1
André Arnaud de Cal...
293,998
Super User 2025 Season 1
#2
Martin Dráb
232,850
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
