Sage 50 US

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…

Recently my check register report does not show the correct name that was printed on the check. How do I fix this? I need it to show the Remit 1(2,3,) name not the Vendor Name so it matches the actual check. We have lots of Vendors that require us to…

I'm using Sage 50 US. I'm looking for a way to add a comment about an invoice that would show up when I run the aging report. For instance, when a customer communicates to me that the invoice will be paid on a certain date, or if there is an issue with…

How can I get a report on an employee earnings not including bonus and overtime?

I’m using Sage 50 US. When I pay a supplier’s invoice before the due date, the invoice still shows up on the Aging report, but now as a negative dollar amount. The report subtracts that from the total amount due for that column, which makes the total…

My AP on the Balance sheet is 5 times the Aged AP report. Both tech support and my account rep say this is correct. Tech sent me an email saying:: " The balance sheet shows a running total of all debits and credits for an account. Both paid and unpaid…

Hello everyone, I have a problem, we are currently using Sage 50 accounting US 2018 version. And it does not show me the reports that Sage brings, except for the ones I previously customized. I am on ek release 2018.2, will there be any newer one…

Form and Report Designer are still stuck in the1980's as text based editors. Isn't it time to upgrade them to a graphical UI? I'd like to be able to import an image of a preprinted form on a non-printing layer. This would make text and field alignment…

Is it possible to setup a A/R & A/P clerk position to have access to Job Profitability Reports WITHOUT having access to payroll fields/access?

Is it possible to create a Report sorting the Customer by Region/Country AND by Gross Sales?

We use Sage 50 Quantum. I ran a balance sheet for period ending 12/31/20 back on February 24th 2021. Today I ran the balance sheet for the same period 12/31/20 and the retained earnings GL is different from the report I ran in February. I am wondering…

I need to approve payments for the AP check run. My accountant gives me a report of vendor, invoice, amount, and GL account. However, the GL account is Accounts Payable account. I need a report that shows what Expense or Inventory account the invoice…

Hi all, I'm facing an issue on the number of decimal places in the sales order total and tax amounts simply price related amounts even if I set it to four decimal places the value displayed in the print preview rounds off the actual value to two decimal…

Hello All, Does anyone know how to run a report that will show items sold in March 2020 vs items sold in April 2020. Basically a comparison report in one report

Hello, I have a warehouse of items that are are sold by sales reps. I need to compute commission earnings by sales rep; linking customer invoice detail to vendor costs. How can this be done for warehouse items? Thank you in advance. Ellen

the Peach Tree software we are using is pretty dated I believe 2011. We receive statements monthly from the bank for a large equipment financed loan. The accounts used in setting up the loan were Note payable to the bank; Interest Expense, and the other…

I have ran the inventory report multiple times for multiple reasons and have the same issue. When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items. I am updating list pricing and am checking for…

Since upgrading to Sage 50 2020, some of the words in my column titles are not printing on my financial statements. When I open Designer, I can see the words there, they are just not printing or showing onscreen. Sage support told me they can't help…

I have a client that data entered several transactions to their bank account register and incorrectly coded multiple transactions to an incorrect Vendor ID. I instructed the client to go back and create a separate vendor ID for these separate transactions…

I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…

Hi. I am running the job profitability report.... I have added the column "PO Number" to the report but no data is being generated in that column (and there should be). Can someone please tell me what table that column (PO Number) is being pulled…

Hi all, I am trying to create a report for our shipping department. They need to see the sales order number, the items ordered and quantity, and the address and the ship via. I can summarize everthing but the ship via on a custom Sales Order Report…

I have tried searching within the inventory item list, but I am not getting the results I am looking for. Is there something I am missing? All the answers to this question previously seem to be out of date for my version and I am pretty new to sage.

When I run a General Ledger Report, the Job ID does not display for all the transactions even though there is a Job ID on the transaction.

I want to be able to view my daily income and expenses after the day's sales.