Sage 100

Client is reporting three employees had NEGATIVE SIT (-$500) calculated during a recent payroll processing. IA recently released a new W-4 form. Accounting required all employees to update their exemptions using the form. These three employees had LARGE…

Hello to all, Have a question regarding Weighted Average Cost and FIFO when returning purchases to vendor 1- Weighted Average Cost we have following purchase: 10 unit @ $20 & 5 unit @ $15 so average cost per unit is $ 18.33 = (10*20)+(5*15)/15 after that…

We are producing a custom item for a customer. They will be charged $20,000 for their first order on Net 30 terms...which covers the full run. They will only be taking a portion. The remainder will be on our property and when we ship out any of the balance…

When generating a check for ONLY a pretax deduction refund, the refund taxes are not being calculated. If I add a earnings line and pay a penny, the taxes generate properly (but I have overpaid the former employee by a penny). KB 96467 suggested adding…

My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly…

Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…

This tax is paid on WA hours worked by WA employees. I cannot get it to calculate that way. It calculates on all hours worked. Even the hours worked in Oregon, which do not have to be included. How do I set this up? After many hours with support, the…

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…

Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…

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…

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…

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

There is preliminary discussion in our company about changing our inventory valuation method in Sage 100. All skus are currently at Average Cost and discussion is to change to LIFO. I have been looking to find more information on the technical/system…

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 considering purchasing this module to use for a new manufacturing division that is schedule to open soon. I was hoping to get some advice on how the installation went well or poorly for your organization and whether you would recommend the purchase…

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…

We have customers that buy a new piece of equipment and trade-in an old one at the same time. How would we record the trade-in on the sale? Do we put a negative amount in the quantity field? This appears to use the wrong cost for the returned item.…

I have set up our payroll calculations. Under our state unemployment our rate is 2.4% and I have it set up that way however it is only calculating 1.8%.....HELP??!!