Adding inventory without purchase order
I run my daily "restocking report" to see what products I have to send to my
store. I package those products and need to add them to the stores
I don't want to create a purchase order first but rather would like to use
something like a "journal entry" to add the inventory but still have RMS
track this in the products history.
I played around with the inventory function but find it rather basic as it
does not allow inventories to be added to the stores inventory but will
replace that inventory.
I also tried to use the functionality of importing invent...Missing Measures in .cub file created in Excel
After using Excel's Offline OLAP features which create a
local cube file (.cub), many of the desired measures
which I included in the wizard setup are not displayed.
I'm looking for a reason for this.
The data populating this cube file is from a virtual
cube, so background calculations take place. I
considered that those measures requiring calculation
would not be included once seperated from the original
virtual cube... but many calculated measures WERE
included so I don't think that's the complete explination.
I've varied the measures included in the .cub file...Adding time values
Hi to all,
I'm trying to add time values together,
EG: 1:30 (90minutes) + 0:30 (30 minutes) to return a value of 2:00
Is it possible to do this in Excel?
Thanks in advance,
Yes, just put the two times in separate cells, and add them =A1+A2
(remove nothere from the email address if mailing direct)
"Johnty" <email@example.com> wrote in message
> Hi to all,
> I'm trying to add time values together,
> EG: 1:30 (90minutes) + 0:30 (30 minutes) to return a value of...How to create a report based on multiple queries
I am trying to create a report based on 30 queries . These 30 queries
are based on one table. When I use the Report wizard and select more
than one query I get the message " You have chosen fields from record
source which the wizard can't connect. You may have chosen fields from
a table and from a query based on that table. If so try choosing
fields from only tha table or only the query".
I do not know what to do.? Any guidance will help
On Wed, 29 Aug 2007 08:21:02 -0700, firstname.lastname@example.org wrote:
>I am trying to create a rep...Windows Mail can't see incoming message
I thought I posted about this about a week ago, but I can't see my message
I am on Vista Home Premium with Windows Mail. There was a particular
incoming message, which I could see in my ISP's webmail and I could see on
my local machine in MailWasher, but which was completely ignored by Windows
Mail - it just didn't see it. That's still happening, but now there are
three incoming messages behaving in this way. All are from the same site
(user@site) but not all from the same user, and I have no problem with still
other users at that site.
What shou...HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
I am trying to developt a formula that restrict symbol characters to be
entred as data, help me!
This will limit data entry to alphanumeric characters:
Are there any other characters which you may wish to enter?
"Rodrjua" <Rodrjua@discussions.microsoft.com> wrote in message
news:61E5CBBC-B00E-4BCF-B46D-8A9B5D247836@micr...How do I create an area and line combination chart?
I want tocreate a combination chart, using the chart types area and line, it
is not listed as a custom type in Excel - is it possible?
Ignore the built-in combinations and create your own.
Start with creating a Line chart with your data. Then select the line
series that you want as an area chart. Right click and pick Chart Type
to select the required Area chart type.
> I want tocreate a combination chart, using the chart types area and line, it
> is not listed as a custom type in Excel - is it possible?
Andy Pope, Microsoft MVP - Excel
http://ww...addtional suffix being added to e-mail address
We hook up a new worker (he has Outlook 2003) onto Exchange 2003. He cannot send e-mails due to the server adding an additional suffix to his e-mail address. He is the only one who has this problem. Is there a way to correct this situation.
Hi - so he's connecting directly to your Exchange server via Outlook, and he
has a properly configured mailbox with the appropriate default SMTP address?
What is the additional suffix that's being added?
> We hook up a new worker (he has Outlook 2003) onto Exchange 2003. He
> cannot send e-mails due to the server adding an a...New users loose SMTP address
2 domain servers
create a user on either domain controller, add the smtp address we want
(from a large list), come back a few minutes later and the address will
change to the system default.
Notes; we dont run the smtp recipient policies as such - just a general one
with all our smtp address suffixes, this problem only occurs on every
four/five accounts created.
At first we thought it was the individual support person, then blamed his
PC, his MMC connection, now Tech servoces have found it occurrs to anyone
creating large numbers of users. Thought it could be...How can I change background color of DateTimePicker?
I know that subj is possible because of Borland C++ Builder allow to change
background color of DateTimePicker just assigning a color to Color property
of TDateTimePicker component. When I try to make this subj using MFC I've
got nothing. Can anybody help me?
My code :
m_date.Create(WS_CHILD | WS_VISIBLE | DTS_SHORTDATEFORMAT,
CRect(36, 0, 116, topHeight), this, 1006);
With best regards, Sergiy Yakovyn.
"Sergiy ...why i can't see Send button in my outlook for applying a job in cr
why i can't see Send button in my outlook for applying a job in craiglist
"ruchie" <email@example.com> wrote in message
> why i can't see Send button in my outlook for applying a job in craiglist
Did you set up an email account in Outlook?
...Can't shut down outlook
When I shut down my computer after having used my outlook
program I have been getting an "end program" notice for
outlook.exe giving me a few seconds to click "end now"
before I can shut down. I have closed outlook and all
other programs before I shut down. I ran outlook "detect
and repair" but to no avail. Windows seems to think that
outlook is still running when I shut down. What should I
...Adding new account to same bank
In Money, I have an checking account set up for a particular bank. I have
since opened a new credit card account with the same bank. When I try add
this account via. Account List- Add a New account - Choose account type
(select credit card) - (Choose the bank) - I get the message "Your account
list already contains accounts with (particular banks name). After Money
updates your accounts, review the account list to see if it shows duplicate
copies of any accounts... click "OK". If I click OK Money changes the exiting
accounts type to a credit card account instead of adding..."create mscrm.sql" error on 3rd (re-)install
I have installed CRM 1.2 on SBS2K3 twice as "advetureworks cycle" and "msdn
subscriber" with only 90% success because of conflicts on the web site. I
have removed the conflicts but now CRM installer errors trying to create the
new database as (default) local service.
My login has SQLServer db_creator permissions and I can create a DB, so I'm
totally confused. Can I workaround this somehow ? What login needs to be
given db_creator rights so Install can run te SQL scripts ?
have you deleate the complete the old date from AWC? Have you delete the
...Cannot copy & paste to a mailing label template
I downloaded a Christmas label template from Microsoft Office Word. After
deleting "Name, Address, etc." which was on each label on the page, I then
typed our address on one and tried to copy & paste so that we could have a
whole page of return address labels. I just couldn't get it to work. Any
Rather than starting with a full sheet of blank labels, why not use the
Can you explain "just couldn't get it to work"?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummie...User access via remote desktop
I have a situation where if I set a new user up from a local client,
they only can access GP via their local client - they get a login
error if trying to login via remote desktop.
Likewise, if I log into the server remotely and set up a new user,
they can login to GP remotely but not from their local client.
Any ideas why this would occur?
Frank Hamelly, MCP
NOVA Solutions LLC
Do you have any profiles that would be affecting where a user is using files?
I've seen this issue where one user's profile was different than other
Charles Allen, MVP
...Cannot get email users email to go to isp email. It goes to exchange server instead.
We are using SBS2003 with EXCH2003. We have branch offices.
If I put the branch office in SBS2003 as a user and send an email to
the user (i.e. firstname.lastname@example.org) it ends up on the server and never gets
sent to the branch office user.
I'm using the pop3 connector to connect to our mail provider to send
and receive mail.
I was wondering if there's a way to bypass the server and have the email go
directly to the user at our providers server.
The reason why I put the branch office user on the server so that we can
have the user in our Global Access List when do a mass email.
...How do I create Folders/Sub folders from User Form control button
I have a User Form that I would like to take one of the spare control buttons
and have it set up my job folder on the hard drive.
I am not sure how to code it to achive the following results:
These are my text box ID's
User Selects drive: \ CES_No_1 \ CLLI_Code_1\ TEO_No_1
Sub Folders inside Main Folder
Elec Job Folder
Misc Job Documents
If you can dig up a copy of the VBS doc...How can I just count the records where the check boxes are "No"
I have a audit form and when something is not completed then it is not
checked. I need to have a total at the end of each item to count how many
records are out of compliance. Please HELP need by this afternoon
Julie Gilliam <Julie Gilliam@discussions.microsoft.com>
>I have a audit form and when something is not completed then it is not
>checked. I need to have a total at the end of each item to count how many
>records are out of compliance.
Use a text box with an expression like any of:
=Count(IIf([check field], Null, 0))
=Sum(IIf([check field...How can you tell "To" address used for spam?
I have a few exchange email addresses on my account. Spam level is to the
point that I want to delete the affected account. How can I tell which
address is being used?
You mean you have multiple addresses for the same mailbox?
The easiest way to pin-point the address would be the create multiple
mailboxes for these addresses. Emails will get sorted for you automatically.
IMF Tune - Unleash the Full Intelligent Message Filter Power
"Nick" <email@example.com> wrote in message...Re: How can I search for a ? in Publisher?
I just sent my suggestion to the shredder. <G>
Don - Vancouver, USA
"May your shadow be found in happy places." - Native North American
"Don Schmidt" <Don Engineer@PNB.Retired_1987> wrote in message news:...
>I see you problem; don't know if your search can be done in Publisher but
>here's a way of finding the "?s" in your file.
> Save the file as a PDF and do the search in your PDF viewer program. This
> works for me using PDF-XChange to create the file and PDF-XChange Viewer
> to do the searching....Can't open XP file in Windows
We have XP machines and Windows machines. A Publisher file
was created in XP and I am unable to open it in Windows.
The error message is "You cannot open a file from a
different version". I would appreciate any assistance on
Hi gwen (firstname.lastname@example.org),
in the Microsoft� newsgroups
|| We have XP machines and Windows machines. A Publisher file
|| was created in XP and I am unable to open it in Windows.
|| The error message is "You cannot open a file from a
|| different version". I would appreciate any assistance on
|| this issu...who can I protect with password the Interchange entry
I'm trying to protect the Interchange entry with a password, in GP8 I used
the general password but, I did update to GP9 and this protection was
eliminated and all the user can change or entry a new interchange rate.
Who can protect this?.
This was removed in GP 9.0 because it was accidently added to the window in
8.0 (it wasn't previously).
You can use regular GP security to keep everyone you want out of the window.
The only other solutions I can think of are:
1. Dexterity customization - pretty easy
2. VBA coding but not as secure but would work.
3. I thi...Adding times that exceed 24 hours?
I know this has been discussed quite a bit, but I can't seem to get my
head around the solution to this problem. I have a table with times
stored in 24 hour format and need to add those times on an access
report. Currently, I'm using sum and the column name; however, when
the time rolls over past 24 hours, a day is added (so 1:20:23:20 would
be 44 hours, 23 minutes, 20 seconds). Instead of 1:20:23:20, I need
44:23:20 to show on the report itself.
I understand Access isn't setup to be able to natively handle such a
task. I'm also not finding the difference between two times - I...Sometimes can see all text in a cell, sometimes not.
On Sheet1, I can see all text in cells that have lots of text in them, but
have cells to the right that are empty.
On Sheet 2, I pasted the following formula into cell A1, and copied this
of the cells on Sheet2:
Now I can't see all of the text in a cell, even if the cell to the right of
it is empty.
Is there anything that can be done? I am copying these cells and pasting
them into Word as a picture.
Its because if you type text into a cell it will spill over into empty cells
so it can be read. If you then enter in a...