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,
I am hoping to find a way to add a tab (or a few) to the "Employee Maintenance" screen in Sage to allow for more fields to be added under different department specific details.
Running Sage 100 Premium 2021 (Sage Version 7.00.2.0) (Payroll…
I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
We use Sage 100 Advanced 2023. We have an item, Honey Straws that we make up into 50 packs to sell. We buy these in boxes of 2000. There are about 2 dozen flavors we offer, but for the examples, I will use Apple as the flavor. All items have similar setup…
Hello folks,
We are starting the process of upgrading from an older version of MAS 90 which ran on Providex to 2023 Premium.
There are a number of custom apps that we've developed over the years to run with our MAS data and they all used the MAS ODBC…
I am new to designing reports in Sage 100. Is there a good YouTube video or documents on this? I just need something simple for an audit (employee name, job title, gross wages, and overtime wages).
The Sage 100 Open Sales Order Report has a list of stock criteria fields, and some fields we added using custom office..see attached.
Are we able to add additional standard Sage fields to this list eg; CustomerPO?
Hi...
I'm trying to find a way to add a value from the bill of materials bill number field in bill of materials maintenance to autopopulate the bill number when you run the Single Level Report from the screen. As it works now, the report will appear…
We have a UDF "Total Quantities" that we use for Kit items to show the total quantities of all the components. Currently, we manually sum the quantities of the component lines and enter this into the UDF "Total Quantity" on the Kit line.
I need help…
We are having an issue where control labels are missing after panels have been modified. This is occurring for labels/controls that were not part of the modification. As a result, we have to keep continuous backups of our panels and roll these back in…
I added a new script for all new orders on the sales order detail to fire on the column post validate of "Item Code"
My concern is for any old quote that will be changed to an order and will not have the script run, how can i add a script on the Header…
Hi,
I have a request from a client to sort the Sales Order Lines detail section by Item Code.
I feel like I should be able to do this with a script, but not clear on what Object to reference. Can someone give me a hand, perhaps point me in the right…
is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…
Hi,
I am trying to export transactions out of sage 100 through a VI with a filter on date updated set it to today. I used different functions such as {DAY}, {DATE}, {TODAY} and DATE$. Unfortunately all my methods failed in using the system date as the…
I am looking to print the customer type on the picking sheet. I added the AR_Customer table to the database, used a left outer join. Added the Customer Type to the crystal form (browsed the data-I could see the customer types) BUT when printing it does…
I am using SOTAMAS90 as my source in an import and I need to sort the records before importing (AR_InvoiceHistoryHeader and I want to sort in InvoiceDate order, ascending). How can I add that to the SQL statement?
Thanks!
We print large batches of picking sheets a couple times a day, when this process is run the printing prints all of the picking sheets form 1 first, then goes back and prints the second form for the picking sheet. The process is run on 20-100 sales orders…
Is there a way to setup a UDF so that when the Copy From button is used on a record to copy values from an existing record to a new record that the UDF field value is not copied?
For example, in Inventory Management, if we have a UDF field to store…
MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…
We have 170+ rows and they are separated into 4 different groups of rows. First group of rows is 1-54 and behind that one is 108-55 and then 109-138 & 162-139. We could have a order that has an item that's on row 1, row 54 & 108 for example. If they pull…
I need my team to be able to see certain information on Sales Orders for a few product lines - is there a way to auto-generate comments on those products? Or would it be easier to implement extended descriptions to SOs instead?
Create a numeric UDF, and edit the mask to include a trailing "-" (so negative values are accepted and displayed properly).
#,###,###.000-
This presents a warning about too many decimals / rounding, when I am clearly not exceeding three digit decimal…
Hi there! I hope you're all doing well.
I'm attempting to modify the SQL query of an ODBC Import Job, but it crashes when I press the Test button.
I'd like to know if there's a resource where I can find the exact syntax of SQL required for VI Jobs…
There are additional efforts to use Crystal Reports 2020 (@Sage 100 2023) with MS Office or text files. I have Custom Reports that include links to Excel and MS access. Without the native connectors we will have to use downloaded add-ins. Does anyone…
I am trying to import multiple POs into the same Receipt of Goods. I chose Next for the Receipt Number and pointed it to the field I want to use to determine the change, but apparently it ignores that and changes whenever any header field changes, i.e…
I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…