• 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…
  • Costing from Multiple locations

    Is there a way to do the following without an IC transfer from Loc W to selling loc? Item A is received into Loc W but sold from multiple locations and they want the GL segment code to override depending of the location it is sold/shipped from ie Item…
  • Customs Duties - How do we add them as additional costs with different rates for different items.

    Hi all. With American tariffs changing a lot recently, and therefore being volatile and different between types of products, we are looking for a way to add customs duties as additional costs based on each of the individual duty/tariff rates for each…
  • project job costing overtime

    What is the most common way of tracking OT on projects using timecards? When the PJC timecard is entered there is only one default hourly rate for the employee. When the timecard is sent to payroll the OT is calculated accordingly. How can we capture…
  • 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…
  • What is the use of Unit Cost Column in I/C Kitting Items Screen?

    What is the use of Unit Cost Column in I/C Kitting Items Screen? For me it always remains empty.
  • Does anyone have experience using the Direct Cost feature in Job Cost?

    We are looking at starting to use the Direct Cost feature under the Job Cost module in Sage 300. It's new to me and I would appreciate any feedback on it's use or any issues that could potential happen when setting using it. Thanks James
  • CA ETT tax

    CA ETT tax, does not print on any reports? Should the Unemployment box be checked instead of FICA?
  • Cost in OEINVD table

    Hi, Where does Sage pull the information for this field? Thanks.
  • 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
  • Federal Indexation factor effective January 1, 2022

    The Release notes of the Canadian Payroll January 1, 2022 tax table stated: The federal indexation factor effective January 1, 2022 is 2.4%. Shouldn't it be 4.27% ? The 2021 Basic exemption was $13,808 and the 2022 exemption is $14,398.
  • 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…
  • Using order entry to track job costs

    Hello, We've often wanted to find a way to track our job costs in Sage, but have struggled to find a built in way to do so without purchasing additional modules or 3rd party software. Recently, we had the idea that we could make an item category such…
  • Quantity On hand at IC Location Detail different with ICILOC.QTYONHAND

    Hi All Why my Qty On Hand at IC Location Detail different with ICILOC.QTYONHAND? any solutions?
  • CS0120 Options for Calculated fields

    I was having a discussion in another post but it was getting too long and I figured this might be a good post for others to find. Trying to grab a lot of data from Sage, and I was pointed to CSO120. It's been great so far, but I've run into a couple snags…
  • We don't pay Overtime rate on PTO. How can we get Sage 300 Payroll to deduct PTO hours from OT calculations?

    Like most companies, if an employee has over 40 hours solely due to PTO (vacation, holiday, sick, etc..) in a given week, we do not apply the overtime rate to the hours over 40. However, we can't find a way to get Sage Payroll to not factor in the…
  • Sage 300 Accounts Receivable

    Sage 300 Accounts Receivable invoicing - how can I have a negative line item within my invoice. We are giving a discount, but when we print the invoice, it prints out as a separate credit note. We would like it all on one invoice. Any help would be greatly…
  • Workers Comp Codes Sage Payroll

    I import my hours and rates and let Sage determine overtime and overtime rate based upon the rules I setup in Overtime Schedules. Is there a way to get Sage to change the Workers Comp Code when it imports to exempt for Overtime? It will not allow an full…
  • Sage 300 V2021 PU2>I/C>QTY on hand not updating correctly

    Hi We have a client who is running Sage 300 2021 Pu2. They recently upgraded and are experiencing issues with Inventory control and Lot Tracking. Posting here as advance warning to other BPs intending to upgrade. MAKE SURE YOU TEST TO SEE IF YOU ARE…
  • Qty committed vs Qty Back-orders

    Is there any way to have qty committed to order and have 0 value in back-order? We are trying to manage our back-orders but it doesn't make sense to put qty committed, same as back-order qty if stock is available? ideally we would like to commit to stock…
  • 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…
  • AR Debtor Aging Report

    I need to recalculate AR debtor balances for my aging report comparison. Which tables should I use and which fields will help me identity the amount due?, I will greatly appreciate your help.
  • Rate Table error

    Hi! I keep getting the below error when trying to generate the WIP "No Markup Table for Rate Calculation". I don't have a markup table though, just a rate table....thoughts?
  • OCIP Job - Zero Amount General Liability Payroll Fringe

    Looking to see how to set up OCIP job to calculate general liability payroll fringe to zero. I found instructions on how to set up OCIP to calculate workers' comp (WC) to zero but one of our new jobs is an OCIP job (just GL, not WC). Right now, our…
  • 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…