Sage 100

I am looking to customize our AR Aged Invoice Report to replace a manually done Past Due Report. The report is fine how it is for the most part, but I am wanting to filter the 30, 60, 90, 120 Days columns to exclude all zero's. The report is way longer…

Have a client who needs to do some reporting for the state and the Check History Report seemed like a good place to start. HOWEVER, I have been unable to add UDFs from the Employee file at all (even non-encrypted fields) (they all show as blank), and…

In SAGE 2020 is there anyway to format the top and bottom stub differently in Stub, check, stub format in SAGE 100 2020?

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

Hello, using PO Receipt labels and have a need to set the number of labels needed per line on the PO. For one PO with 5 line items, one line may need 5 label and the other may need 1, etc. This is independent of qty rec'd and t he setting in Inv Maint…

Does anyone use Data Link for certified payrolls? Looking to see if someone has a custom report they can send me as a template, as the custom report I had is now gone because we updated servers and our IT guy didn't save my custom report.

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…

As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…

Does anyone have any tips or tricks to implementing a departmentalized chart of accounts in Sage 100? We are looking to break out accounts into 3 different department, but also have the capability of running a summary chart of accounts as well.

What version of Sage 100 will interface with LCP Tracker for certified payroll reporting?

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 have a crystal report I wrote that pulls field 33 ShipWeight from AR_InvoiceHistoryHeader. On 9/5/23, my business partner went in and added UPS as a shipping method. He claims he did not touch anything that would affect this field but cannot remember…

When a vendor's W-9 lists company and/or personal names in both boxes one and two, what is the correct way to record this information in vendor maintenance? In other words, what name should go into the Name slot in VM? Or, should the two names be split…

Is there a way to hard code a value in this filter grid? We are having issues when running this job, getting errors and running the risk of never printing pick sheets. We changed to print to pdf and today we added a filter, same as the last 6 months,…

Can any of the Financial reports be edited in Crystal.. I had a request to add the G/L account to the Income Trend report, is this possible.

I am wondering if has made any IRP custom reporting for the Sage 100cloud Premium 2023 PU 1 that can address my customer need. Here is the detail request from my client; They want to be able to run a report that looks like the legacy MRP action by vendor…

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…

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…

I'm trying to use if instr({Sheet1_.Restrict},{CI_Item.UDF_BRAND}) > 0 then "Alert" Sheet1_.Restrict is excel cell with this exactly [" Smith's Sharpeners "," Arkansas Sharpeners "] {CI_Item.UDF_BRAND} is over 850 brands The problem is its returning…

we have a memo line at the bottom of our invoices indication late fees and credit card fees I need to change from 2.5% to 3.5 how can I do this it was easy in the statement module

Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…

We have set reorder points on all our products we inventory, these items are flagged by a udf in CI_Item. The reorder point report in Sage looks kind of clunky to me and I was trying to get a notification to order items below the reorder point. I've read…

I have a client using Sage 100 in a cloud platform (SWK). When I login under the client's name into SAGE (but my name on the network), I can see a report in Report Viewer. When the client logs in under their name in the network and into Sage, they do…

Hi Folks, I am trying to add payment information to my A/R invoices. My test company has a formula field called "Payment" with the following formula "formula = {@NetInvoice} + {AR_InvoiceWrk.FreightAmt} + {AR_InvoiceWrk.SalesTaxAmt}" that does not seem…