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…

Is there an option to automatically update all items on an old quote with the most recent cost (last cost) before converting to a sales order. Currently our sales team is deleting and re-adding all items that have an updated cost.

SI has a function for "GLActual" that nets the debits and credits. Is it possible to add 2 different functions to get the debit and credit separately? the data exists in the actuals currently included sub report.

We have run into an issue with the commission calculation process used by Sage 100. Sales reps are paid on "net receipts after discounts" not net invoice or gross profit. Also, there are two columns on the Salesperson Commission Report; one being Invoice…

How would I carry PO credit forward when the invoice received is for less than the original PO? It keeps closing invoices as I enter them when there should be a balance left for future invoices to be applied to. Please advise. Sage100 C Most of our…

We currently have sales kits set up in Sage 100, but I notice that when an order is entered, it does not reflect in the Sales Kit, but only in the components. Is there a way to correct this? Quantities showing on Sales Kit Item Quantities as…

We are using FIFO for items which results in different tiers existing for PO receipts and this is working as expected. And actually we have been using FIFO for quite a few years. Sales Orders are created and later invoiced. Due to the nature of our business…

I have been having an issue with the totals on the Settlement reports in Virtual Terminal not being correct since May. Some days they are okay, but most days they just do not sum properly. I've had 2 support cases open with Paya and not only are they…

Have a client that wants their AR Aging based on due date. So invoice due date was 6/26. On 6/27, the client expected to see the invoice amount moved to the 30 day bucket. I seem to recall that the invoice will move to the 30 day bucket after the…

Hello, I am looking for help on how to create a price structure for the following scenario: One customer receives a 20% on multiple product lines. How do I structure price codes and price levels to make this happen and where do I need to input information…

new install of sage standard 2022 v 7.10...trying to setup fixed overhead costs in PM and just not working out for me... In W/O we used operation codes, parts per hour, to determine machine rates and labor costs. I find labor, working just fine, but…

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…

I'm not sure if this is an elementary question, but I was wondering how to best handle inventory costs in the following situation. We keep inventory as average cost valuation. Periodically, we get promotions activities from vendors where we're "selling…

Is there a way to Recalc Cost on a PO similar to the Recalc Price function on SO? We have many open POs in our system where we need to update line item cost to new vendor cost based on price increases. Those new vendor costs are uploaded to the SKU, so…

I have a client that runs a Bi Weekly Payroll. They would like their Time Off Accruals to be based on weekly hours not bi weekly. Is there anyway to do this with a Bi Weekly Payroll?

We have a client on 4.5 that uses Item Pricing by Total Quantity, based on Item Category. They are taking on a new product line, however, that they want to implement discounts by line item based on the total PRICE of the items on the order within that…

Someone really needs to explain to me why with Sage invoices, inventory and, payables can't be updated until accounting does what ever is they do. Leaving the GM, Sales and inventory blind for half the month unable to finalize anything. This is not how…

In receiving goods, occasionally there is one invoice for the items themselves, (paid to the vendor), and another invoice for the cost of shipping, (paid to the shipper). For the former invoice, all the items are invoiced, and in invoicing the PO, none…

Will 401k deduction automatically calculate up the $$ goal set up in employee maintenance? Or do I need to uncheck or turn off the deduction when at/near maximum allowed?

We have some items where the Sales UOM is EACH and standard is KG. When adding these items to a sales order, the sales quantity shows as EACH however the price is coming over as the standard price x the KGs per EACH. This only occurs for a handful of…

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

We are running Sage 100 2019 (6.10.4.0)(Payroll Version 2.20.0.0). I hope someone has an idea how to correct this because I'm at a loss. We have one employee that all of a sudden is not having FICA calculated on their check. This person is not even…

(newbie here, so not sure if this is the correct sub forum) We have created a 'kit' for a finished product we produce (a hand lotion as an example). The subcomponent parts of the kit are defined are a bottle, the lotion, and a label for the bottle.…

Hello everyone, Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses. Thank you

Does anyone know how to vouch an invoice where the associated standard costs includes freight from a third party? The idea would be avoid a large and inaccurate variance. Thanks