Sage 100

Hi everyone, I'm wondering if anyone knows how to generate a list of all customers that have special pricing methods set, including: Cost Markup Amount, Cost Markup %, Price Discount Amount, Price Discount % and Price Override. The one that's chiefly…

I am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…

v2019 Adv. Customer would like a Crystal report showing what email address is set up in Employee Maintenance/Paperless for Electronic Delivery. It may/may not be the same as the Email that is on the Employee Header. The PR_EmployeeDocuments.m4t is an…

Error when printing various reports. Sometimes a second attempt works. Sometimes I Preview the report then print it.

We recently upgrade Sage fixed Assets from 2016.1 to 2019.1, today a users reported issues generating reports from Sage 100 2016, that's all the relevant changes that we have made recently. May Sage could be affected because of this?

Hi! We upgraded our client to Sage 100 2019 so that we can take advantage of the new feature that allows for additional attachments when emailing invoices with Paperless Office. However, we are receiving a Chilkat error where everything seems fine until…

After a major Windows 10 upgrade our paperless office stopped working. We received the following error message: “Printer not activated, error code -30”. I made sure the paths was correct but we still get this message. Sage 100c Standard 2018 (Version…

Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …

Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

Just wondering what financial report alternatives are available for Sage 100. I have seen Sage Intelligence years ago, but was not impressed, it was clunky, difficult to use and not flexible. I have worked with F9 which is user friendly and is super flexible…

Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…

Hello, We are having an issue with the AR trial balance report. If we run this report without specifying a customer, and leave the Customer Number field set to All, the report runs fine. However, we have a specific customer we want to run this report…

Hello, Our accounting department brought to my attention that for certain lines on the AR aged invoice report, the "Balance" field is showing exactly double what the "Current" field is. I went and looked in the database thinking there have been double…

Can anyone help me figure out how to set the default printing (within Sage) to landscape for financial statements? The default keeps coming up as portrait. Then, I need to change the orientation every time a print a financial statement. Thanks!

We have a client who has just implemented Tableau as their reporting tool company wide. They are running Sage 100 Advanced. They connected Tableau via SOTAMAS90 ODBC driver and it does connect and list the Sage data file names. If they try to open/query…

Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…

Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…

This problem has been driving me crazy for the past 2 days. Have a client who PDF's & electronically delivers AR & SO Invoices. They are on 2014 PU 4 Premium version of Sage. They have been using the same customized form codes in both AR & SO for years…

It is possible to export a report from Sage 100 to google sheets?

Hi, new to group and Sage. Have a Windows 2016 Server, everytime there is a windows update available, it stops check printing. Anyone ever see that before? Thanks

I need to link these 2 tables in order to see a report of user roles and related tasks. But there doesn't seem to be a clear link. The SY_RoleSecurity table has key field called TaskKey which ha values of 9 characters, whereas the SY_Tasks table has a…

Sage 100 ver 2015 The items within the kit are included in the inventory sales history, but not included in the Inventory Reorder Report as either qty sold or qty issued. How do we get these sales to be included on the reorder report?

I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…

I have a client experiencing some errors I have never seen... They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like... Here is…

We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…