• 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…
  • Calculate Interest on overdue invoices.

    Dears how can I calculate the interest on the customer who have overdue invoices. what is the setup that should be done? Thank you
  • Payroll deduction as percentage of net

    Canadian Payroll - I cannot figure out how to set-up a garnishee code that calculates on percentage of net pay. Is this even possible? I've tried every possible combination of Calc Bases and "take deduction before". I can get it to calculate tax correctly…
  • Canadian Payroll wage rate table

    Does anyone know of a third-party product that will accumulate hours on an earnings code and change the rate once a threshold is achieved? For example, an employee is paid $25/hr. for the first 1000 hours worked, then $30/hr. for 1001 to 2000 hrs. and…
  • Payroll processing related question for 401(K) contributions under Secure 2.0

    Hello, The Secure 2.0 Act of 2022 will now require that effective 01/01/2024: that all catch-up contributions (i.e. up to $7,500 for employees over the age of 50) to employer-sponsored qualified retirement plans (e.g. a 401K plan) for participants…
  • accruals

    vacation pay stopped accruing and being paid out for a large number of employees but not all
  • tax on payroll advance

    Has anyone successfully set-up an advance repayment code that takes the net amount of an advance that is subject to income taxes? For example a $1500 advance is given and taxed so a net advance of 1069.83 is paid. At month end the advance repayment…
  • ROE generation skips pay periods with no earnings

    We have a client that issues ROE's quite often and there are times when the employee will have no earnings or cheque for a pay period in the middle of their last 27pp. Box 15C ignores that pay period by design but when uploading to ROE Web they are given…
  • 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…
  • Sage 300 - Payroll Quebec - QPP exemption and EI

    Hi, I am setting up a new database for a client, the QPP calculation doesn't take the exemption of $3500 and the calculation of Employer portion on Employment insurance is also wrong. Could you please help me on this issue? Thank you
  • Canada Payroll 7.3 - Calculate Payroll Error

    We have a client that is getting an error running calculate payroll. It does calculate , but at the end a message pops up: An error has occurred during the processing of Calculate Payroll. The error returned was 1. The operation being performed was…
  • canadian payroll

    An employee of ours want no income tax taken from her because she will earn less than the exemption on a td1 form. It is an actual option she can choose on the form. I thought I could just remove onitax and inctax from her taxes tab and that would work…
  • Box 52 Pension Adjustment not showing up on the T4

    We have 2 deductions set up for Pension. One is for the Employee contribution, and one for the employer portion. Both are set to 5% (Percentage of Base). The employee portion is set to go to box 20 and 52, and the employer is set to go to 52 only. They…
  • How does Sage 300 handle the CPP 3500 exemption

    I am working with someone that is new to Sage 300, but not new to Payroll. They have payroll setup, and we are trying to match the calculations from the other system (Sage 50) to Sage 300. We have entered all of the employees, and also entered their…
  • Payroll Cost Center Override on Taxes

    Client is running Sage 300 version 2020, but apparently this problem has been haunting them for years, in prior versions. A cost center override comes into play on employer tax expense, and we can’t figure out why. This happens only on earnings codes…
  • PR - Non-resident alien FWH additional tax

    Is there a Payroll formula that will automatically calculate the additional federal withholding tax for an employee that is a NRA? Or some easy way of adding the additional tax each pay period?
  • Posting EoY realized exchange gain/loss revaluations

    Hi, As I understand from a client of ours, based on IFRS r evaluation of gains/losses should be recognized in Profit & Loss account as at 31/12/20xx and transferred to realized Exchange gain/loss after closing the period. The client currently does…
  • Accounting for Financial Assets and Liabilities

    Please is there a feature to amortise bonds, or manage financial instruments in general, that will recognise changes in value in Profit or Loss? We run a small wealth management firm, investing in equity and debt instruments. Currently running Sage 50…
  • Pension Adjustment does not hold cents amount

    Hi all, Anyone having issues with the T4 Pension Adjustment Amounts rounding to the nearest dollar? I've looked on Sage's Knowledge Base and it seems that Sage 50 clients are also having the same issue.
  • General Ledger Labour Calculation

    We have a table in the database where we are pulling data for the number of hours for labour for different types of jobs. What we are looking at is that when one selects an automotive part for repair as a stock item that also there can be an option…
  • Payroll OT Calculation did not occur during Payroll Processing, is there anyway to re-run Auto OT Calculation?

    When we processed Payroll our Automatic OT Calculation did not occur, is there anyway to re-run Auto OT Calculation? A simple reprocess did not work. :(
  • Tax Class invalid input

    Hi, I try to import a spreadsheet from IC item list and when I proceed the following error show up: -Invalid input. Purchase tax class does not exist -Warning the next lot number does not contain an incrementable segment.You will not able to add…
  • How do I stop accruals on hours worked at a specific point since the maximum accrual has to include maximum carryover?

    The maximum accrual has to include maximum carryover, so if I want to let someone earn 80 hours but carryover a total of 120, the maximum accrual has to be 200 -- just in case someone has 120 to carry over, and earns all 80 without taking any. We are…
  • State of Georgia W2 & G-1003 submission

    Can anyone tell me how to do the required electronic submission of state W2's and G-1003 report thru Sage 300? We just upgraded and on our previous version I was able to run the W2's to diskette which I then uploaded to the state of Ga tax center. The…
  • AP Ageing with balance in functional currency only

    Hi, I'm runing Sage ERP 300 2014 PU3. I have a vendor which has no open invoices, however the AP ageing report is showing a balance in functional currency. How can I get rid of this balance?