Sage 50 US

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

Does anyone know how (or if it's possible) to generate a Customer Event Log report. I would like to generate this report on a weekly basis.

Moved sage 50 to a new Windows 10 computer. Now I cannot print Action Items Events report. Just prints heading and random symbols. Is my Windows 10 missing a font I need?

On the AR is it showing a payment of 935.28 and an outstanding invoice of 467.64 but shows a credit on their account of 467.64 ONLY on the AR not on their customer account view - it shows zero. A prepayment was done in the amount of $467.64 and it was…

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…

When I print out a Cash Account Register report, only those vendors who are stored in the vendor list show up under the Payee/Paid By column. However, I have written several checks to vendors that I don't want to store in the vendor list (using the "Pay…

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've been using the Purchase Analysis intelligence report, however I want to add the "Purchase Order No." (not JobID) in the report. Sage has to be storing it somewhere, because we fill it out on every PO we input, same with "Unit Price". It is not…

For a manufacturing company Customer PO must be in Back Order Reports. I do not see that selection in Column selections. Also Vendor related info is totally useless in this report. Can you add Customer PO in Back Order reports?

Hello, I was recently hired to handle IT for a small company that uses Crystal reports 2008 in conjunction with sage 50. The Crystal Reports application was packaged with an older version of Sage and they have continued using it for some time. The problem…

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 already i have sage 50 2018, when i try to generate a report (inventory stock) the sage 50 stay freeze. I try the follow solutions: uninstall sage 50 uninstall updates of win 10 rename the folder Reports and copy another folder with the same…

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…

In a number of reports that include GL Acct ID, only the first line of a record will include the GL Acct. Below is an example from the Job Ledger Report. All four lines are in GL Acct 4000, but the report only lists the acct ID for the first. This creates…

I ran my Tax Liability Report on 2/1/2017. I paid my 941 taxes for January based off this report. I just ran my 941 quarterly Tax Return and discovered January's report was incorrect causing me to over pay my 941's. Why would this happen?

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

Good Afternoon, Looking for some help on the aging reports. I have a customer set up Net 30 days and after reviewing their aging report example Inv. Date 4/7/2015 is still in my 0-30 days and I have others, after I check the invoice itself the due date…

Our segments are NNN-DD-PPP-CC where N are the natural accounts, D are the departments, P are the Products Categories, and C are the Product sub classes. Our chart of accounts for revenue looks something like this: 400 400-D1 400-D1-PCat1 400-D1-PCat1…