Simple Current Price?

Epicor ERP 10
1

I wanted to ask before I get too deep into re-inventing the wheel here.

I have a BPM created that will update the Sales Unit Price (Part.UnitPrice) whenever the Base Unit Price (VendPart.BaseUnitPrice) is updated. A bunch of conditions on primary supplier, effective date, etc.

Is this my simplest route to be able to retrieve the current price for a part? My entire BPM is functioning but im stuck where if a part is set to be effective in the future, the BPM will not trigger to recalculate the Sales Price. I was going to make a scheduled task in powershell / dmt to scan for these future effective dates daily if I cannot find a better solution.

I have more info on my BPM if you wish to see.

2

No answer, just curious.
Are your Part.UnitPrice’s calculated as (VendPart.BaseUnitPrice * some std percentage)?

3

queryRow.ttVendPart_BaseUnitPrice * ((queryRow.Part_SalesPricePer_c / 100) + 1)

SalesPricePer_c is UD field that has a default of 50.00

image

4

Thanks.

Just a coincidence that part cost/price maintenance came up (again) earlier in the week.
And on a related note, I discovered some selling price discrepancies due to salesreps who duplicate sales orders. The process does not check to see if the Part.UnitPrice has changed since the original order was created (in V8 at least)

5

Main reason I started this is because we have two issues.

  1. Sales Prices only plug into sales order when they exist
  2. Sales Prices are not maintained in the system and can become out of date

Unfortunately I cannot find a way for the system to take care of this traditionally, unless i’ve missed that. We would pour a lot of time into maintenance without this, so currently, sales prices are just calculated at the time of order, by hand.

My BPM generates sales price whenever our Supplier Price updates.