Auto adjust 401K max

When a person reachs a certain age, their maximum 401K deduction amount
per year is increased.  Is there a way to do this automatically based
on their birthdate.

GP 9.0 with payroll
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
6/21/2007 10:49:27 AM
6/21/2007 2:51:41 PM
greatplains 29623 articles. 6 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 14

How are other companies handling 401K requirements?  Is there an addon
to make this easier?
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
6/28/2007 12:02:23 PM

Japheth Nolt wrote:

> When a person reachs a certain age, their maximum 401K deduction
> amount per year is increased.  Is there a way to do this
> automatically based on their birthdate.
> GP 9.0 with payroll
6/28/2007 5:02:49 PM

Similar Artilces:

Selective auto text inputting
I am building a workbook to track vendor transactions. I have several vendors that are "regulars" and want to track their transactions separately, but still record them on the "master" sheet. My workbook has the master sheet and a worsheet for each of the major vendors. I put a column for each of the major vendors The idea being if the next transaction is from Vendor A, I can put an x in their column and the data from that transaction will be copied to Vendor A's separate worksheet in the next available line. If none of the "designator" colums have an x t...

There isa command to allow a formula to refer to a number in a cell to adjust the column that is used in the formula. BUT I CAN"T FIND IT! If I want the formula to be using cell A11, I want to have 11 in a cell and have it refer to whatever to A11. If I have 12 in the cell then I want it to refer to A12 instead. Sorry, I am not explaining the scenario very well. Help. MD -- mdalby ------------------------------------------------------------------------ mdalby's Profile: View this thread: http://www.excelfor...

HELP: Auto Populate Excel Userform fields from access query result
Hi All, How do I populate Access query results in excel userform text fields? For eg; I have a Query: "SELECT Student_ID, Course, Grade, Qtr_ID" & _ " FROM Student_Info WHERE Student_ID = " & _ Me.StudentId.Value Here Me.StudentId.Value is a text box in excel userform And here is what the query results look like: Student_ID Course Grade Quarter_ID JP1124 Math A SP01 SP1164 Phy B SP01 Here "Student_ID, Course, Grade, Quarter_ID" are the column headers ...

Auto Date Population
Good Afternoon, Everyone - I'm setting up an activity log using Excel. What I'm trying to do i set it up so that when a person enters his initials in one cell (cel A1, say), the time and date will automatically populate in the tw cells to the right(cells B1 and C1). While I'm able to make thi happen, I'm encountering an interesting problem: Whenever I make an change to the log (after dates/times have been populated), Exce automatically updates and makes ALL of the times/dates current (thus do not wind up with a chronological history - all the cells simple rea whatever tim...

Auto Forwarding
Hello: We are running Exchange Server 5.5 and over the last two weeks are rules have failed. They are server-based rules. One of these rules is the auto-forwarding of email. You select what people from the GAL or external email addresses you want forwarded out to another offsite email address. Does anyone have any ideas on this? Our bridgehead server administrators have checked the do not autoforward email but these are on separate servers from our information store and directory databases (naturally). Any help would be greatly appreciated. Thanks, Steve K. ...

help!! Re: out of office, and auto forward rule
At my company I have 2 email address in which I have to log on to the system with a different log -in and password to access that email. For instance, I have a "jobs" email address to which all applicants send their resumes to, and then I have my personal work email address. In order for me to see the "jobs" email, I have to log off my regular email, and login to the "jobs" application. I have tried using an auto forward rule to send all emails that come to the "jobs" address to go to my personal email but that sends the sender an auto offic...

Auto Complete
I have a user that has the auto complete flag set but when he restarts his machine he has to start all over. Nothing is retained from the day before. I've looked everywhere I know to look. Any ideas? Steve You have? Search this group then. This problem has been posted countless times. It usually means a corrupt Outlook profile. -- Russ Valentine [MVP-Outlook] "GSP@DCS" <> wrote in message news:2d836$45184a6c$d1a8fa82$5760@EDELTACOM.COM... >I have a user that has the auto complete flag set but when he restarts his >machine he has to start all ove...

Macro to auto save file using the format YYMM
Hi, I recorded a macro that automatically saves a file then change the formula in cell A1 to today's date, ie =today(), then save the file. I have a problem with the last there any way I can set the macro such that the file will be saved as "c:\YYMM ABC" where 'YYMM' is the format of the date (probably can be taken from cell A1) and 'ABC' is my own file name? Thanks! You can get the date right in the code: dim myFileName as string myfilename = "C:\" & format(date,"yymm") & " ABC.xls" activeworkbook.saveas fi...

What is the max of entries in an Excel Spreadsheet?
I need to know what is the max of entries that can be put in a single Excel Spreadsheet job? Thanks,; What do you mean by 'max of entries'? Launch Excel Help and do a search for "specifications and limits" where you should find everything you need. HTH |:>) "Ramon Soto" wrote: > I need to know what is the max of entries that can be put in a single Excel > Spreadsheet job? > > Thanks, > >; ...

