• Sage intelligence add functions

    SI has a function for "GLActual" that nets the debits and credits. Is it possible to add 2 different functions to get the debit and credit separately? the data exists in the actuals currently included sub report.
  • 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…
  • 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…
  • Excel is not populating all of the data.

    I have an Intelligence report generating and excel document. There are several sheets. One sheet in particular stops populating part of the records at line 3000. The other sheets populate just fine past the 3000 line. This sheet has 8 columns of data…
  • 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…
  • 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,
  • CASE Statement WHEN add multiple fields

    I am looking for a CASE statement to replace an excel formula. Excel formula would be: =IF(TDMMYY="0816",(N2+O2),IF(TDMMYY="0916",(N2+O2+P2),IF(TDMMYY="1016",(N2+O2+P2+Q2)))) The one I'm trying that is failing is: CASE WHEN "CI_UDT_ITEM_SALES_PROJ…
  • 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??!!