Sage 100

Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…

When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order? Thanks

I'm using Sage 100 version 2020. I wanted to use Aatrix this year to submit my 1099's. I went through all of the steps in Sage, logged in to Aatrix, paid for e-filing. Between closing the Aatrix finish pop-up, and it going back to Sage, my internet cut…

Hi, I have the code below for automatic registration/update of the inventory register transactions. In the nProcessReport part, my return is always Nothing. I'm encountering same issue on Sage 100 2018 and 2020 oSSRegister.nSetProgram(oSSRegister…

We're running the A/P month end process for the first time. However, there are no period end reports listed in the Period End Report Selection. These are the reports I expect to see listed How do I get the A/P period end reports to list in the…

Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…

Is it possible to get a Active Vendor List? Lets say vendors that have been paid in the last 3 years?

I've looked through the payroll module overview and other sources and cannot determine whether employees' federal and state withholding elections (filing status, including exempt) from the W-4s are reportable fields. If some report, somewhere, captures…

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

For the new 941 recent Payroll update 2.20.2, there does not appear to be a place for the employer to record they received a PPP loan and therefore are not eligible for the employee retention credit. Without having this functionality, the form is populating…

We continue to get "error code 30 printer not activated" on a terminal server 2018, WIN 10. We have manually installed the PDF converter with all boxes checked, and ran Regedit on HKEY_CURRENT_CONFIG\Software. We've turned off UAC and all users have read…

Where does the QuantityOnHand value come from in the SO_OpenOrderWrk file? The field value is always zero when I try to use it in an Open Order Report. I would like to pull the QuantityOnHand from the IM_ItemWarehouse file based upon the WarehouseCode…

As the title says, we'd like to separate our year end aje's. We'd like to have an unadjusted trial balance, aje's, then the final trial balance. Sage was not setup with a period 13, and I'm not sure if that can be added at this point. Our Sage guru…

Has anyone had success getting secure digital signatures to print on checks in Crystal? Our client has purchased secure digital signature solution from Source Technologies, and while we can get the signature to print from a text document, or even from…

Anyone know why (General Ledger ) Explore view will work with classic desktop and not in standard desktop? We are running Sage 100 2017.

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

"Invoice History Printing" let's you reprint invoices. Is there an equivalent tool for Purchase Orders? We are an importer. We send the original purchase order to our vendor overseas. Once the goods ship, we add the container number as a comment on…

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

Is it possible to automatically email our customers when their invoices become past-due? We are trying reign in our A/R and at 45 days after the invoice is issued, it would be awesome to have our system auto-send a notification/reminder to the debtor…

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…

** Support advised that we should post here too We have about 30 machines (only 5-10 use Sage 2019 concurrently) on our network and upgraded from MAS 200 v4.3 >> Sage 2017 >> Sage 2019. Select users are having an issue where launching PREVIEW of reports…

I keep getting the above error report on Sage 100, and I have gone through the trouble shooting stages of uninstalling the program to no avail. We have also contacted sage and they told us to do the same thing even though it did not work. What are the…