Browse By Tags

  • 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…
  • Calculation issues in exchange rate: AP Payment

    Making an AP Payment Entry to a foreign vendor in AUD. FJD is the local currency We are converting AUD 21,640 at a rate of 0.6620 per FJD The amount should be FJD 32,688.82 Sage300 calculated FJD 32,689.238 Is this because the decimal places are set…
  • 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…
  • Retention for Subcontractors

    Asked two years ago and didn't get any replies - When releasing retention on a job, the AR module allows you to update the due date for invoices. This allows you to run aging reports with the retention showing in the correct column. However, when…
  • 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…
  • Need to set up backup withholding for a Subcontractor in AP

    Is there an easy way to set up backup withholding for a vendor in AP? We need to withhold federal backup for a subcontractor.
  • 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…
  • Payables Credit Note

    I have received two credit invoices from a supplier, we entered them into Sage 50 using the payables Credit Note option. When we look at the credit notes they show properly as negative dollar amounts, but when we run an Supplier Aged Detail report they…
  • Accounts Payables discount not posting a Journal

    I have a client who's vendor is giving out some accessories with a 100% discount in a certain month. On Purchase order, the client is capturing this accessories with the previous cost but discounting it at 100%. The challenge is and I stand corrected…
  • Open Invoice Register showing invoices which is fully paid.

    Dear Team , We have a scenario where for some vendors, some invoices appearing in open invoice register which is fully paid , Attaching screenshot for one vendor for your reference , similarly we have few vendors as well . Thanking in…
  • 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…
  • VAT recording

    Dear Team, We have noticed a strange issue in treatment of VAT. The VAT is calculated in AP correctly and reflected in VAT report as well. However, while posting in GL it has been split into two base accounts named 1601 and 1690. Below is an example…
  • 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…
  • 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…
  • The Accounts Payable in my Balance Sheet is showing zero

    Why is it showing zero and where do I have to look to check the problem. Thank you in advance.
  • Trial balance is showing an AP debit balance, but vendor outstanding balance show zero

    Trial balance and the Balance Sheet is showing a debit balance in AP, but Vendor aged report shows zero, on the same date. The balance in the trial balance is composed of the payments made on the invoices entered historically, and every invoice was paid…
  • Payroll FWH Calculation Verification

    I’m processing my first new employee under the 2020 W-4 form, and I cannot reconcile using the IRS tables to verify Sage’s calculation. Anyone see where I am going wrong? Single, $2000 for dependent, $860 taxable this week, state is NH (no income tax…
  • 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"?
  • Sales Tax Liability-after the fact

    Is there a way to create a sales tax liability after the fact? We have a vendor that we have made progress payments to and still owe some money to. It is an out of state (out of country actually) vendor who did not include state sales tax in their proposal…
  • 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…
  • INVOICE WITH SEPERATE EXCHANGE RATE

    I have an invoice for inventory $1620.46 but it also has $517.75 us exchange totalling 2138.21. how would I enter this? How do I ensure that the inventory is charged out without losing money?