Sage 100

 View Only
Expand all | Collapse all

MAS v4.4...we have written a BOI script that works

Wayne Schulz

Wayne Schulz08-02-2012 07:18

Wayne Schulz

Wayne Schulz08-02-2012 07:22

Scott Hickman

Scott Hickman08-02-2012 07:25

Brian Buck

Brian Buck08-02-2012 11:56

  • 1.  MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 07:13
    MAS v4.4...we have written a BOI script that works in MAS90 v4.4 on our test system without issue. We we try to run it on the clients MAS200 v4.4 environment we get the following error and the script fails: OLE Error Number: 424 Description: Object required: "" Language: VBscript Script Line: 88 Script Column: 4 oPrice = oSession.GetObject(""CI_Item.bus"") Any idea what could be going wrong or why it is different on MAS200 than MAS90?


  • 2.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 07:18
    Allow external access? Just had this


  • 3.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 07:21
    Yep, checked that. We have allow external access enabled in company maintenance.


  • 4.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 07:22
    Run on server vs client


  • 5.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 07:25
    Yep...tried that too. I am trying to find my notes from last years Summit session on BOI...I think I have tried everything from memory.


  • 6.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 07:25
    Post your script


  • 7.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 08:16
    Are you running this as a Button Link, Advanced Scripting (fires on an event), or just a CScript/WScript?


  • 8.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 08:20
    @AaronClark we are running from a button link on a screen. @ScottHickman I will post the script shortly. My vb person is troubleshooting it some more.


  • 9.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 08:32
    Just saw it: should it be CI_ITEM_BUS (or CI_ItemCode_BUS), not CI_ITEM.BUS? Although, why that would work on MAS90 and not 200 is beyond me.


  • 10.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 10:35
    Aaron, that might be just be my typo when typing the error back on the screen.


  • 11.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 10:54
    Ahhh... well. Darn. Thought I had the answer then. Did you get this figured out?


  • 12.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 10:55
    Not quite yet figured out. My vb girl is going through her code again. I will keep you posted.


  • 13.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 11:41
    my ""vb girl""????? Is this like your ""Bond Girl""....................


  • 14.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 11:48
    Jeff I do not know who she is - but she is KILLING me with the suspense... I have to see that code! LOL.


  • 15.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 11:50
    I have attached the script. As I said they work fine in a MAS90 environment but we get the error (also attached) in a MAS200 environment.

    Attachment(s)

    txt
    script_Update_InvCost.txt   1 KB 1 version


  • 16.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 11:52
    It looks like you are trying to update the standard cost. You cannot do that in 4.40 and above if the item has history.


  • 17.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 11:55
    I thought you could if the items are FIFO? Plus it worked in the MAS90 4.4 environment...We could see it successfully update the standard cost on our MAS90 4.4 w/ FIFO items.


  • 18.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 11:56
    Hahah...very funny @JeffSchwenk .


  • 19.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 11:58
    Is there some additional code where you are initializing the oSession object?


  • 20.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 12:01
    No there isn't Scott. Is their something we have to do differently with it for MAS200?


  • 21.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 12:08
    Seems like every time I had an issue with 200/90 is related to the path. ie., 90 was using a mapped network drive to the server whereas 200 was using a local drive on the server. I assume this is a script being launched from a custom office button or a MAS event?


  • 22.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 13:33
    Okay...we fixed the path to use a UNC on the button that launches (see attached), but now a new error. It looks to be a DSN issue even though we have the DSN setup on both the server and the workstation as a system DSN. Getting closer but still stumped.


  • 23.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 14:55
    Can you use the connection string instead of a DSN?


  • 24.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 14:56
    Are you trying to connect to a 64-bit DSN from a 32-bit application?


  • 25.  RE: MAS v4.4...we have written a BOI script that works

    Posted 08-02-2012 15:32
    I will try to find the connection screen and use that instead. We are calling data from an Access database. I am pretty sure we are using the 32-bit DSN on both the server and the workstation.