Browse By Tags

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…

Can anyone advise on what the "*" means next to the date on the Check Register Report 2-6-0-21 ? Thanks for your help in advance!

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…

Hello, I am trying to produce a reliable and accurate cashflow statement in Sage 50 Quantum Accounting Canada. To me, a cashflow statement should start with net income, then take into account cashflow adjustments from operating activities, investing…

We are having issues with getting subcontractors who have billed retainage to show up on a report since Sage 300 refuses to create a "bill retainage" button in AP. When I submit reports to management they have no idea a retainage bill from a subcontractor…

Is there a report I can pull in sage that will show me what we have paid out to our subs on a job so far vs what we have received so far from our client on this job? The client is making payments, and we want to make sure that we haven't paid our subs…

Hi, I am new to Sage, How do I run a report that will give all the open invoices for a specific project ?

I just voided several checks for a vendor. How do I run a voided check report?

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…

We have changed the AP invoice aging w/cut off to show the job number. It worked great except that it has a huge number of lines that have no dollar amount. These lines just show the vendor number and name as well as the job number and name. Can someone…

When we setup Invoice Approval in AP, one of the things we did was setup Approval IDs, so we could tell who approved an invoice. However, now that we've used this for a while, I can't find a report which displays this data. Is there a way to create a…

I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…

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

Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda

Hi, In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…

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…