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?

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

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…

Sage 2019 I created a Data Container. I added a table and would like to add an alias of the same table with a left join. When I attempt to add the table, a message informs me the table has already been added. In Crystal or Access, I am allowed…

We are looking for a way to separate our YE AJE's. It was suggested to us to use a source code named AJ. We'd like to create a set of financials that shows the unadjusted trial balance, then the AJE's, and then the final balances. So, my question is…

Hi All, Our company has Sage 100 2015 and we are just now starting to use Sage Intelligence. I am pretty used to report writers so learning to write reports in SI is fairly easy. However, my difficulties have to do with the set up of Power BI…

Hello, I am trying to create a custom report that would show customer details relating to items sold. I am looking to include: Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…

Does any know if we can link (or reference) GL accounts from one worksheet to another in SMI report? The purpose is to is to simplify update of accounts Say sheet1 we have a good report. In sheet2 column A, we want to link to accounts in sheet1. If…