Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
We use Sage 100 Contractor and bill Cost plus (T&M). We have always charged a "profit" percentage on Cost Type 2 - Labor, which is easily done in 3-10-1.
But now, we want to remove the "profit" percentage on some of our labor, but not all, based on…
I am trying to run an MRP generation to generate a report. I am doing so in the legacy MRP for Sage 100 ERP version 2018. This will be the first time that the generation would be run for this particular company. The files for this company are not gigantic…
We ship out products and then invoice at a later time. This may be days or weeks. When doing cycle counts we manually add back in the shpped inventory for our on hand calculations. Is there an easier less cumbersome method to update inventory with our…
I'm struggling with how Sage 100 calculates the suggested reorder quantity when using the ECONOMIC reorder method on an item. It determines reorder is necessary based on quantity available but then only recommends ordering the amount in the Economic Qty…
Is there a way for the Available field to automatically take into account the "Req for W/T" quantity? It seems completely illogical that the On Hand Quantity is the same as the Available when parts are needed for an open Work Ticket.
I mean it takes…
We have an item we need to bring in that is a large value item. The problem with this is that we are bringing it in through RMA. We need it in the system but cant have this value show in our books. Is there any way to have its value show Zero in our books…
I am trying to file my 2023 4th quarter 941. Sage/Aatrix is calculating Fica based on the 2024 limits - not 2023. So I'm getting audit errors stating I haven't withheld enough fica. I change the payroll calculations back to the 2023 limits and ran the…
It does not seem like the Social Security wage limit has been updated in the latest payroll tax update . Several consultants in 90 Minds have noted this, and we aren't sure if another update is coming or if it is a bug.
Team,
In our Sage ERP 2020 advanced, some completed sales order header InvoicedAmt not equal to the AR invoice total against this sales order, does it due data corrupt? What's the InvoicedAmt formula here.
In January, we are switching to a Safe Harbor Match Plan for our 401K. I'm not sure how to set up the calculations. Also, I'm not sure how to set up the calculation for the owner's portion of the match for his own contribution. Does anyone have instructions…
The DOL requires a recalculation to determine the regular rate of pay to be used for OT calculation. Sage does not calculate as the DOL requires. How are you addressing this to pay as required without a significant amount of manual entry? Any OT, premium…
I have recently taken over as Controller for a small General Contracting firm.
The previous Controller was using Paychex as a payroll processor but It's just been a nightmare so I have decided to bring payroll back in-house. I'm finding some issues…
The main tab under Item Maintenance is showing "on bk ord"=0 however on the orders tabs I am showing a total of 2 "on bo". I just rebuilt the sort files Sunday night, and users are saying this just started happening recently, I cant think of anything…
Customer bases all of their reporting on the Unbilled Amount. Since the upgrade, it looks like amounts are being subtracted from the Unbilled even when no invoices have been created for the customer - instead, it looks like every time a payment is made…
Hello.. when printing a PO if the item has an Avg Cost it will print it even thought the Standard cost should be used. We have noticed items that have Avg Cost will get used instead of Standard cost. We don't use Avg cost anyways only Standard.
Any…
Hi,
i’m trying to retrieve date difference from issued date to current date in Sage but somehow I must have my formula wrong, need some help.
I’m hoping someone can let me know what I’m doing wrong.
PrmChg.chgdte is the date field from Prime Change…
Why do I have a difference in the extension value of the cost when I invoice the customer? The item entered to the inventory at 3.333 got out the same day at 3.333 but the extension is showing a difference of 0.42 and I have to adjust this differences…
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…
Has anyone explored the possibility of implementing a bottle deposit system and integrating it with item codes in Sage 100 to streamline calculation and invoicing processes?
All items have a valuation method of average cost.
When enter purchase orders, we want to use last cost.
We do not want to enter vendor price levels.
Is there a way to use last cost in Purchase Order Entry, maybe using a script?
I am showing 10 unIts of item "BG7300-NAVY-M" in inventory, they are not though. After some research I found the PO that the 10 were received on and the SO that those 10 should have been allocated to. The SO was invoiced and those 10 were shipped, inventory…
We would like to have reporting on customer's sales, that excludes Tax & Freight paid. I read this was done by going into AR - Setup - Accounts Receivable Options, 6-History - uncheck "Include Sales Tax and Freight". But how do we go about recalculating…
