Sage 100

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…

Hi, I am new to Sage 100 Advanced (2021) as of Oct. 2023. I'm beginning to grasp the structure of Sage and how to customize it for business needs as they arise. However, one need I haven't been able to figure out is if the "Packing List" and "Picking…

I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…

How would I go about adding a description field that displays the corresponding description record for a UDF? Does this require scripting or can these be linked in Custom office? I dont want someone to be able to select available descriptions from the…

I would like to add the Company name on all employees pay stubs. Is there an easy way to do this?

I've added a UDF to display the customers shipping acct number in Sales Order Entry. But I've run into an issue where the field can't be edited in SO Invoice Data Entry or Purchase order entry. I can however edit in Shipping Data Entry, but the changes…

I created a UDF Table with 3 UDF fields in the Inventory Module (see photo). Is it possible to add this UDF table to the Inventory Maint./Inquiry ALE look up on Available Fields section see photo..

I have created numerous custom SQL views in sage company databases and used them in custom reports, added to custom reports, and module forms. I just did the same for a customer and cannot print/preview the report from the custom report's menu. The error…

Have an install of Sage 100 v2022.2 Advanced and trying to link a UDF to a UDT for a lookup. When click on the magnifying glass it errors out with error 20 program SWQUERY Line 0504. It doesn't matter what module I add a UDT or the size that error appears…

I have a VI job that imports in to a UDF associated with the IM_ProductLine table. One of the UDF's; "UDF_LIC_ROY_DUE" is a number masked to two (2) digits. It is intended to hold a number between 1 and 31, representing the day of the month payment…

I was unable to find anything online, how can I print item's extended descriptions so they will show up on printed Sales Orders? Or alternatively how can I increase the 30 character maximum that the SOs will currently print? Thank you for the help.

I made a custom report with Business Insights. Pretty simple report, shouldn't be a big deal. But every time I try to make a custom report, it will run very fast on the server. As soon as I try to run it on a workstation, it takes forever and ends up…

Hi, I built a report in Crystal that they can input several item codes and it returns who has bought those items. It was added to the MAS menu AR custom reports. I had to build Access databases and custom ODBC to run the report. Its worked for a long…

I am working on an issue after a new a install of Sage 100. The font on the Sales Order Entry Module is tiny. ( See attached Pic ) . I have adjusted the resolution and scaling in Windows. But this has not made any difference. All other Sage modules and…

When use client side script, MAS_SCR_USR is the current user log on, what is the current user password constant, in my client script, it will also run an external BOI app, needs current username and password to pass to it. Thank you

SAGE 100 - Can I create a pop up alert in "Invoice Payment Selection" Process? I need to set a particular reminder about a vendor every time I do a check run.

Is it possible to add a different drop down under Order Type in Sales Order Entry? We are wanting to add a drop down for Retainage and invoice those separately and under a different A/R G/L number. Thank you!

Hello, In our current table " AR_AgedInvoiceReportWrk" has a field called balance however, it is not calculating the customer balance properly. If I create a formula the properly calculate the balance would it be: if {AR_AgedInvoiceReportWrk.Balance…

Hi, I have a script for the "UnitPrice" field in Sales Order Detail that triggers an alert if the price seems incorrect. I also have another script for "QTYOrdered" that occasionally modifies the "UnitPrice" field. The issue is that this second script…

Hello, I am hoping someone could assist me with a formula I'm trying to create. The UDF field I created for our users displays in numbers but I want to create a form that if the number displayed is x then it should display y. For example, "If {SO_OpenOrdersWrk…

Probably not, but just asking. I have a script attached to the SO_SalesOrderDetail object. I'd like to reference a UDF attached to the Product Line of the line's item code - Ideally I would use child handles to avoid the need to give all users view writes…