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…
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 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…
I want clients to see this in the email they receive when sent an invoice:
Past Due Balance:
Total Balance Due: (which includes past due and New charges)
Client Funds Balance: (retainer)
I am accomplishing this by inserting data tokens into…
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…
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…
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…
I would like to change the scripting language in an event in a Form Script Editor, when when I change the Language pulldown menu from VBScript to JScript, I get an error dialog with the text
Script language changed. Modify existing script's syntax to…
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…
Hello,
I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt)
The field is currently showing six decimal places on items related to labour (i.e…
Hello,
I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt)
Each field is currently showing…