Sage 100

I am trying to import some data into Sage but after initiating the script object, when i try to newObject 'SY_Session', it fails. On server it works fine but on clients it fails. I checked the security settings, the user has full access to MAS90, and…

Hello All, I'm using the code below to determine whether volume pricing exists for an item, but I'm getting a retval of 0 when I know there is pricing configured. My code and the record from Data File Display and Maintenance are below. Also, I have…

Everything works on the script except for the line that calls for the print oRpt.Printout (I tried oRpt.Printout(FALSE) but then nothing happens at all) The line actually technically works, but instead of just printing the the default printer, the…

I am trying to look through the records in the following business object with the code below. However it is failing at the MoveFirst call. This same logic has worked for other files IM_ItemCost, AR_Customer... is there an issue with this object or…

Sage MAS 100 ERP Premium 4.50.7.0 running on MS Windows Server 2008 R2 We are attempting to convert a script that prints a Sales Invoice to a physical printer to instead output the Invoice as an e-mail with PDF attached. For the user we have successfully…

I've written a script to write field values out to a UDT and record a Date, User, and time so that we can have an audit trail of these fields in PO Header. The audit trail is written whenever a there is a change to the PO. This works fine for manual…

Hello Sage Community, I am having an issue with a Column Post-Validate event on the Sales Order Detail screen that I'm hoping someone can help me with. My goal is to have a user-defined script execute on on the Column Post-Validate event of the "PriceLevel…

I need to look up an item while entering a sales order and determine whether there are any FIFO tiers over 90 days old. So far I've been able to use the .movefirst and .movenext methods to accomplish this, but performance is poor. Is there a way to jump…

Hello, Been a while since I posted anything, and I think I may have posted this example before, but another question on GetResultSets just reminded me of it, and I thought someone might find it a useful reference. It is basically a VB .NET console app…

HI All, I'm trying to export out the field values in double quotes.I was testing out something The code is retval = obusobj.GetValue("InvoiceNo$",InvoiceNo) InvoiceNo = """InvoiceNo""" msgbox InvoiceNo Let's say the invoice no is 0000001…