Browse By Tags

  • 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…
  • Payroll Tax Withholding for the new 2020 W4

    Hi guys, I do have the most recent version of Sage 300 (18.4 Update 2) but I think I found an error with the Federal Tax Withholding calculations, unless I'm interpreting something very wrong. Whenever the new year starts, I spot check tax withholding…
  • Tax code

    FormerMember
    FormerMember
    I was trying to do the tax code and it did not allow me the pu the tax rate. help please
  • 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…
  • 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…
  • HRMS Canadian Payroll: Ontario Employer Health Tax

    In HRMS 2017 Canadian Payroll, does anyone know how to set up Ontario Employer Health Tax? Specifically, where do we enter the exemption amount? We've pulled the tax code from HRMS table, but there is for field to set exemption and the system starts calculating…
  • Payroll Calculation - OR statewide Transit Tax Effective 7-1-2018 - rate .001 ---Wondering how to set this payroll employee calculation up in Sage?

    FormerMember
    FormerMember
    Payroll Calculation - OR statewide Transit Tax Effective 7-1-2018 - rate .001 ---Wondering how to set this payroll employee calculation up in Sage?
  • 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…
  • 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
  • Tax excluded line total vs TAX EXCLUDED TOTAL

    I am trying to figure out why the system is out putting two different amount on the invoice for TAX EXCLUDED TOTAL and Tax excluded line total. The invoice total seem to be correctly adding up on Tax excluded line total. However, the PDF file take the…
  • tax error - tax account not linked

    HI I'm new to SAGE and accounting in general but starting to get around better. I have been getting an error message when trying to enter purchases in the GL. "This transaction uses linked tax accounts, but you have not entered tax information for…
  • 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…
  • Tax Liability Report Wrongly Calculated January 2017 Gross Income for 941

    I ran my Tax Liability Report on 2/1/2017. I paid my 941 taxes for January based off this report. I just ran my 941 quarterly Tax Return and discovered January's report was incorrect causing me to over pay my 941's. Why would this happen?
  • 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…