Browse By Tags

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?

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 would like to be able to start accruing use tax at the time of invoice entry in A/P to make it easier to do our quarterly S&U tax report. After trying to test this in a test company, it does not seem that this is a possibility in BW 2018. Can someone…

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…

We are having an issue with a specific 2% Net 30 Vendor whose invoices frequently arrive too late for us to make the discount. When we do our invoice payment selection for the vendor, the discount is applied. This happens even when we set a specific discount…

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…

I am a Commercial General Contractor. I am new to Sage and am quite surprised to see Sage 100 doesn't have a stock Subcontractor Payment Application form. Typically, I have used these Forms to recap a Subs Progress in order to issue payment. We issue…

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…

We have a specific vendor that requires 50% prior to shipping and 50% net 30. Is there a way to put that information in Sage 50?

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 to post sales tax paid to the same account as the item purchased? For capital goods expenditures the entire cost, including tax, needs to be depreciated. The tax can't be expensed in the current year. Currently the tax for all purchases…

I have a supplier that offers a percentage discount off the entire monthly statement if the statement is paid in full within 10 days. I see that Sage has an option to set up a discount from the date of an invoice but I don't see anything to have a discount…

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…

We have a City tax for employees who work within city limits. We use the Locale option to calculate this. It was recently discovered that if employees live in another state, the Locale does not allow the individual's state tax to calculate. We have several…

In doing some research for a client, I discovered an apparent inconsistency in the methods used within Sage 500 to calculate the values in tarCustStatus.AvgDaysToPay and NoInvcInPmtAvg . When calculated in sparModPostPmtApplCS (called from sparModPost…