Sage 100

We would like to have reporting on customer's sales, that excludes Tax & Freight paid. I read this was done by going into AR - Setup - Accounts Receivable Options, 6-History - uncheck "Include Sales Tax and Freight". But how do we go about recalculating…

In SO Entry on the lines tab we have "total amount" then on the totals tab we have "taxable amount". These two fields are off and I can't figure out why, says order is out of balance. It is a price quote right now.

We are producing a custom item for a customer. They will be charged $20,000 for their first order on Net 30 terms...which covers the full run. They will only be taking a portion. The remainder will be on our property and when we ship out any of the balance…

We are continuously having issues with our users not noticing that the vendor discount amount on the receipt of invoice entry does not match what the vendor actually allows. When miscellaneous non inventory items are included in the lines of the receipt…

We created a Sales Order with a large number of line items. The Total Amount shown on the bottom of the window is correct. When we then navigate to the Totals tab, the Taxable Amount is a completely different number - inflated by almost $30k. We sent…

We have a client whose internet is down due to construction being performed in their area. Unfortunately, today is payroll day. Has anyone had experience using a hotspot to run the payroll tax calculation? They are advanced and the service in onsite.…

How do I get this set up to pay and cost to a job without it adding burden rate to it?

Michigan has rolled-back withholding tax from 4.25% to 4.05% for 2023 yet they refuse to change the tax tables for the year. See the references below..." Treasury takes a neutral position on adjusting withholding amounts. If 2023 withholding amounts are…

I have a client whose finished good items are made up of several manufactured components, as well as purchased items. They had been creating WT for all of the mfd components, but in reality, they VERY RARELY stock these items, but may occasionally have…

Unit price drops down to 0 when changing the quantity of "ordered" on the same line item. Is this normal behavior, or was this intentionally implemented at some point? Can anyone point me in the direction of an article to reverse this? Thanks!

In Sage 100 Advanced, 2022 changed the item history from based on fiscal year to calendar year and then ran the Item History Recalculation. It starts and runs and then returns the following error message. Error 32, Invalid or redundant Input/output…

My company is in the Swine Industry. We are wanting to be calculating close outs in the barns of our various farms. What this means is say we fill Barn A at Farm 1 and then we empty it we want to be able to calculate the cost it was per pig. Farm…

Is there an easy way to set up backup withholding for a vendor in AP? We need to withhold federal backup for a subcontractor.

Have a report and one cell I need to change the the field where the gl account is in. When I change the column to where the GL account is, Excel says there is an error yet there is no error in the formula as all I am changing is the GL account. Formula…

Hi, I need some help on this unit cost. PO cost was around $32.00 for this product. We buy one at $32, and then sell it. For some reason, the cost changed over time, and became unrealistically big. I'm wondering what might have changed it. I don't see…

I am trying to determine what criteria Sage uses when classifying transactions as either "sold" or "Issued". Any guidance would be appreciated.

Does anyone have any idea why an inventory item would show a negative amount on PO. The inventory trial balance report does not show any of the negative PO amounts, and I don't see them on the Detail Transaction Report, either. I am having trouble locating…

What's the key to getting these (EPFML, EPSLO, EPSLS) expired codes from gumming up my Employer's Expense Summary and quarter end/year end reports? It prints on some of my clients, but not others and I'm not easily finding the difference in the way I…

Hi All, Came across an issue in Work Order I was hoping someone might be able to shed some light on - for a given work order, we are simply issuing the necessary raw materials out of inventory for the work order, then completing the finished goods,…

Hi Guys We are having an issue with an item that is showing a QOH of 2 but on the history tab its actually showing the correct amount which is -34. I have ran a rebuild for modules IM, SO & PO to see if this would correct this but it didn't fix it.…

I have a client that received an email about problems with the payroll deduction balances being reset incorrectly. I looked on the year-end center and didn't see any notices. The email address it came from is [email protected]…

We discovered a flaw with state sales tax not calculating properly and I was in contact with SAGE support about an issue. The issue was with sales tax not computing correctly when entering freight on a repetitive invoice. I was told it is a flaw in the…

I've developed a script that, for some customers, discounts TX ItemCode's to absorb their AvaTax calculated sales tax and present a invoice total including sales tax (but not freight) equal to the original net invoice, but when the invoice is imported…

Looking for a way to or find a modification for creating payroll deduction based on % of Gross less Medical Insurance and cafeteria plan (FSA). Anyone experienced this request before?

Before I go down the Avalara route, wanted to see if anyone has any creative suggestions for handling sales tax unique to Florida. Equipment Sales over 5,000.00 (only equipment sales ) First 5,000.00 is state and county tax Over 5,000.00 is just…