Browse By Tags

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…

Regarding our customer sales orders, we have multiple items that ship from different vendors. Is there a way to enter the estimated ship dates for each line item and then create a report to email to our customer? Currently we create an excel spreadsheet…

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

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…

We are wanting to run the 1099 report to see if anyone is missing their TIN. When we attempt to run it, we are not given 2023 an an option on the drop down menu. Our fiscal year runs from Oct 1 - Sept 30, so I am not sure if this is part of the issue…

Hi - With the disappearance of Intelligence Reporting, I have run into a brick wall on accurately accounting for and calculating the commissions that my sales reps get. I have tried to do it through the Invoice Register, but the report that it spits…

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?

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…

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?

Does a profit and loss report exist in Sage 50? Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage? I would like the report to include income, cost…

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…

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…

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

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…

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