Day-End updates Vendor Costs - Stoppable?

SOLVED

Day-End will update your vendor costs based on the receipt costs from that day.  Does anyone know if or how to stop that from happening?  Currently we run a macro to Export the vendor tables, run day-end, then re import.  Would be nice to simply avoid the need to do this.

Thx

  • 0

    Why are you doing it in the first place?

  • 0 in reply to Jay Converse Acumen

    Use Vendor Contract Costs.

  • 0 in reply to Django

    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.  

  • 0 in reply to Mike Cook

    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.

  • 0 in reply to Jay Converse Acumen

    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.

  • 0 in reply to Mike Cook

    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.

  • 0 in reply to Scott Schreiner

    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.

  • 0 in reply to Mike Cook

    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.

  • 0 in reply to Ettienne Schwagele

    Maybe a SQL Trigger to prevent the update

  • 0 in reply to Mike Cook
    verified answer

    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.

  • 0

    Hi Mike,

    My understanding is even the receipt did by warehouse guys and the transaction is post only after day-end. in fact when the day-end the liability is in the clearing account and will transfer to the vendor AP after invoice is keyed and posted. I may misunderstand your question, why do you ask to stop that happens?

    thanks

  • 0 in reply to Sage300

    @Sage300.  no, you have completely missed the point.  I'm only talking about the PO receipt cost automatically changing the ICITMV table.  that's it.  Nothing to do with A/P or inventory costing.  It's just the vendor cost table that I want to stop touching.

  • 0 in reply to Mike Cook

    Sorry, just a follow up to using the "Vendor Contract Pricing".   The big downside with that is that you can't have a vendor used more than once for a given item.  We use this a lot as well for some vendors that we order hose from.  They can have multiple SKU's for the same hose to separate specific lengths.

    The Vendor contract pricing could be SUPER usable if it allowed something like that.  That would also allow us to insert future price increases.   Maybe the price today is $2, and we know that in May 2015, it will jump to $2.50, we could just insert that now, if the table allow multiple instances of the same vendor code.

    Anyways... beating a dead horse here.  Thanks for your input guys.  

    We are just going to change how we are doing it now.   Currently we have a day-end script to export the table using the Export function, then run day end, then import it back in.   With our upgrade in a few weeks, that might break the script(?), so we are going to redesign it to do the dump as an SQL and avoid using the Export/Import function.  should save about 20 minutes in the whole process.

  • 0

    Hi Mike

    I know this is an old thread.....but we have a client that is now complaining about the exact same thing. 

    Did you ever find a resolution to this? 

  • 0 in reply to Rene J

    nope, we just have a custom day-end script that will export the vendor tables, run day-end, then re-import the tables to ensure nothing is changed unless we update ourselves.