Browse By Tags

  • ILSIT - Illinois State Income Tax (Illinois Income Tax Withholding)

    Just starting the first payroll of the 2019 year and I was verifying the calculations from Sage 50 verses online calculators such as paycheckcity.com. Three out of the four (4) paychecks matched perfectly with the online double check. The disconnect is…
  • 2019.1 CPP Deductions

    The CPP deductions seem to be calculating wrong on salaries that are higher than the CPP maximum amount since the 2019.1 update. Example: Salary: 100,000 CPP Exemption: 3,500/26=134.62 CPP rate: 5.1% 100,000/26 =3846.15 3846.15-134.62=3711…
  • adding a taxable benefit after the fact

    I have a client who for the first half of the year took a salary so I processed them through the payroll system. He switched over part way through to draws (which will be dividends). I've just received the year end adjustments from his accountant (yr…
  • Multiple tax jurisdiction in US Payroll

    Hello, Has anyone figured out a way to have multiple tax jurisdictions on a single UP paycheck. Scenario is that a person works 10 in City A, 15 Hours in City B and 15 hours in City C, so each needing a different set of taxes. There are local taxes…
  • Short term Disability

    I have an employee who just went on short term disability. How do I post his paycheque in Sage 50 Quantum ? He will be paid by Manulife directly.The employee is paid hourly, works 40 hours a week and being paid semi-monthly. Thank you!
  • 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…
  • Does anyone know why the Quebec payroll taxes changed as of April 1 2018?

    In December I installed the payroll updates for 2018 and changed the personal exemption to 11,809 federal 15,012 provincial and everything seemed fine. At the end of March I was sent another update from Sage which I installed and since then the amount…
  • State Withholding

    What have other companies done to setup reciprocal state withholding? This becomes an issue only when the primary state withholding is higher than the withholding in the state for the construction project. Connecticut is our primary (HQ) state. …
  • Sales Tax Report: Invoice Return (credit memo) amounts showing in taxable column are higher than amount of credit.

    Please see below Sales Tax Report. What are some possible reasons that the amount showing in the Taxable column would be HIGHER than the amount of the actual credit. We process all credit memos using the return invoice feature of the Order Entry module…
  • Bottle Deposit

    Hello, My company is now distributing bottled beverages and we would like to know if there is any way to automate this in the system. In other words how can we add this fee to the bottles being distributed to NY and CT - These are the only states in…
  • 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
  • Is it possible to alter labor hours using a calculation without changing the takeoff unit to hours in Estimating Extended?

    I want to add a calculation in my assembly that will change the labor hours behind the scenes. My takeoff unit is EA and I don't want to change that. For example: If I have a qty of 10, I want my labor hours to be unaffected. If I have a qty of…
  • How do I make a new payroll formula based on a percentage of gross pay?

    I need to first compare 15% of Gross Pay to a flat amount of $114.75. If 15% of Gross Pay is greater than $114.75, then use $114.75. If 15% of Gross Pay is less than or equal to $114.75, then use 15% of Gross Pay. Here is the formula I have so far that…
  • 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,
  • quoting & invoicing - how to show 1 item, but for multiple days?

    We are a company that rents items to clients. We have our rental items setup in Sage as inventory items. Often, we rent 1 item for multiple days. On the quote / invoice, we have to put '3', if the client rented it for 3 days. Many clients are confused…
  • Can I run my 2017 payroll before w-2's are complete?

    FormerMember
    FormerMember
    Do I just need to close my current month (December) first and download the service pack? Will the service pack change my w-2 numbers because of the new 2017 tax tables even if December is closed before it is downloaded? Can I still make changes to…
  • UOM that are variable

    We have been using an old piece of software that tracks rolls of paper for us. We are planning to discontinue using that software and are exploring whether we could track the rolls in our inventory system. The problem is that the PO would be issued for…
  • Material Variance Calculation in X3

    I am working within the WIPCOST (Manufacturing Module) table and trying to determine the calculation of material variance. I put in my Work Order number in the MFGNUM field. The TXNTYP is 9 for Material Variance. Then the AMOUNT is what is booking to…
  • Material Variance Calculation in X3

    I am working within the WIPCOST (Manufacturing Module) table and trying to determine the calculation of material variance. I put in my Work Order number in the MFGNUM field. The TXNTYP is 9 for Material Variance. Then the AMOUNT is what is booking to…
  • Ops inquiry IC item location tab

    Hi there, in Ops Inquiry IC Item Inquiry (in Location tab) the Most recent Costing Unit does not update with the Average Unit Cost. The Source App is P/O Issue occurred with one item only. Any idea there.
  • Benefit Deduction Question -

    Is there a way with Sage 50 to enter an hourly deduction for employee benefits that self calculates based off posted hours? (Where we enter the hours worked and it calculates a deduction total based off a per hour benefit cost). Example: Benefits cost…
  • 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…
  • AR Average Days to Pay calculations

    In doing some research for a client, I discovered an apparent inconsistency in the methods used within Sage 500 to calculate the values in tarCustStatus.AvgDaysToPay and NoInvcInPmtAvg . When calculated in sparModPostPmtApplCS (called from sparModPost…
  • Roll over of Vacation Pay incurred

    I have started a new year for 2016, performed the back-up and all necessary aspects but when I entered payroll cheques all retained vacation pay was at $0.00. There is retained vacation pay earned by a number of employees, how do I carry it over from…
  • inventory multi-pack setup

    Trying to understand units of measure and multi-packs and after reading posts here I think I may be even more confused. Sorry if I should have been able to get the answer from previous posts, but any help is appreciated! We buy and stock an item in…