Browse By Tags

Hi everyone, I'm new to sage 50 US. I know that sage 50 can only show the month-end inventory balance for the last 12 months. What if I need to go back further? Is there a way I can do it on the back-end using the database and pervasive sql to do…

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…

How are all of you handling your amortizations for loans/notes? it seems it would be a valuable feature to incorporate into the program a quick t-value of sorts that will stay with that GL Liability account for backup instead of processing outside of…

Is there a way to not allow billing of inventory items if they are negative? Or a password protected authorization to do so?

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…

I am seeing in my cost of sales account in the general ledger report amounts that are unknown for only 1 company from the month of July to October. Usually any invoice that is paid goes into cash receipts report but those particular invoices are only…

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"?

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…

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…

Just starting the first payroll of the 2019 year and I was verifying the calculations from Sage 50 verses online calculators such as paycheckcity.com. Three out of the four (4) paychecks matched perfectly with the online double check. The disconnect is…

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…

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. …

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…

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…

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

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…

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…

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,

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…

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…

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…

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…

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…

Hi there, in Ops Inquiry IC Item Inquiry (in Location tab) the Most recent Costing Unit does not update with the Average Unit Cost. The Source App is P/O Issue occurred with one item only. Any idea there.

Is there a way with Sage 50 to enter an hourly deduction for employee benefits that self calculates based off posted hours? (Where we enter the hours worked and it calculates a deduction total based off a per hour benefit cost). Example: Benefits cost…