• Refunding Pretax deduction v2.22.2

    When generating a check for ONLY a pretax deduction refund, the refund taxes are not being calculated. If I add a earnings line and pay a penny, the taxes generate properly (but I have overpaid the former employee by a penny). KB 96467 suggested adding…
  • SAGE 2020 Warehouse Negative Inventory

    Hello everyone, Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses. Thank you
  • How Avalara Calculates Sales Tax

    I have invoices that have the tax schedule on the header tab as NONTAX ​ and the ship to location code (tab 2) has AVATAX as the tax schedule. No tax is calculated. If I change the header tab tax schedule to AVATAX then tax gets calculated. Shouldn't…
  • Where is UnitCost in SalesOrderDetail and SalesOrderHistoryDetail from?

    Hello, I'm working with Sage 100 and currently working on figuring out job cost. I have a question as in the subject--Where is UnitCost in SalesOrderDetail and SalesOrderHistoryDetail from? Would someone please help me understand the calculation logic…
  • PO and mfg variance calculations (PPV)

    I'm trying to understand exactly what is in the the PPV amounts (and how calculated) on our Sage income statement so we understand the information reported, if the manual JE's are correct,a and if we need to change our processes. We have two GL accounts…
  • After a report opens, it gives a #nameerror for every single formula I've used in the report

    I am able to open reports just fine on my computer. My boss, however, is getting #name errors on all forumulas when he runs the same reports. The 3 add-ins are turned on in his Excel. It worked fine for him yesterday. Any idea what the problem…
  • Freight rate as a percentage of sales order $ total

    Since Sage100 does not offer out-of-the-box an option to calculate freight based on order $ total, has anyone found a work around? We have different freight percentages established and would like to somehow designate a customer to a particular freight…
  • Payroll 2018 - Local Tax Calculation

    I am testing Sage 100 2018 with payroll before upgrading from 4.5. We operate in PA, and all employees reside in PA. Several employees live in townships/boroughs/cities that have a local income and/or school tax. I've been unsuccessful in getting local…
  • Credit memos and open invoices in SO module

    I created two credit memos in the SO module and noted that they should apply to two specific invoices. However, the invoices had already been paid. Now the customer wants to take these credits against a different invoice. When I go to cash receipts entry…
  • Sales Tax on RMA

    Hello every one, i am trying to view how much sales tax has been calculated on a RMA . i am not sure how can i set a Tax Schedule for an RMA can anyone please help me on this Thanks
  • JobOps configurator item quantity calculation rule help please

    Help please for some reason I been trying on many ways and is not pulling the right quantity on base quantity rule that I set. IF FEATURE[CONFIG]>DUBLE @PART_QTY =2 unless i'm doing totally wrong any advice? Thank you,
  • Payroll Locale should not be Tied to State

    We have a City tax for employees who work within city limits. We use the Locale option to calculate this. It was recently discovered that if employees live in another state, the Locale does not allow the individual's state tax to calculate. We have several…
  • Payroll Calculations

    I have set up our payroll calculations. Under our state unemployment our rate is 2.4% and I have it set up that way however it is only calculating 1.8%.....HELP??!!