Browse By Tags

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

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…

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…

This is a very broad question because I'm continually amazed at how little I seem to know about this screen. I need to gain an understanding of which are the hard numbers that come from stock transactions vs which are screen calculated numbers that…

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

Hi all, I hope you are all well. We have experienced in the following scenario on one stock item during Order Entry: Qty on hand = 0 Qty Committed = -3 Qty Available = 3 Negative inventory is never allowed. Could anyone shed some light on…

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…

Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good. Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…

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…

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…

Who wrote or currently owns the program 'autoassemblybyinvoicerange'. You run the program from the desktop after invoicing but before Day-End. It automatically assembles the bom's on the range of invoices. Saves a boat load of manual assemblies in IC…

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…

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…

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…

When using a labor inventory item in an assembly, does Sage require the labor inventory item to have a quantity or does it go ahead and apply the labor if the labor inventory item has no quantity (0)? Other stock items require at least a zero after the…

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…