Browse By Tags

  • 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…
  • 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…
  • 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"?
  • 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…
  • 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 to setup Tour Operators' Margin Scheme (TOMS)?

    Hi, There is any standard procedure to implement TOMS tax scheme? 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…
  • 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…
  • 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…
  • I HAVE AN ISSUE WITH MY WORK TICKETS.

    NOT ALWAYS MY PRODUCTION USE THE SAME QUANTITY OF MATERIALS. WHEN I CLOSE THE WORK TICKET IT DEDUCTS FROM INVENTORY THE QUANTITY AS THE BILL OF MATERIAL AND AD THE COST OF THOSE MATERIAL TO DE FINISH GOOD COST. I NEED A WAY TO EDIT ONLY THIS WORK TICKET…
  • 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…
  • 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…
  • Estimator / Project Manager Position

    South Bay Landscape Company is currently seeking a qualified Special Projects Estimator/Project Manager to join our team. This position requires an understanding of the complete bidding process of landscape installation or renovation of projects along…
  • 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…