Sage 50 US

Why is it when I've sorted the customers names in alphabetical order and then print the invoices the customers do not remain in alphabetical order. Therefore, the invoice number that is assigned to the invoice is not in order. This makes it very difficult…

Why is it when I've sorted the customers names in alphabetical order and then print the invoices the customers do not remain in alphabetical order. Therefore, the invoice number that is assigned to the invoice is not in order. This makes it very difficult…

Does anyone know if you can search for specific information listed on a vendors invoices not just a specific vendor but any vendor that may list "Night Stands" that have been purchased over the course of a specific period. Such as: Vendor: ABC Invoice…

We have a corporate credit card with approx 15 staff who have a card. We enter the vendor name such as "American Express" and use the last 4 digits of the card and the staff initials and month the transactions correspond to. See below - does anyone know…

Is there a way if we updated and Inventory Item for a different price that it would be retroactive, or do I need to change the price manually on every item that we used that inventory item on.

Can get information how to make visible payment details in the bank activity record instead of 'Purchase Payment' in the details field. If the details have already been uploaded when entering the individual invoice details then this data should automatically…

Searching for an inventory item in inventory or when entering an Invoices, It is my understanding the search looks in the item ID field and the short description. Is there a way to also search in the Part Number field? Is there a 3rd party that does this…

I have my banking dashboard as the main display. However, when customizing the "Account Display Settings" when clicking on the "Customize" hyperlink, the accounts I selected only show prior month's balances. This occurs even if the "Display Year to Date…

It is frustrating that we can't set the default to sort by customer name instead of ID number. I can't remember hundreds of numbers (which is the better identifier) and going to the bottom of the screen and changing how it's sorted for every transaction…

Hi all, I need to write a query to pull all AP invoices that are currently open. Writing the SQL is no problem, but I don't really know which tables I should be looking in or what criteria I should be using for my WHERE clause. Can anyone get…

Ok, I have read a bunch of websites, blogs, etc. and I cant find the answer to a simple question. I have sage 50 us 2018. I have dumped all the table data into a sql database. I have an GL account for cash. I want to create a query to get the GL balance…

Need assistance in extracting data from Sage 50 for a Tax Audit. Currently pulled the Invoice Registry, but it does not show early pay discounts that have been applied. Is there a group of reports required to be pulled or is this something that needs…

How can I delete FUTA and SUTA from my non-profit payroll since neither are required of non-profits?

I know there's a way to do this, but nothing I've tried is working. Trying to make a formula to calculate/post work comp expense/liability with payroll that is run each week. In TN, 1/3 of overtime is exempt; and consider in this example that the…

HOW DO YOU CREATE A WORK SCHEDULE WITH SAGE TO PRODUCE ALL PRODUCT DUE AND NOT DUPLICATE ORDERS? ALSO IS THERE A PATCH FOR SAGE THAT WILL AUTOMATICALLY TAKE OUT INVENTORY ONCE IT IS INVOICED.

Sage-50 Quantum 2015 We use a PEO – Payroll leasing service for all employees – owners, office, production. The PEO process payroll , manage benefits, pay taxes, DD, workers comp, etc. In the past we have just made one write check payment entry to match…

When entering Purchase Orders to a Vendor or an Invoice from a Vendor, I try to post to a specific job for costing purposes. However, I get a message saying that I can't post to a job when purchasing. How do I fix this so I am able to always post to a…

I currently use SAGE 2010 Accounting and my system has 5 departments with 1 checking account. One of my department is going through an Audit and the Auditors need check register and cash disbursement journal for the department. Question: How can…