We are using Average costing, and the leadership would like to have a Purchase Price Variance report.
Is anyone in the same situation?
Has anyone developed a BAQ or a SSRS report for this seniario?
Any help would be apprieciated.
Thanks
We are using Average costing, and the leadership would like to have a Purchase Price Variance report.
Is anyone in the same situation?
Has anyone developed a BAQ or a SSRS report for this seniario?
Any help would be apprieciated.
Thanks
Do you have a GL Control code that points to a separate GL account for PPV? I think that would be the easiest route.
Yes, we have a few we can use.
I’m not the strongest with GL reporting, but I would create a GL account report with the detail from the PPV account.
Curious on how leadership defines a variance in an average cost world? From the Inventory Transaction Hierarchy, I only see the PPV account used for Standard Cost parts.
PartTran will hold the answers though. If they’re looking for the difference between the current average and the new average, one would look at the PUR-STK records (not including insp, etc.)
If they want the difference between PO and AP Invoice, then you can look at PUR-ADJ records.
I believe what they are looking for is to set a price (which might have to be a UD field) on Jan 1, then compare current PO / receipt price to that set price.
This would provide information to satisfy both Operations and Financial.
Financial would stay in the average costing per accounting practices, and Operations would be able to see variance from a base line price.
The other option is to always compare last price to current price and display the history of it.
A Standard Cost then?
This may be a place where another Cost ID might work so you wouldn’t have to create a UD field. There was a recent discussion on the list within the last week or so.
Very good point, I haven’t looked at the table yet, and now that I have, I will test it.
Thank you
You can populate standard cost in Epicor even though average cost is the selected cost method for the part. If you don’t manage that cost there may be issues though. If there is PPV and you’re using average cost, the cost of your inventory will creep up, even if you are passing on the PPV to your customer through sales orders. If you are using average or FIFO average cost for your manufactured parts too, those costs will creep up on you and margin analysis will suffer greatly.
So we are looking at just biting the bullet and going standard cost across the board. Then PPV will go into a variance account and we can relieve that account by billing the customers. PPV is supposed to be transitory so the ‘normal state’ of cost and pricing should remain.