Do not allow two users in the same A/R cash receipt batch
1) Go to Transactions/Sales/Cash Receipts. Enter a cash receipt for a
customer and save it to a batch.
2) Exit the batch and log back into it as though you are going to edit the
3) Go into the same cash receipt batch as a second user. Notice that you
are not stopped from doing this even though another user is currently editing
EXPECTED RESULTS: The second user would not be allowed into the cash
receipt batch while the first user is editing the batch.
ACTUAL RESULTS: The second user can enter the same cash receipt batch as
the first user. This opens up the...Search end/beginning of cell
I know I can do this with functions but is there anyway to do search/replace
indicating this? In word I just do
but not sure how/if I can do this in Excel
For searching, you can look at the whole cell (match entire cell contents)
And look for something like:
This will find the cells that start with MSNY
will find the cells that end with MSNY
The replace is gonna be a problem for you (I bet).
What do you want to start with and what do you want to end with? (save your
work before you start. I'm guessing that it won't do what ...Month-End Closing in Great Plains 8.0
Might I get some information about Month-End Closing?
The detailed steps I should take
The precautions and cautions I shoud aware of.
There are so many factors that goes into this depending on which modules
you have, but generally speaking, Great Plains doesn't have a "hard" month-end
as with many other ERP solutions. Perhaps contact your VAR to help you determine
what procedures you need to perform as part of your month-end.
A> Might I get some information about Month-End Closing?
A> Th...payroll end dates
End dates for contract amounts, so that the payroll system stops paying
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.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=1dd295c0-e1ad-443f-bab5-d596c6a7990f&dg=microsof...Year end closing in payroll
I closed the year in payroll. Now Im trying to payroll for new year. I try
to calculate checks and I get the following message.
Checks cannot be calculated while the year end closing is in process.
You need to change your user date to 2006
> MGPS 8.0
> I closed the year in payroll. Now Im trying to payroll for new year. I try
> to calculate checks and I get the following message.
> Checks cannot be calculated while the year end closing is in process.
...Gathering open-ended question text into one sheet
I have an Excel file with data from 60 or so respondents to a questionaire.
I have all my raw data on one worksheet. On another worksheet I have totals
for the various questions broken out in various ways. I would like to create
another worksheet that lists the answers to an open-ended question at the end
of the questionaire. Less than half of the people responding wrote comments
so I don't want to include blanks. I'd like to have a consolidated list of
the comments in a tidy, separate sheet.
As yet, I've been unable to figure out how to do this. Any help would be
app...How do i set the calendar to begin & end in consecutive months
i was trying to create a leave plan using publisher calendar. However i could
not set the dates to reflect the beginning and end of my leave
When do you want the calendar to start and when do you want it to end? There are
methods, if you can be more specific it would be helpful.
Mary Sauer MSFT MVP
"tew" <email@example.com> wrote in message
>i was trying to create a leave plan using publisher calendar. However i cou...Copy Sheet and move to end
i have posted something similar earlier today but this is alittle different.
I have a sheet called Template in a workbook. i need to be able to issue a
macro that will copy it and move it to the far right after all other sheets.
Then rename it 1 number above the last sheet. i.e. if the last sheet was 2567
then my new copied shett will be 2568.
ActiveSheet.Name = Sheets.Count
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"Nigel" <Nigel@discussions.microsoft.com> wrote in ...Year End Information
Usually customersource is full of year end information, but I can't seem to
find any checklists or info this year. Can someone help point me in the
Presentations Direct - http://www.presentationsdirect.com
> Binding Machines
> Paper Shredders
Custome...End/Beginning of Cell Search/Replace?
I find myself having to export data to word so I can do simple find/replace
which I'd do in Word with ^p such as
(removes leading spaces)
(removes trailing s i.e. plurals)
Is there anyway to do this with Excel S/R that is indicate beginning/end of
To search and replace with excel press
CTRL + H
if this helps please click yes thanks
> I find myself having to export data to word so I can do simple find/replace
> which I'd do in Word with ^p such as
check out this site for all kinds of ebooks, I loved it.
On Nov 18, 10:18 pm, weodd...@gmail.com wrote:
> check out this site for all kinds ofebooks, I loved it.http://i-ebooks.blogspot.com
> -Joe Nash
...Antivirus Free Download #2
Antivirus recognized a free download to your computer,
who knows Microsoft recommends at:
Content Site Links:
http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/antivirus-functions.h...A true flicker free and transparent CStatic
Could someone tell me where I can find a very good transparent and
flickering free CStatic control.
I searched on Codeproject and I found CLabel but it is not flicker free when
Depends on what you mean by flicker free! There really isn't such a thing as
a flicker free static control
Since the drawing of the static control is in seperate stage than the
background of the dialog then there will always be flicker, hence there is
no double buffering going on.
Take a look at this, CTransparentStatic2 will minimize the flicker.
http://www.codeproject.com/useritems/TransparentSt...Searching for free online excel course
Can anyone recommend a good free online excel course? Please give internet
address of the course.
There many,many free online training resources for Excel.
Just Google: university online "excel course"
For instance, check out Loughborough University at
"Jenny Ensing" wrote:
> Can anyone recommend a good free online excel course? Please give internet
> address of the course.
David McRitchie has a list of tutoria...windows vista launch- free vista wallpaprers at www.i-search.co.in
Microsoft is ready to release, on January 30, the retail version of
its operating system called Windows Vista. It has taken more than five
years, about $6 billion and over 5,000 developers around the world.
Vista is a major overhaul of Windows operating system (OS) and offers
new elements like an aero glass (hardware based graphical user
interface), more search options, new sound and networking technologies
and enhanced security. To run Vista buyers will need a PC with at
least 800 Mhz chip speed, at least 20 GB free disc space, 512 mb for
the system and a reasonably powerful graphics c...Exchange cluster back-end storage limits?
I have 2 node A/P cluster on Exchange 2003 SP2 running on Windows 2003 R2 SP1.
Is there any Mailstore size limitations while installing it on Exchnage
I plan to have my each mailstore upto 50GB.
I heard that there was some 25GB limit on Exchange 2000.
If you are running Exchange Standard there is a hardcoded exchange database
limit of 16GB. If you are using Enterprise there is no such limit so you
will be able to scale to 50GB fine.
You only have to consider the number of Exchange Store databases and
possibly sizes when you have an Active/Active ...Setting up a front end server.
I have a question. Our environment currently have one exchange server and it
sits on the DMZ zone. We currently have RPC Over HTTP and Active Sync
working. However, I'm trying to setup a front end server place it in the DMZ
and move existing exchange to the inside of the firewall.
When installing windows server and exchange server what is the recommended
Do the server need join the the existing domain or it has to be a standalone
When installing exchange server does it need to join the existing site or
how do you install exchange server?
is the...Restrict Free/Busy View
I have a couple of executives at my company that don't want people knowing
their availability. They want the ability of others to see their "free/busy"
information blocked. I can't seem to find any documentation or instructions
on how to do this. Does anyone have any ideas? I would appreciate any
assistance on this. Thanks in advance.
On Wed, 10 Aug 2005 12:39:38 -1000, Tech LA <firstname.lastname@example.org> wrote:
> I have a couple of executives at my company that don't want people
> their availability. They want the ability of others to see...cash flow option "use amounts from budget" greyed out
I used to allow the cash flow feature in Money Deluxe 2007 to forecast using
trended amounts but have since then begun using the budget. When updating
the budget, nothing seemed to reflect in the cash flow. It was when I
started looking in the cash flow settings that i noticed the option I needed
was greyed out -
For cash flow forecasting, use: Ammounts from my current Advanced Budget
I use the advanced budget and have no clue why this is greyed out.
...Calculation of end date
I am wondering how can I get the end date of project if i have the
starting date, the workdays that it will need, the fact that a week
have 5 working day and a list of holidays?
the problem is that in B:B i have many projects each starting in a
different date, some in 2008 some in 2009, i imported to C:C the
working days now in D:D and i have the hollydays in format "dd-mm"
independent of the year, so now what should i do to get the end day?
including the weekends and if any date from the hollydays, happen to
be after the starting date of the project.
Start date...cross-site moves in native mode (free/busy frustrations)
we're in the process of consolidating 7 AG's down to 3 and will be
doing 15,000 cross-site moves in our native E2K/E2K3 exchange org.
Right now we have a home grown duct tape solution for modifying the
legacyExchangeDN/X500 of user mailboxes being moved (a combo of
powershell scripts, text file editing, and ldifde), but it's a mess
and I want to ditch it form something more reliable, faster, and
easier to use.
How do other large exchange orgs handle modifying legacyExchangeDN/
X500 when doing cross-AG moves? I've done a lot of research on this
today and I only find talk about...eBay Appointment Macro
I have put together a macro that allows you to create an Outlook Appointment
(and by extension, to your PDA) for Ebay items that are due to end bidding.
The macro even adjusts for local time zones. The way it works is that you
simply view the item on ebay, select "email a friend" and enter your own
email address. When outlook receives it an appropriate appointment is
I did this for myself but it occurs to me that there may be others
interested in using it. If so, feel free to contact me. I've tested this
only with outlook 2003 but would be interested to se...Free/Busy for OWA
If user creates an appointment from Outlook Web Access the published
free/busy information is reduced to 3 months even though in the full client
12 months of free/busy is published. I need to be able to configure Outlook
Web Access to publish 12 months of data as that is our primary client (800
users vs 100 full). Any thoughts??
On Fri, 7 Jan 2005 09:23:02 -0800, "Wayne"
>If user creates an appointment from Outlook Web Access the published
>free/busy information is reduced to 3 months eve...How to handle a tax free exchange
I have a socially responsible mutual fund (Parnassus Equity) that has
allowed me to exchange my regular shares to those in an institutional fund
in a transaction with no tax consequences. The share ratio is
1.0003883956:1.0000000. The symbol is different for the two funds. (Note
that I still have the old fund in my IRA account, as I don't have enough
shares to qualify for the institutional fund in that account). How do I
handle this transaction to allow for keeping my original basis (a Sell/buy
exchange would change the basis.)
As a Merger?
(my best guess)
art...unable to start MS Schedule+ Free/Busy Connector service
This is what I get.
The MS Schedule+ Free/Busy Connector service terminated with the following
The service did not start due to a logon failure.
All other services run fine under that domain account, I even tried local
system account and it fails.
Do you still have MS Mail? If not, run Exchange Setup and remove the MS
Mail Connector. You do not need this service. You could remove the other
connectors you don't need as well.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"