Sage 50 US

I need a way to create report from scratch in Sage. I don't want to customize an existing report because I haven't found one that matches what I need (money received sorted by job). I can find invoices by job & money received by invoices and I am having…

My school buy the software and installation service from a company, after installed the Sage 50 2023, the company said that Sage does not buy the license of Crystal Reports therefor cannot use the report function of Crystal Reports, is that true? Or any…

Labor Hours on Job cost report

Recently, the default Aged Payables report does not populate. My dashboard is correct and shows the total amounts at 0-30, 31-45, 46-60, and over 60, but when I select one of these to get a listing, the report is empty. At the bottom of the Aged Payables…

I'm new to accounts payable and Sage 50, so forgive me if this is a silly question. I have certain payments set up as recurring entries. On the aged payables report, it show the balance as negative. What causes this? Am I setting up the recurring entries…

I need a report that will run at the end of every day with any inventory price & cost changes +/- so we can be up to date on our pricing. Is there a way to do this automatically and possibly have it write over the report run a day prior? Thanks!

The Tax Liability Report and Payroll Tax Report's State (GASUI) does not calculate correctly. The line item Liability Calculated on GASUI has the Tax Liability calculating correctly.

Is there an easy way for a novice to produce both an Income Statement and Balance Sheet broken down by Quarter? I've tried to use the Design Feature and I just don't understand it!

I am looking for an inventory receiving report that will show which customers to commit the items to. I haven't found anything remotely similar using the standard reports. How can I get something like this created? Currently I only have access to standard…

Is anyone using Sage for Multi Company consolidations? Are there any best practice tips?

I was trying to reconcile the Aged Payables to our General Ledger account and I noticed we were off by quite a bit. Then I noticed that there were transactions that didn't show up in the aged payables indicating that they had been paid but they only showed…

How can I get account reconciliation reports for years that are not in the active periods? Using Sage 50 Quantum Accounting US 2024 that has 2023-2024 periods and need account reconciliation reports for 2022.

When I print the standard P&L the Month-to-Date and Year-to-Date is exactly the same. It's only reporting the annual totals correct, not the monthly totals. (I imported all transactions if that makes a difference.) TY!

I'm attempting to connect crystal reports to Sage 50 (2023) so that we can perform an export of all customer ship to addresses in the company (not sure if this is possible from within Sage 50?). I followed the instructions in KB article 223924350032954…

Hello, We've implemented a new City tax (on top of county), is there a way to run a GL report that would only includes invoices that include tax from a specific Sales Tax Agency Name. I was hoping I could double click on the agency name on the Taxable…

Why does the summary report not include the employers FICA but is does include the employers Medicare amount in the total?

Monthly and YTD Amount showing as the same amount on the Income Statement. How can I fix this?

It appears a change was made to an employee's withholding. Is there a way to see when the change was made and even possibly by whom?

All of a sudden I can't access the General Ledger, AR or AP reports. The other financial statements are there. Any ideas?

I am adding the function GetPeachQtyOnHand ({Company.CompanySpecial1a}, {Company.CompanySpecial1b}, {Company.CompanySpecial1c}, {Company.CompanySpecial1d}, {LineItem.ItemRecordNumber} ) to a Crystal Reports, but the field CompanySpecial1a is not found…

I have been tasked to create an Inventory Turns Calculation in Crystal, I have a report with all the items, a date range parameter and COGS calculation, Piece of cake. How would get average inventory? Is there a table that gives you historical inventory…

Sage 50 Quantum. Despite going through the normal installation step to make these functions available, they aren't. The u2lpeach.dll is in C:\windows. I even tried to manually register it with regsvr32 to no avail. Where should this .dll be? What…

Our company's projects consist of inventory items and non-inventory items purchased specifically for a specialized job. Is there a report that can be pulled by job# that shows the inventory ID of the parts issued to job with quantity? I can drill down…

Hello, Im extremely new to Sage but recently started working as a purchaser at a Plastic Injection facility. We use Sage 50 and I hear different things from different employees on what sage50 is capable of. im wanting to be able to have a way to…

I need to provide a Year to Date Profit & Loss Report to my bank. I use Sage 50 software. Which report would that be?