Hi There
I have two different scenarios when creating a purchase order:
- The rate on the PO is equal to the last purchase price
- The rate on the PO is less than the purchase price--item is created by being copied from existing item
Fictitious data in a demo account
A new item is created
Stock is adjusted for this in one location:
A purchase order is created
The rate on the purchase order is equal to the value per item that was added to the inventory
This is what I would expect.
However, when the item is copied from an existing item, even though the values are all the same for the stock adjustment, location, etc, the rate changes to a different value that is not equal to the rate from the stock adjustment:
The rate on the purchase order (for a new item that was created through the copy function)
The item record:
Location details on the item record:
The only transaction for that item:
- Where is the rate on the purchase order sourcing from if not from the average cost (since that is the inventory valuation method selected)?
- Why is there a difference in behaviour of the item is created as a new record vs a copy of an existing item as the pricing details shouldn't be copying across from the original item from what I gather.
Note: There is no preferred vendor. Multiple vendors were tested on the PO and it consistently had the same behaviour: the copied item was showing a rate of $110.59 while the item created completely from scratch was showing a rate of $126.29 (this being the last purchase price)
Thanks