Sage 100

Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?

When I uncheck "Age Credit Memos" on the AR Aged Invoice Report, credit memos are still showing up on the aging report. Any help is appreciated.

What is the sql statement needed to get the last full month for a pass-through variable. Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month. As always thanks in advance for your assistance…

I am attempting to modify an existing report in Sage 100 to show employees' next anniversary date and birthday starting with the hire date and birth date fields entered on the employee set-up screen. I can't seem to get the addint function to work if…

Hi there, I searched and couldn't quite find what I was looking for. I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue…

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…

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 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…

When you use the Auto Generate Purchase Orders from Sales Orders you select the criteria you want to generate PO's for, then once you click proceed you can view a report before actually generating PO's. Not sure what that report would be called but, is…

I've been working on some changes to our Open Orders by Item report in Sage 100. I would like to print this report, and have it indicate the quantity on hand in addition to the items on open orders to better help show when product is available to fill…

Is there a way to add a UDF in Item Maintenance so we can keep track of the brands of our items? I saw in another link that it should be done through CI Item Master, but there's no specifics after that. Thanks!

Hello, I'm trying to export the history tab of Item Inquiry window (see above) to excel sheet for reporting purpose. I created query which pulls data from the table of IM_PeriodPostingHistory. However, the beginning quantity of each month shows 0…

I'd like to include an active hyperlink in a custom report form using Sage report writer. Is there any way that the report writer can recognize a hyperlink or HTML?

PFC, The Plastic Forming Company is a manufacturer of blow molded plastic cases. We use Sage 100c version 2022 supported by a 2017 SQL server. Back story We have an existing custom Crystal report which tracks from the Sales Order module new and existing…

We have a client that has several hundred companies in Sage 100. They have a report template that they would like to run individually on each of these companies. The customer owns the Connector module. Using the standard Autoconnect connection in…

I'm hitting a wall. My client wants a column in Sage Intelligence to pull only total of net activity for a specific day instead of a period. It has to do with accruals. They don't want to enter accrual journal entries. They want to keep the expenses dated…

We have a lot of sales restrictions here from UDF Brands, Bill to Country Codes, UDF lithium, UDF MAP, certain UDF Brands in certain Countries and so on. I have most of them caught in a Crystral report but I'm not sure how to catch these. I have a lady…

I'm trying to use multiple instr with else if but I think its only working on the first one. I have a customer memo code with some sales Brand restrictions and this one that catches third party restrictions. It also catches other stuff like no export…

Hello, I'm new to this community and was hoping to find somebody that can answer a quick question. I have written a couple of Sage Intelligence trend reports using Sage 100 database and I can't seem to be able to figure out how to not print months that…

Hello, First day to Sage 100/Crystal Reporting and have been tasked to find out if there is a way to add a column onto one existing report and that column of information is from a different report. They are in separate modules. Seems it should be an…

I'm suddenly getting this error and the only thing that stops it is a reboot. Microsoft Excel is waiting for another application to complete an OLE action Running Sage 100 Advanced on Windows 2019 Server & Excel Standard 2016

Sage 100 2019 Sage Intelligence. How do I add company code from the SYO_Company table to my joins? In Crystal we would use "Not Equal" as a join for company name. In SI, Connector, there is only Right Join, Inner, and Outer. How do I get the company name…

Hello, I'm trying to create a crystal report so we can generate CA sales and taxes charged. After selecting the data I want populated from the module I'm able to run the report but I only get like 5-6 results. Does anyone know why or how I can have the…

I don't want the users to have access to the actual data tab. any way to lock it?