Why are you doing it in the first place?

Use Vendor Contract Costs.

because you can place a PO and it be a month (or more out) and then have vendors update costing after PO is placed.  Then when that old PO comes in, it screws all your costing up again.  Or, if you get a one time special price, you don't want it to affect your everyday price.   It's a very common situation that any distributor should be facing.

Maintaining in vendor contract prices would be a huge drain on time.  

because you can place a PO and it be a month (or more out) and then have vendors update costing after PO is placed.  Then when that old PO comes in, it screws all your costing up again.  Or, if you get a one time special price, you don't want it to affect your everyday price.   It's a very common situation that any distributor should be facing.

Maintaining in vendor contract prices would be a huge drain on time.  

1. The costs from an old PO don't change when you receive it.

2. Set your PO Options/Processing/Default Item Cost to Vendor Cost instead of most recent.

our options are set like that.  It's not the PO that changes.  

If I place a PO for item ABC for $2 each (vendor table say $2 each), and 4 days later the vendor says all future prices are $2.50 each so we update the vendor tables; the PO still comes in a month later with the $2.00 cost and at day end, the vendor table gets updated back to $2.00 each automatically.

I just want it to stop the receipts from automatically changing my vendor tables.  We only want that table affected when we manually update them.

If it's not possible, then so-be-it; just thought I'd ask if I was missing something.  There should be an option to turn it off.  I'll add to the sage ideas site.

Question really is whether you hold the vendor to the contracted (PO) cost or not.  if not, then maybe talk with someone to customize something to update your open PO's .. TaiRox may be able to help with this, they've done a lot of specialized things.. check tairox.com and look at productivity suite.

of course we do.  If you place something for $2 and they acknowledge, then the price is $2.  it doesn't matter if it takes 2 days or 2 months to get to you.  

I'm not sure of any distributor that would place something on order and just accept a price increase mid-process and not have proper controls over their tables.  

We use those tables to quote out customers and set list prices for next year.  We keep them up-to-date and clean, so when something just automatically overrides your work, you find a way to stop it.

Mike, I agree with what you are saying. IC day end updates the vendor cost in IC Vendor Details and there is no setting to stop that. I have other clients with exactly the same problem. There should be an option to allow you to select if you want the vendor costs updated or not.

www11.v1ideas.com/.../1480

Maybe a SQL Trigger to prevent the update

Actually Vendor Contract Costs work perfectly, as the others have said use that instead of Vendor Details.

The Vendor Contract Costs are not changed by IC day end processing and these costs are used when you create a new PO.

It means setting up the vendor contract costs once vs perpetually maintaining vendor details - I know what I would do.

Since you seem to be doing a lot of export/import anyway you can create an import file for Vendor Contract Costs and import them - that should be a no-brainer.