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.
Hello everyone,
I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions:
Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
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…
In general is there a maximum number of UDF's per table.
And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium…
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…
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…
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'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…