We do not use a supplier price list, and we would like to pull the unit price from the part master. Could you please let me know where to enter the part price so that the same price appears in the PO line and also in PO suggestion?
In the supplier price list.
The price on the part master is the selling price not the purchasing price.
I’m pretty sure it will return zero if there is no supplier price list. I don’t think there’s a purchase price field in the Part Master at all.
It might bring in the cost if you have a part set to Standard Costing, so you could give that a try. If that doesn’t work (I don’t expect it will), you could create a purchase price field like “Part.PurchasePrice_c” in the Part UD Table, and use a Method Directive on PO.ChangeDetailPartNum to retrieve the value from that field.
Seems like a lot of work when you could just put the price in the supplier price list though.
Why don’t you? That’s the best place to put the purchase price.
Yeah… I should have followed that up with “But Epicor provides the functionality to get the price with Supplier Price List, so that’s what I’d recommend.”
Helptext doesn’t seem to imply any options…it’s either the supplier price list or it’s zero.
EDIT - looks like there’s an import/export file function available…so might make it easier to implement than mods to PO entry etc…just a thought.
we are using standard costing
Costing and pricing are different. You can be standard cost, but have different purchase price.
That said, i dont believe that you “must” use the supplier price list. If you dont have a price list defined, the system will default the price to the last purchase price on a purchase order.
Could you please explain why the previous price did not appear when I entered the same part number in the PO again, even though I had entered the price in the PO previously?
Has the part been received at least once prior to adding a second time?
Could you please explain why you refuse to use supplier price lists?
Well… I think it is HOW the PO is created. when PO Suggestions are created, this is when the default is used… but if you are creating the PO manually, i dont believe that it works the same way. Are you using PO Suggestions?
We use both PO and PO suggestion
May I know where the PO suggestions get the unit price for a purchased part?
Here’s a thread on topic from the E10 section…reads like it’s Supplier Price List as default value…if not found, checks last PO price for that supplier/part…else 0.
This setting in Company Configuration may impact if a last price gets pulled or not for PO Suggestions:
@sk.patchai , why can’t you use supplier price lists?
Using a supplier price list does nothing to any GL accounts or anything in standard costing.
It’s a price that buyers can keep so that their POs generate to the price lists their suppliers give them.