Sage 100

 View Only
  • 1.  v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 12:31
    v4.4 Advanced - Using average cost inventory valuation. They want the purchase order line item to pull the standard cost. Anyone know how to do this?


  • 2.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 12:39
    From Sage themselves - set up the std cost in Vendor Price Level Maintenance


  • 3.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 12:53
    That's what I thought... but seems ridiculous if that is the only option. You have to specify every time you add a vendor... in addition to populating every existing vendor.


  • 4.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 13:08
    Yep..... Of course the good thing is that if you can get price lists from your vendor you can VI when there are updates and you know it will start using the new cost when it should (instead of waiting until after the first ROG).


  • 5.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 13:13
    Thanks @BethBowers ! Looks like an export of the vendor table then a VI import to the PO_VendorPriceLevel.


  • 6.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 14:45
    Script???


  • 7.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 15:26
    @JeffSchwenk Good idea... let me start now... I've got nothing better to do for the next 6 hours.


  • 8.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 15:33
    @DougHiggs - oh, I love you man - that's how I feel about scripting.


  • 9.  RE: v4.4 Advanced - Using average cost inventory valua

    Posted 09-24-2014 15:35
    I hear you. On hour five of working with Sage tech support trying to get workstation to work on WIN 7 Pro.......... TG my wife is working late.....