Hello everyone
When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched.
Is there any way to create SQL triggers so that they are protected? Like activity codes…
I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed.
I am now receiving an error 88 type mismatch (error window below). Any thoughts?
START OF CODE
Dim retVal Dim cpwgt Dim cpwgtstr Dim…
I have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions.
One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…
Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…
From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card.
First I actually…
I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.
Essentially, instead of the user typing the invoice # they would type the sales order…
I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…
Hello,
I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query.
This needs to be run on the Client…
Hello All,
Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table.
I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
Hello,
I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…
Hi All,
I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend.
Thanks
AJ
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…
Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company.
I know how to do it outside of Sage with a script but not sure if session to different…
Hi Folks,
my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend.
is there a way to create…
Hi all,
I have recently created a script for the field "invoiceDate" that restricts how far into the future a user can enter the date for. I am wanting to apply these restrictions as well for the posting date. This should be relatively easy, except…
I located KB 19387 which describes how to create a batch file to run a VI import program. The routine requires the name of the the VI job which is readily available on the job listing and panel.
I'm thinking I could use the same/similar batch file format…
When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL.
When I execute the query in SQL, it returns the correct results. For example:
When testing the same…
I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below:
retVal…
I'm trying to add an MS Script button to the SO Invoice Data Entry panel. In the script I need to access the LOCAL cCurrentPaymentTypeMethod$ property inherited from Class SO_CommonEntry_UI. Can this be done and, if so, how would it be coded?
I need an executable to run when the client Posts AP Batch to the Invoice Register. I cant add a user defined script to the AP Invoice Registry screen because i cant get to it with Customizer. Is there a way to get around this?
I have a script that works unless the field "UDF_EXCH_RATE" is zero. (default value is .000000)
Where do I place the "if" statement to get it to work?
tmpAmt = 0 : tmpExchange = 0
retVal = oBusObj.GetValue("ExtensionAmt",tmpAmt) retVal = oBusObj…
Hello all,
I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join:
((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…
Hi,
We have a script on Invoice detail which sets the Extension Amount on the line, the current trigger for this script is "Column-Post Validate" on "ItemCode". But when we generate invoices using AR Repetitive Invoice Selection, the script doesn't…
Does anyone have a very basic example of how I can integrate a SQL statement in to a script?
I've run into plenty of occasions where I wish I knew how to accomplish this, here is my current goal:
We ship using Starship and for a variety of reasons…