Scripting

  • 1.  I need to update Vendor Price Levels. Does anyone

    Posted 02-22-2017 11:04
    I need to update Vendor Price Levels. Does anyone have any samples for an external BOI script? This is not an object that I have dealt with in the past.


  • 2.  RE: I need to update Vendor Price Levels. Does anyone

    Posted 03-01-2017 14:29
    Did you ever get anywhere with this? I always just used V/I, but adding/editing with BOI shouldn't be too tricky.


  • 3.  RE: I need to update Vendor Price Levels. Does anyone

    Posted 03-02-2017 11:44
    I am currently working on another aspect of the application so I have not made the dive yet. Should not be a major deal. I had not seen a script example so I thought I would ask as a short cut in development time. I will post once I get through it.


  • 4.  RE: I need to update Vendor Price Levels. Does anyone

    Posted 03-14-2017 09:56
    This was really simple. Code is hard coded for this particular purpose to Item-Standard Cost specific pricing. I may create a function for it to be flexible for all pricing methods in the future but this worked for the limited scope that I had in my project. Obviously just a snippet and does not include oSS session or variable DIM and assigns. retval = oSS.nSetDate(""P/O"", ""20161231"") retval = oSS.nSetModule(""P/O"") retval = oSS.nSetProgram(oSS.nLookupTask(""PO_VendorPriceLevel_UI"")) Set oVendorPrice = oPVX.NewObject(""PO_VendorPriceLevel_bus"", oSS) retval = oVendorPrice.nsetkeyvalue(""APDivisionNo$"", PrimaryVendorDiv) retval = oVendorPrice.nsetkeyvalue(""VendorNo$"", PrimaryVendorNo) retval = oVendorPrice.nsetkeyvalue(""PricingType$"", ""I"") retval = oVendorPrice.nsetkeyvalue(""ProductLine$"", "" "") retval = oVendorPrice.nsetkeyvalue(""ItemCode$"", ItemCode) retval = oVendorPrice.nsetkey retval = oVendorPrice.nsetvalue(""PricingMethod$"", ""S"") retval = oVendorPrice.nsetvalue(""DiscountMarkup1"", VendorPrice) retval = oVendorPrice.nwrite