I require answers to the follwing:
1. How is a purchase order generated in HQ
2. How are system settings set in HQ
3. How are users and their security levels set in HQ
4. Is there a report for daily store sales from HQ
5. What is the difference between getting inventory through a purchase
order and through a transfer in.
6. What is the basis for restock level and reorder level.
7. What does store cost mean and how can it be differetn between stores
8. How are the bar codes and
hi Faiz, My GOD you have ask all question I think the right Microsoft Partner
help you in this b...formulas for round numbers up to next dolllar
I need to create a worksheet for work. I need to take original cost of
merchandise, divide by 3, then multiply that amount by 8. The final amount
needs to be taken to the next whole number. Here is a example of what I need
$245 / 3 = $81.67 X 8 = $653.33
the final amount needs to be $654.00
"dewberryz" <email@example.com> wrote in message
| I need to create a worksheet for work. I need to take original cost of...Mail Sending Question
Hi. Both of my computers exhibit this feature, and I don't understand why.
When I send one simple email message, the status bar shows "Sending 2 of 2."
I'm really sending only 1.
Any thoughts on why this behavior?
The second computer is new, with a new installation of the software.
Thanks for any feedback or insight.
it's a bug in outlook 2007. if you have multiple accounts it adds a number
to the number of messages being sent.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlo...CRM client for Outlook installation question
Hi I'm trying to install CRM client for Outlook. through
the process it is asking me to enter the URL for the
Microsoft CRM server. Would this server be local on m
computer or in the mainframe. Any idea where I would find
The CRM Server is where the CRM application is installed;
it's the path you'd use to open the browser (like
http://crmservername/). You must be able to access the
CRM Server from the computer where your are installing
Sales for Outlook in order to successfully install the
Sales for Outlook client.
Hope this helps.
Linda Dienbe...Formula in 07
Need a formula.
Column 1 (type) Column 2 (wk)
I would like the formula to come back for every week and tell me the number
of types that are in that week. Another words in this case there are qty 2
types in wk 77. In week 81 there are 0. In wk 78 there is 1 and week 80
there is 2.
Can anybody help?
Assume that you are having the Values i...Workflow question #3
It appears that when we upgraded from CRM 3 to 4, a workflow stopped working.
This workflow ran when a case was updated to reflect that it was resolved to
populate a resolution date field. This worked fine in CRM 3, but the
workflow now says that it cannot update the case because it is read-only,
presumably as a function of marking the case resolved.
So the question is: is there something I can do to make this workflow resume
of the dropdown that marks cases resolved? I would prefer to use a workflow,
as it ...Simple Formula #3
I have a spreadsheet that I am using for check in and check outs. I was
wondering if i could write a formua or a simple macro that when a cell is
blank it does nothing, but as soon as the designated cell has any value it
does a strike thru a number of cells....ie. a1, b1, c1 all have values. d1 is
blank. d1 gets any value. after d1 has a value the formula would now
strikethru all a1, b1, c1, d1.
what woudl a formula or macro look like for something like that. i was
hoping it would all be automated instead of having to run a macro each time
highlight columns A:D and select Format->Co...Lock or Unlock cell references in a formula for auto fill purposes
Are there any tricks (control or alt + something for example) to locking or
unlocking (probably not using the correct terms) of cell references in a
formula in order to set it up for the autofill scenario I want to do? For
example if I have the following formula:
How can I easily change it to =$a$1+$b$1
I may just be crazy, but if you have any quicker command button suggestions
to change these scenarios easier than having to type them every time that
would be great. Thank you.
Select the relevant cell references in the formula bar and press ...Deleted OExpress
Deleted Outlk Express because I also recd Outlook 2002 as
part of pkg Upgrade. OE remains in Registry in (at least)
HKEY_LOCAL_MACHINE/Software/Microsoft. Can I delete or is
there any "Sharing" between OE and Outlook?
There is sharing between the two, so you may want to reinstall Outlook
Express to make sure everything is in place. See
for more information.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to prese...YAPTQ
Guess I don't understand pivots like I shoud! (Yes, books are on the
Anyway, data looks like this:
SubmittedDate 0-15 16-30 31-45 >45 PxAmount
01/01/2006 1 0 0 0 $10.00
01/05/2006 0 1 0 0 $20.00
01/06/2006 0 1 0 0 $40.00
02/05/2006 0 0 1 0 $50.00
Is there a way to get the pivot tableto look like this
0-15 days 16-30 days 31-45 days etc
Jan 1 2
Feb 0 0 1
PxTot $10 $60 $50...If formula with dates
I need a formula that can look at column "A" and calculate the number of
days from today --- could be either before today or in the future and if it
is equaled to or less than 90 return "Y" otherwise "N"....
I keep getting "VALUE!" errors.
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
"murka...Mutipul Question "NULL and Post"
I am creating a variable start up form where I store the Primary
Company information to tbl_Primary_Company. This form will hold
several test boxes and one cbo to select zipcode and add city and
state. Very simple. What I want to do with this is to have the company
name, address, city, state, and zip to be added to tbl_Company, this
could be done with a cmd button or just simply by being added but I am
not sure on how to do this. My next question is I would also like this
form to open only if the company name is null and if not, then go to
my actual startup frm Main_Menu.I am not...How can I insert a row and have the existing formulas apply?
I have a table which has a column that uses a formula. When I insert a new
row in the middle of the table, Excel inserts a blank cell into the column
with formulas, rather than keeping the formula that applies to the adjacent
How do I insert a row and keep the column with a formula so it applies to
that new row?
Charity Worker in Africa wrote:
> I have a table which has a column that uses a formula. When I insert a new
> row in the middle of the table, Excel inserts a blank cell into the column
> with formulas, rather than keeping the formula that applies to the adjace...Serveral Questions
Windows 2003 sp1
Exchange 2003 sp1
Clients - Outlook 2003 (all updates and patches installed)
Exchange internet email address - firstname.lastname@example.org (Works awsome!!)
ISP Email address - email@example.com (Email sent to firstname.lastname@example.org is
forwarded to email@example.com at the ISP level - This may be the issue for
question 1, Im not sure)
1) Reply's and Forwards. firstname.lastname@example.org is set as the default email account
in Outlook 2003. When a user clicks "New Mail" the default outgoing is
correct. However when a user reply's or forwards an email the default changes
1. Using 1.3 on XPP on two networked PC's. Database connects fine. After
starting SO POS on front computer w/dongle, I use start up SO Manager and I
receive "warning 941, the copyright..." My firewalls are set (I believe)
correctly. What do I need to do to allow back office to recognize dongle on
the front PC.
2. While I am able to open SO POS just fine, when I sign in with
name/password I receive "ACCESS DENIED." However, I click "okay," and it
seems that everything works okay. I checked my cashier's security settings,
all are in place....w...Can anyone answer some questions on partitioning a hard drive?
im using windows vista.
i just recently bought a 500gb western digital external hard drive. i would like to know, how can i install an operating system on the external hard drive and keep the one that's currently on my pc, i would like to use the external hard drive to keep different documents, games, applications and files on, and to randomly boot of. (so its like their are two computers.)
also will booting of another external hard drive have any affect on my computer or current files or hard drive. one last thing, could i use the external hard drive to store flies on l...Question concerning VBA and Excel
Is there a way to "disable" a portion of code (the code is not called from
a control or event, but from another section of code) prgramaticly (sp?)?
For example, suppose I have some code that forces a save when I close the
spreadsheet, saving a copy to a backup location and to the origianl
location. Is there a way to "turn off the code" in the copy saved to the
backup location USING CODE only?
Any help is appreciated.
Posted Via Uncensored-News.Com - Accounts Starting At $6.95 -...Can I keep and hide a formula if there is no value in cell?
I have a form that has formulas in it- my question is: Can I hide and keep
the formulas in the cells without there actually being a value in it? thanks
If your cell has a formula in it, then it has a value in it.
But you could use a value that makes it look empty--just have it return an empty
> I have a form that has formulas in it- my question is: Can I hide and keep
> the formulas in the cells without there actually being a value in it? thanks
> so much
When I do this... will ...File question
whats the maximum bytes( or MB) we can store in a single file(*.txt)?
thru VC++ application. are there any limits?
thanks for information!
> whats the maximum bytes( or MB) we can store in a single file(*.txt)?
> thru VC++ application. are there any limits?
> thanks for information!
Depends on the OS.
XP allows files as big as the volume size, although you'll start
experiencing oddities as you get under the threshold for free space.
what about w...CListView Question about scrolling
I have a CListView. My question is if I set the Item state so that a row is
highlighted that is out of sight because it is either on the next screen or
the previous screen, how do I scroll to that row so the row is visible as
the first row in the window? I hope that I explained that well enough.
GetListCtrl().EnsureVisible( nItem, bPartialOK );
I have a formula to calculate amount of days from a hire date to current
date, but I would like to see the days to reflect amount of years and months
any assistance would be appreciated thanks!
=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months"
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Mharper" <Mharper@discussions.microsoft.com> wrote in message
>I have a formula to calculate amou...Licence Question...Need to Install Office X for Mac on new Mac Pro...
Hi Im trying to install a version of OfficeX on a new Mac Pro at home.
This version of OfficeX is already installed on my laptop and my work
computer. Do I need to purchase an additional licence to install it on
this new Mac Pro computer for my home? If so, is it expensive? Is it
like buying a whole new software package or is it just an additional
user licence fee? Any help anyone can offer would be most appreciated.
I'm no expert in these matters, and I have yet to read the EULA that came
with Office, but as far as I know, you will need to get a new license. A new
licen...insert row in list and formula does not update
When I insert a new row inside my list, the formulas below do not
automatically update. They do not point to the new row numbers. It is as if
the formula thinks the cell reference is absolute. It is not.
any idea? is this a setting that I an turn off?
This is the way Excel was designed
In A10 I enter =F1 and copy this down to A15
Let column F has number 1,2,3,4....
So I see in A10:A15: the same series 1,2,3,4.....
Now I insert a row between A10 and A11
Now I see 1, (blank), 2,3,4....
If in A10 I use =INDIRECT("F"&ROW()-9) and copy. I still see 1,2,3,4
But now when...outlook hangs #18
when trying to load outlook (2000), it hangs and will not start--it jus
appears minimized in the task bar, and I cannot maximize or restore.
roddwPosted from - http://www.officehelp.i
Have you rebooted the computer?
Try creating a new profile in Control Panel->Mail.
> when trying to load outlook (2000), it hangs and will not start--it just
> appears minimized in the task bar, and I cannot maximize or restore.
> any ideas?
> roddwPosted from - http://www.o...Simple? Reference Question
Can I reference a value in a spreadsheet that is not open?
I have 2 spreadsheets, 1 for the totals- and 1 for the values. I want the
total spreadsheet to update when the value spreadsheet is updated. Do I need
a macro to open the spreadsheet, grab the values and pull them into the total
spreadsheet, and close the values?
No need for a macro- just open both files at once. Let's call them
Source.xls and Target.xls: Target is the file your working on, and
Source is the one that holds the data to be referenced. With both
files open, start the formula in Target.xls, an...