Sage 100

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…

Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…

I'm trying to find out how many invoices are being entered by month/period. The generic report JAccounts Payable Analysis Report shows this information, but it is showing me data from year 2022, May through October. How do I change the date range? Or…

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?

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…

Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…

Does anyone that knows how to control and allow salesperson to be able user lock the by the salesperson to be able to see only see their only their customer statement and sales order invoice but no other sales representative. Currently, the lookup is…

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…

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…

Hello, We are looking to automate statement printing for our customers. I looked through the "Task Scheduler" provided by MAS and noticed that this was not an option. I have no experience with this sort of thing, but it seems that this should be possible…

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…

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 am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…