Greetings,

D you know if any of the method calls to SY_Session failed (SetUser, SetCompany,etc.)?  You should specify a return value and check to see if any of them fail what the error message returns.  Also, make sure the user you are specifying has rights to Sales Order.

Thanks,

Kent

Greetings,

D you know if any of the method calls to SY_Session failed (SetUser, SetCompany,etc.)?  You should specify a return value and check to see if any of them fail what the error message returns.  Also, make sure the user you are specifying has rights to Sales Order.

Thanks,

Kent

Everything is Good up to this point.

This line returns 100004

retVAL = oSS.nSetProgram(oSS.nLookupTask("SO_SalesOrder_ui"))

This line hangs up

soORDER = oPVX.NewObject("SO_SalesOrder_bus", oSS)

The odd thing is I can Create a GL object and an AR Object but can't create an SO Object. Seems like a setting or permissions problem. Although the user has Full Admin rights.

Double checked the user. He is an admin. Been on the phone with Sage to try and get help. They told me to use Sage City....lol.

Also the error 65 is only found when using a try catch block. MsgBox(oSS.sLastErrorMsg) is not working because it just hangs up at that line and never gets there. i saw the same thing when i was trying to instantiate the session object using a path to the Workstation "home" directory instead of the Server "home" Directory. I saw mention of settings to allow external access. Could someone elaborate on that?

the Allow External Access Option is selected in Company Maintenance and must be checked for each company in order for BOI to work.

Also, if this is MAS 200, what happens if you run your code directly on the server instead of from the workstation?

Thanks,

Kent

I'm not sure what you mean by run it on the server Kent. Install the vb.net application on the server?

We did check the setting for External Access. turned it off and got an error. Turned it back on and it allowed the connection.

Found the Problem. I was pointing to the wrong folder. I copied the UNC path during the workstation setup. It was the wrong path. Was using "oScript.Init("\\####\Apps\Sage100ERP\v430Copy20140316\Mas90\Home")"

When I should have been using "oScript.Init("\\####\Apps\Sage100ERP\MAS90\Home") "

The odd thing is that it was allowing the creation of a GL object and an AR Object. But failing when creating an SO Object. I was also able to get back the information of the company and the users access on these lines.

MsgBox("Read Access:"& CStr(oSS.oSecurity.nReadAccess)& vbCRLF &_

"Create Access:" & CStr(oSS.oSecurity.nCreateAccess)& vbCRLF & _

"Modify Access:" & CStr(oSS.oSecurity.nModifyAccess)& vbCRLF & _

"Delete Access:" & CStr(oSS.oSecurity.nDeleteAccess))

All of these things worked. Just not the SO Object creation. Hope this helps another newbie.