Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I'm looking to create a UDF lookup to the AR_Customer on the Lines tab of GL General Journal Entry. I haven't been able to use oUIObj.InvokeLookup with a button because it throws an error stating Object required: oUIObj. Because it's on the detail and…
I'm looking to create a UDF lookup to the AR_Customer on the Lines tab of GL General Journal Entry. I haven't been able to use oUIObj.InvokeLookup with a button because it throws an error stating Object required: oUIObj. Because it's on the detail and…
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
Hello all!
I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…
Hi
I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank .
Later when there is an update on the Date…
I need to run all the following in sequence
1 Run MS Access Macro - I have a bat file that does this nicely
2 Import data into 'Production Entry'- I have a VI Import job that works
3 Launch 'Production Register Update' panel - I see this can be…
Hi All,
I am trying to enter a Sales order in Sage 100 using BOI with .Net program, I have the problem to handle the "Entry exceeds available quantity" pop up. I am searching for a method but I am not able to find it.
Is anyone has an how I can…
I'm trying to write a button script that will copy a single line from a SO and "pull" it into the open PO. I've done this successfully for SO (copying from Invoice or SO/Quote History), but with PO, I'd like to be able to "tie" the SO and PO together…
i am trying to update a UDF in line level using script on a button click
Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…
Hello,
I am trying to write a script for lookup button in order to pull the salesperson data. I only want to pull the salesperson data whose division number is “00”. How can I pass ARDivisionNo as parameter? Here is the script which I am working on…
Hello,
I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…
Hi
I am new in BOI integration with the C#, Can anyone share with me sample code for the delete a record from the Sage MAS 90 using C#.net?
Or if you have any good reference document please, I google much about I did not find anything helpful.
Please…
Hi All,
Is there a list of the properties for the various control types? I am trying to work with Text labels using oUIObj.SetControlProperty(ctlName, propertyName, value),. I would like to hide labels based upon data on the screen to display the…
Hello and thank you in advance for your help and advise.
I am trying to create a program that uses the BOI to insert a RMA at the time of arrival. The issue I am running into is the BOM is set to "inactive" in Bill of Materials Maintenance.
What…
I have a script that is triggering on table pre-write of the SO_SalesOrderHeader. The script is triggering during invoicing, since the table is updated. Is there a way to make an exception and prevent the script from triggering during the sales journal…
While the Table Pre-Write and Post -Write Events can handle when a user exits a line, I need to set Line UDF values as soon as a user selects any field in a line grid.
Any ideas?
Hello All,
I've written a script where I'm creating new customer accounts. I'm also looking for a method that will allow me to add these newly created customers as Sold To customers, but can't seem to find the answer in the materials. Anyone have…
I have an MS Script that runs when a button is clicked inside Invoice Data Entry. When the script is completed I want it to click a hidden button for me to finish up the Invoice. This used to work just fine when the script was run on the client, but now…