Auto scroll to current date
My worksheet is formatted like a calendar for a full year, i.e. S M T W Th F S 1 2 3 4 5 6 7 .... Is there a way to auto scroll in Workbook_Open to the week of th current date? Thanks, Stev -- Message posted from Steve, The first day of 2004 was a Thursday. Shouldn't your calendar heading then start with Thursday? '----------------------------------- Sub FindTheRow() 'Jim Cone 07/13/04 Dim lngRow As Long Dim x As Date Dim y As Date Dim z As Double 'Find the serial number for Jan 01, 2004 x = DateSerial(2004, 1, 1) 'Find today'...

Is there such a thing as "auto-reply" within Outlook and how do I use it? See if the information on the following page helps: -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- please reply only to the newsgroup to preserve the message thread. *** In news:075e01c3b836$17cc0fe0$a001280a@phx.gbl, Krisel wrote: > Is there such a thing as "auto-reply" within Outlook and > how do I use it? ...

RMS should have auto log off if system is idle
it would be nice to have auto log off if the system is idle for a specific amout of time ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.

Custom Auto Filter
Previously posted in microsoft.public.excel.worksheetfunctions but I didn't get any response, so I'm trying another group in case I posted to the wrong one. On the other hand, if I've not been clear then please ask for clarification as I'm very keen to find the answer to this and I have no idea what to try now. Using Excel 2000. I have a column, formatted as text, with the following: Heading 02 01 05 04 03 (that's zero 1, zero 2 etc). Ultimately I want to filter the values to show those greater then xx and less than yy. However, for now I'm just trying to get th...

Auto Balance Message
Does anyone know how to re-enable the the dialog box that pops up after downloading transactions and you switch to an accout that warns rather the account is in or out of balance? I clicked the "do not show this again" option back accident and do not know how to turn it back off. I have tried uninstalling and reinstalling money and that doesnt work. ...

Max recommended users on shared workbooks
Hi all, I was wondering if someone knew if there is a maximum recommended number of users for shared workbooks, as we are experiencing some funnies with our excel spreadsheets at the moment and I am trying to eliminate any and all possibilities. Thanks in advance Paul Paul *my* answer to that question would be none, as I have never found excel to share very well at all, *Microsoft's* answer in help, under Excel Specifications is 256 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England "Paul Townsend" <PaulTownsend@di...

delete old email addresses from auto complete
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Email Client: pop When I type in an email address into the to line, Entourage automatically fills in, which is convenient--except when it's with an old outdated email address. <br><br>Even when I go to my address book and delete an old email address and replace it with a new one, the old one stays stuck in the autocomplete feature. <br><br>How do I get rid of old email addresses that are lodged in the auto complete memory? wrote: > How do I get rid of old email addres...

Carton size and cubic feet auto calculate..
I have an Excel sheet for our "Shipping Manifest". It shows how many pieces in a carton, carton size, cubic feet, etc. We have standard carton sizes we use which we've named. Carton A = 18 x 18 x 18 = 3.38 Cubic Feet Carton B = 18 x 18 x 14 = 2.63 Cubic Feet Carton C = 18 x 16 x 14 = 2.33 Cubic Feet ... etc, on down to Carton J. Is there a way to make it so we can type A, B, C, etc under "CTN SIZE" column it will automatically enter the cubic feet for us under the cubic feet column? Then at the bottom of the sheet we'll have a total which will total up the cu...

Insert "name" and "auto ID" into tables by using a form
I have a table: ID Name Nationality 101 Allen Taiwan 102 Sarah USA 103 Steve Japan ------------------------------------------------------------------------------ I'd like to create a form with the following objects -- 2 textboxes (putting name and Nationality) -- a button (when i press it, it will insert values in the 2 textboxes into my database) ------------------------------------------------------------------------------ Big thanks in advance , experts ! -- Allen Phailat Wongakanit Actually, you don't need any code at a...

401K Contibutions & actual balance
I see a lot of 401k questions posted but none that seem to help me, so I apologize in advance if this has already been answered. I have my paychecks transferring my 401k Contribution & company match to my 401k Investment account. My balance only shows those totals. Each paycheck some stock & shares of other funds are automatically purchased, publicly traded and not. My problem is I can't get electronic downloads of the transactions and their market value. How should I handle those investment transactions? If I just add them & update them my total will be doubled (Plus ...

Using a Cell Value to Adjust a Data Series for a Plot
Is it possible to redirect the data source series of a plot to a cell location so that it can be manipulated? For example, the current data series is ='Spending Data'!$A$32:$A$43. I would like to be able to adjust the series by entering a value in a cell. For example, using the existing range as a baseline, entering a "1" in the magic cell would change the series to ='Spending Data'!$A$33:$A$44. I have tried using INDIRECT, but either I don't understand how to correctly use it, or its use in a graph data series assignment, or both. A pointer to an online exam...

Auto-reply at the server level
I have a client that has one generic email address that is mailbox enabled. It will receive messages at all hours from all over the country and this is why I need my solution to run at the server level. Right now we have an outlook client running with several rules on it to manipulate the messages the way we want. This is what we are wanting to get away from. The following is what I need: 1. a message comes to and it either has an attachment or it doesn't. a. if it has an attachment then it sends the autoreply message A, says thank you, then forward...

Auto Bcc
Dear all, Any free add-on program or rules to set up auto bcc in outlook 2000. Thanks. ...

'private set' in auto-implemented Properties would not work
The below code can be compiled ant executed even though the Main static method uses the 'private set' Property, CustomerId. Is It Bug? I'm using VS2008, .Net Framework 3.5. Of course, If I moved the Main method into another file, then compilation error is shown like this, "The property of indexer "XTest.Program.CustomerId" cannot be used in this context because the set accessor is inaccessible. namespace XTest { public class Program { /// <summary> /// Customer Id /// </summary> public int CustomerId { get; private set; } /// &l...

Auto Accept Agent Install
Does installation of the Auto Accept Agent require a reboot? Exchange 2003 SP2 Active/Passive Cluster Thank you No, but I would check the documentation to make sure that it is supported in a cluster. -- Ben Winzenz Exchange MVP MessageOne Read my blog! (RSS Feed) "ArkAdmin" <> wrote in message > Does installation of the Auto Accept Agent require a reboot? > > Exchange 2003 SP2 > Active/Passive Cluster &...

Auto shapes in excel 2002, SP-2
Have an excel worksheet with an "Autoshape" inserted. I want to delete the inserted shape. Excel Help states that I should select the shape and press Delete. Sounds simple, but when I do nothing happens, the shape is still there. The worksheet is not protected. I have tried to insert an Autoshape in a new worksheet and then delete it. Same thing happens, nothing. Question: How do I get rid of an Autoshape in an Excel 2002, SP-2 worksheet?? Thanks Bill If multiple, press F5, click special, select objects and press delete. Otherwise just select the autoshape and press delete...