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 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…
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…
When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
I have a script to delete CSP pricing on the IM_PriceCode table. I was wondering would there be a way to run this script outside of SAGE say from Task Scheduler?
Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…
Hi
We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF.
I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…
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…
Hi Forum,
I cannot seem to find a way to update the AP_InvoiceRegisterWork table and AP_InvoiceRegister.upd.
We have a Vendor that need to print checks to with different Names. One vendor hundreds of different Names the invoices need to be updated…
I created this script for sales order detail lines that works if I key a number into the backordered quantity field but does not work if I tab past the field with no entry.
tmpQtyOrd = 0
tmpQtyBkOrd = 0
retVal = oBusObj.GetValue("QuantityOrdered…
running Sage 2018 sp3.
I have this script running on quantity shipped in SO Invoice Data Entry.
tmpQtyShip=0 tmpGrWt=0
retVal = oBusObj.GetValue("QuantityShiped", tmpQtyShip)
retVal = oBusObj.GetValue("UDF_GROSS_WEIGHT", tmpGrWt)
retVal = oBusObj…
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…
Using Sage 100 Premium 2017
Using Crystal Reports 2011
I have six production SQL databases, all structured identically (for regional purposes).
I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…
Hi All,
Is there any way we can increase the decimal points from 2 to 4 of a numeric field or any standard field?
Please help if anyone have an idea.
Thanks,
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…
Currently I can set the default ShipDate on SO_InvoiceHeader using Custom Office however the moment I link a Sales Order to it the ShipDate changes to whatever the ShipExpireDate is for that Sales Order. How can I prevent that and keep the default of…
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 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…
Hi Experts,
I wrote a script that will allow a user to enter a secondary ID number (not the Sage InvoiceNumber) in the InvoiceNo field in CashReceipts Entry detail. The user enters the secondary ID, my script grabs the number, looks up the correct Sage…
I am trying to use BOI tp print PO to paperless office and I am having hard time finding any good examples of printing to paperless.
Does anyone have code for printing of any forms or reports to paperless?
My goal is to email PDF copy of purchase…