Sage 300

I would like some help to see if there's a way to view the current item costing and the associated bucket QTY. We are having issues with the transaction cost of the top level item coming out at seemingly an erratic cost, therefore wanting to understand…

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…

Has anyone else had an issue with tax calculations on non periodic payments since the installation of the January 2024 tax table 8.0B update? I have several Bonus Payments that I was trying to process for a client and the CPP and EI over-ride works…

Is it possible to setup pricing with Sage where there would be a discount based on the quantity. We are looking for a way for this to be done in Sage: to setup pricing for the first item to be free and then the next item a price needs to be paid.

I understand that CPP2 isn't supposed to kick in until the regular maximum is reached, but I have a case where it has already starting taking CPP2 for an employee even though it's only February and he only has ~$12,000 in earnings so far. Other employees…

One business we do payroll for participates in HOOPP (Healthcare of Ontario Pension Plan). Is there a way to set up a deduction code to automatically enter the appropriate contribution amounts each pay? Of note, HOOPP uses an "employee low" and "employee…

Hello, I am looking to automatically have an overhead allocation hit each job based on the division in which the job was created. Does anyone know if this is possible? Specifically, I am looking to assign an overhead cost of 4% of each contract value…

I am running into a scenario of PO tax update and need help understanding the functionality and if I am following the correct process. Consider the following steps in Sage 300: Create a PO in sage300 with amount 100+taxes (say12). Once PO is fully…

I'm seeking a solution for the tax calculation outlined below. Within Sage 300, how can we configure the system to perform the following calculation: Gross amount: $100.00 - T1 @ 5%: $5.00 - T2 @ 2.5%: $2.50 - T3 @ 2.5%: $2.50 - T4 @ 1%: $1.00 Subtotal…

Hi Dears, I have a questione , what is the exact set up to calculate interest on invoice for customers. is billing cycle and interest profile connected together for calculation?

Dears how can I calculate the interest on the customer who have overdue invoices. what is the setup that should be done? Thank you

I haven't seen any discussion in here regarding these required changes. Will the Jan tax table update incorporate this? What else will be involved to set up the employee records? There is also a new tiered CPP calculation coming. I assume that will…

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…

Just wondering what tables and fields I need to calculate the "Average Days to Pay" that shows up under the AP Vendor record on the Activity tab? I tried the APVSM table but that doesn't seem to correspond with the data shown on the Activity tab.

Where can I find examples or formulas for sick leave for CO and MN

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…

I've been working with a macro I designed that is searching and removing items from IC. It has been working well for all the items except the ones with the description of "DISC". When the browse line below executes it doesn't find any matches. There…

How would I set up a group life insurance policy for which the employer pays 100% of the premiums but get coverage in excess of $50,000? I'm mostly concerned about tracking the tax to the employees. Do I need to set up two different benefits - one that…

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…

Having a major issue running payroll - I've inserted one timecard for each employee - when calculating the payroll report, everything comes up just fine. All payments and deductions are correct. But when I go to actually print the checks - each employee…

vacation pay stopped accruing and being paid out for a large number of employees but not all

Is there a way to update the prices on standing orders to reflect prices that have changed on a price list. ie. standing order has line item "Widget A" @ $2.00 from price list "Price List A" We then update "Widget" on "Price List A" to $2.50. We…

Hi, We have been using Sage300 for years (latest v2022 PU1), and there is a new requirement from business related to customer's down payment. It is simply like this: We receive an order from customer and they agree to pay the down payment (DP…

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…

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…