Browse By Tags

  • CPP2

    I have an employee who reached maximum on the first threshold of CPP - but the system didn't deduct anything from CPP2. If i create a pay for the next period, it starts deducting from CPP2. Should these deductions appear at the same time on the paycheque…
  • Payroll Calculating NEGATIVE SIT Withheld - v2024.0.0

    Client is reporting three employees had NEGATIVE SIT (-$500) calculated during a recent payroll processing. IA recently released a new W-4 form. Accounting required all employees to update their exemptions using the form. These three employees had LARGE…
  • LOCAL TAX CALCULATION

    Hello In my place I have some local taxes for professional services, i need to create like a "rule" that calculates the 10% tax for professional service or the 6% is a waiver certificate is provided, from the total amount of the invoice. This calculation…
  • 2024 Federal Tax Bracket Update

    I have updated Sage 50 Payroll to 20240101. The federal tax brackets were to change for 2024, but when I go process payroll for the new year the federal amounts for all employees have stayed the same as 2023. Spoke to support yesterday and all they said…
  • adding old assets to SAGE

    Hello, I added many old assets to SAGE but I'm still struggling with the older assets that are on their second half of life . For example, my building that was put into service in in 1991 is only 32 years through its 50 years but when I put in 18 years…
  • Purchase return in Weighted Average & FIFO Inventory Methods

    Hello to all, Have a question regarding Weighted Average Cost and FIFO when returning purchases to vendor 1- Weighted Average Cost we have following purchase: 10 unit @ $20 & 5 unit @ $15 so average cost per unit is $ 18.33 = (10*20)+(5*15)/15 after that…
  • SEI Subtotal Average Rounding & Incorrect Value

    Hi, I'm currently looking into some strange behavior in how SEI is subtotaling values. Specifically I have a report where I want to see the Average value of our costs. Rounding to the Nearest Dollar For illustrative purposes, I'm going to use our…
  • Average Cost evol./movement using Order Price rather than FIFO

    Hi, We've noticed a few funny jumps in our average costs. Please see the attached example. Is this being calculated correctly? The product is set the FIFO costing valuation method so not sure why it's using order price here and then decreasing…
  • 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…
  • Fringe benefits and before tax IRA

    I have a payroll question related to fringes and employee IRA contributions. This is a simple IRA and is taken before taxes. I have the fringes set up as a benefit on the appropriate paygroups with an offset for each employee based on the benefits we…
  • Wokers' Compensation Calculations

    Does anyone happen to know the 'behind the scenes' math for the 5-3-2 Workers' Compensation table window? I need to know how to set it up for the most accurate job/employee costing. For example does the Liability column calculation run after the Employer…
  • WA State PFML

    This tax is paid on WA hours worked by WA employees. I cannot get it to calculate that way. It calculates on all hours worked. Even the hours worked in Oregon, which do not have to be included. How do I set this up? After many hours with support, the…
  • How to change average cost lot with code

    Hi everybody. I need found system to update average cost lot without Miscelaneos Receipt /Miscelaneos Issue. For example: I have product A with 100 units of lot LOT1, and cost is 10. This stock I create with an Purchase receipt. Now, i create a…
  • Sage X3 Fixed assets depreciation Calculation done but cannot see the Changes in Journal Entry

    I have implemented the fixed asset in Sage X3 version PU9 as per the curriculum provided in the training by Fixed asset instructor from Sage University. Performed every step as per his instruction. only problem that I found was I cannot see the any…
  • Cumulative AUC cost versus Stock valuation report

    Hi City dwellers! nice case for you today! As always funky one! First question: Can we use the valuation report in the past for average price method? Cumulative or others. I documented a case with Sage Support but unfortunately, they were…
  • 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…
  • PTO Accrual: Limits and carryover

    Good Morning, I am new to the Sage Community about 4 months. I am evaluating the leave balances and accruals for all of our employees and I am having some concerns as to the set up. We have employees that earn 40 hours a year (new Hires) then after…
  • Federal Income Tax allowance

    On the Calculations tab for an Employee (5-2-1) how do I specify that the Federal allowances specified on the employee's W-4 is "married but withhold at higher single rate"?
  • Can you adjust the time period used by Average cost?

    We are using Average Cost, but I"m finding that during the first couple of years using Sage MAS 500 there were a lot of issues with incorrect settings, bad data, user errors, etc.. and this has caused an inflated value with our average cost. Can I somehow…
  • Subtotals in AP (Select Invoices to Pay)

    When I go in AP to set invoices up for payment ... AP - Tasks - Select Invoices to Pay - On Screen List. Is there a way to show subtotals for each of the vendors / suppliers I am paying? I do see that I can go in and view the total (by going into…
  • Worker's Comp - Date field

    There is an Effective Date for Worker's Comp but no Ending Date. So, the Effective Date really does you no good, because if you have the rates for this year, then add a second line for the NEW rates effective today, when you calculate WC, it doubles…
  • 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…
  • How does Average Cost Evolution screen work?

    This is a very broad question because I'm continually amazed at how little I seem to know about this screen. I need to gain an understanding of which are the hard numbers that come from stock transactions vs which are screen calculated numbers that…
  • 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…
  • 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. …