Invoicing a partial amount on a linked sales order
We have a sales order that is linked to a PO. 1050 items were
ordered, 979 were already received and the link automatically
allocated and fulfilled them. 71 items are remaining to be received.
The customer wants 288 of that 979 shipped now.
If we remove the link, then we have to put the 288 in quantity to
invoice and quantity fulfilled, and the remainder has to get put in
the quantity to back order field.
This makes us nervous because won't that show up as a quantity to
order in the PO Generator?
How can we invoice a partial receipt of items on a linked sales order
better than this?
...Unusual occurance of this error
We're getting this error, but it is not due to the usual
reasons that I can find in the KB, or the newsgroups. I've
narrowed it down to imported items from the old Exchange
Server. It's mainly calendar appointments, but there are
too many of them that re-creating them is not an easy
task. If you create a new calendar item and invite
attendees, there are no problems. But editing old items
and resending generates this error:
Subject: Undeliverable: Canceled: E-Menu
Your message did not reach some or all of the intended
Subject: Canceled: E-Menu
Se...sending (large) files through a socket
i want to transfer (copy) a rather large file from one pc to another.
the codesamples in the online help of visual studio and others i found
all only send primitive datatypes or objects. so far, i am using this,
but i have no idea what to send from my archive. i am also not sure what
to set the buffer size (third parameter in creating the CArchive) to.
mySocket.Create(0, SOCK_STREAM, NULL);
int retval = mySocket.Connect("192.168.0.7", 6666);
if (!retval) MessageBox("Connect ging schief", "so ein M�ll",
CSocket...Server Error 131 during Enter Closing Amounts
I ran into this error today Server Errror 131 when trying to enter closing
amounts after a blind close out.
We had added a new tender type and we were advised (by ABANCO a credit card
company) that a "Display Order" did not need to be set. So I left it blank
(or 0) and we blind closed yesterday without problem.
Today we got the Server error 131 and the enter closing amounts screen would
not show and tender types except AMEX.
Well solution is / was When entering tender types set a Display order number
that is not equal to a tender already set up. our newly added eCheck Sale wa...How do I select a specific amount of random values for individuals
How do I select a specific number of random values from each agent in a query
Case: I have a list of audits recorded in a table or query that list by
agent name and claim number completed. What I want is to select a specific
number of rows for each agent, but that selection be random rows for each
On Dec 7, 1:22 pm, I don't know?? <I don't
> How do I select a specific number of random values from each agent in a query
> or table.
> Case: I have a list of audits recorded in a table or query that list...PST file too large.
I'm getting a message when I move emails from one folder to another folder.
I'ts something about the pst file being to large. My pst is 2gb in size.
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Damien" <email@example.com> wrote in message =
news:ljqIg.75694$1Q6.58204@...How do I break a large word document into smaller components?
I have a very large Word document (over 40 MB) that I update several times a
year. I would like to break it into smaller components so that only the
affected component would have to be backed up online. However, I still wish
to maintain the ability to create a table of contents and index for the whole
Is this possible and if so, what is the process to do it.
I am using MS Office 2010 beta running MS Windows 7 Home Premium on a 64 bit
You can simply make multiple copies and delete whatever you don't want from each copy.
For the mul...Large diagram crash
Operating System: Mac OS X 10.6 (Snow Leopard)
Hello, <br><br>what is wrong with excel 2008? <br><br>As soon as I have some data larger than say 10000 numbers and want to create a simple line diagram, the program crashes. <br><br>Same file on a windows vista comuter and excel 2007 takes 1 second to create the chart without worries. <br><br>I have a 2ghz macbook. with 3gb ram. I work in research and all my data is larger than 10000. <br><br>How can that be? <br><br>Thank you, <br>&...Unable to send large attachments
Currently I am using Outlook 2007 with a number of e-mail accounts
(1-Exchange, 1-POP, 1-Hotmail) so in a way I have an equilibrium of accounts
in one package.
The problem I have is sending a large document (let's say a 1-Mb PDF file)
attached on to the e-mail.
What is seems to be happening is once Outlook has sent the e-mail, instead
of moving the mail from the Outbox to the Sent Items, it remains there and
it forms a continuing loop where it constantly resends the mail. The
receiver ends up with a mail box full of multiple e-mails with large
Appar...Unusual Security Audits
be happening. At one point there was 350 audits in 1 second, the same 4
events repeated, special logon, logon, Kerberos Service Ticket Operations,
I disabled IPv6 and found things are running a little better, but I'm still
getting a lot of strange logon and logoffs.
Can anyone give me guidance of how to figure out what is causing this and
possibly how to fix it?
Here is an example of a logon event:
An account was successfully logged on.
Security ID: NULL SID
Account Name: -
Account Domain: -
...How do I summarize unusual column data?
I have a column of data that is in the following format:
2:37:56 (2 hours:37 minutes:56 seconds)
How can I have the summary cell display an average days/hours/minutes for
the entire column? Thanks.
Thank you so much for your quick reply! Actually, I needed average
I think the calculation is close, but it gave me
930202 day(s) & 12:56
Can you help one more time? Thanks so much!
"מיכאל (מיקי) אבידן" wrote:
> =TEXT(INT(AVERAGE(A:A)),"#")&" day(s) & "&TEXT(MOD(AVERAGE(A:A),1),"hh:mm...Unusual VLookup in 2007
Hello and Happy New Year!
I am working on a special project that requires me to match file names on
two different directories. Some of the file names are in another lanquage
and use accent marks, etc. When I use a Vlookup, it returns no match even if
I can see the file in the other list. I assume it has something to do with
the accent marks, etc. Each file name also has a unique 16 digit number at
the beginning. I hoped I could tell the Vlookup to match the first sixteen
characters. Even though I know it is there, the formula returns NA#. My
formula looks like this: =V...Getting Meeting Acceptances Despite Being Removed From Delegates List
I was given delegate rights to view my boss's Inbox. That delegation
right has since been removed, but I still get their meeting invites
and meeting acceptances. This has also happened to another colleague
who was given delegate rights to another colleagure. Again, the
delegate rights have since been removed, but they are still getting
the meeting invites and acceptances.
I've searched and found references to people wanting to hide them,
move them, delete them and other sorts of things, but haven't come
across anyone who is still getting them despite not having the
deleg...Large fonts, Themes, and Nasty bitmaps!
I use the following code to render the arrow button from a scroll bar while
DrawThemeBackground(m_htheme, pDC->m_hDC, SBP_ARROWBTN, iStateId,
The arrow button is used on a dialog to indicate that the dialog can be
expanded or collapsed. Under DPIs of 96 and 120, the arrow bitmap renders
nicely. However, if I change to using "Large fonts", the bitmap is distorted
and renders with jagged edges. Any ideas how to overcome this display
Gort, Klaatu, Barrada Nikto...
Probably not, because the arrow is represented as a bitmap, w...Require Tax Detail Totals to Match the Pre-Tax Amount in SOP and .
Please incorporate the Require Tax Detail Totals to Match the Pre-Tax Amount
functionality into POP and SOP. I created a CR/PR on this and dev informed
me this was a product suggestion. This is very important functionality for
European clients in terms of producing correct VAT returns.
...Can I save large publisher documents in smaller page increments?
I have a large Publisher 2003 document that, when saved as one file, locks up
my computer. Our tech guy told me to save it in smaller parts. I was hoping
to save it in 5-page increments, but that doesn't seem to be possible.
Anyone have any ideas on how to do this more simply than just dragging,
deleting, adding, etc.. Any assistance would be greatly appreciated. Thanks.
No simple way. Obviously you can open the file, delete all but five pages, save
as a new name. You can delete from the page tabs. Open the main file again
delete all but a different five pages, save as a new na...Unusual Request...
Odd request...we're looking for an Excel sharpie who'd like to become
involved with our project. Ever heard of a "virtual airline"? It's a
website hobby involving Microsoft Flight Simulator, where we simulate
the operations of a real-world airline as closely as possible and
practical (ours happens to be a small, regional bush-flying airline
situated in British Columbia). Members join, they fly scheduled
flights, and we try to do all the stuff a real airline would do...which
includes tracking a pilot's flight-time, keeping records, and generating
"v...Business Portal connecting to Terminal server with unusual port nu
I am trying to connect my Business Portal to our terminal server. For
security reasons we are using an unusual port number (54903). When we put in
just the Terminal server name in the Business Portal area in the site
setting, general area for Terminal server we get a 516 error (winsock socket
connection failure). if I put in the name of a different server, it works ok
(opens a terminal server window). how do I have it redirect to the proper
Terminal server with the unusual port number?
...Their Salary Matrix is Unusual
We have a client who has given us their salary matrix on an Excel
spreadsheet. Instead of having just three columns for Low/Medium/High, they
have five columns.
These columns are Min, 25%, Mid, 75%, and Max. Each of these colums has a
salary (dollar figure).
Is there anyway to create such a salary matrix in Great Plains HR, or are we
going to have to find a way to convince the client to use a new salary matrix?
...spell check isn't accepting my command to change to suggestion
I think I'm using Windows Vista 2007. Being computer ignorant, I don't even
know how to verify that. Before changing from Windows 2000, spell check
worked fine. The settings seem to be set right. Spell check will make
spelling suggestions, and when I tell it to make selected changes, it makes
the change BEFORE I HIT SEND, but once I hit send, the changes revert to the
miss spelled word. What can I do?
...Changing relative to absolute cell references in large block of cells
I have a large block of cells set up that I now find I need to move. The
cells were originally set up as relative since I needed to do things like
fill down & right, etc. But now I find I need to move that entire block of
cells to another location, and of course, now the cells are referencing to
cells that don't exist. I need to change the entire block before moving and
I don't see any way to do that for a large set of cells.
Thanks again for any help
If planned properly, both relative and absolute reference normally move
without problem. Possibly you are making the...Increase the amount of columns
I need more columns in a spreadsheet. I don't need 65000+ rows. Can
take rows and make them columns.
My mission is to have a column for every day of the year. I need 36
columns plus a few for totals and titles...
Thanks for any possible help
Message posted from http://www.ExcelForum.com
No, 256 is the max per worksheet.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"mark hansen >" <<firstname.lastname@example.org> wrote in message
news:mark.hansen.141rw...Large file #3
I'm working in a file created by someone else that needs
to get sent to numerous vendors, who then need to key data
into it. I'm very concerned with the large file size
(9.83 mb), so I've been trying different ways to make it
smaller. I ran Rob Bovey's code cleaner and made sure
there were no extra "used" rows or columns. There is a
lot of conditional formatting that changes cell colors,
and quite a few cells with borders and background colors.
Will getting rid of the borders and colors help me enough
to bother with? All suggestions greatly welcomed on t...Outlook 2002 Removes Large Attachments
We are attempting to send approx 30Mb Power Point presentations. The email
gets sent fine, shows up on our email server fine, but when downloading via
POP3, it takes a long time (as expected) but the attachment is nowhere to be
found. Smaller presentations work fine. Outlook 2003 works fine. Outlook
Express works fine. I have tried on Outlook 2002 SP1 and SP3, same results.
Thank you for any help!
Make sure the message format is plain text or HTML (and consider disabling
Word as the e-mail editor). If the message goes out in RTF and a pop client
like OE downloads it, then it will ...How can my computer accept email in xls
I get e-mails from my headquarters that comes in xls. format and my computer
does not accept them. I have to contact HQ and tell them to send e-mails to
me in pdf. format.
There's a good chance this extremely simple technique will work:
Have the sender change the file extension from xls to txt. That may be all
you need to do to get around the possibly meager security.
Does that help?
> I get e-mails from my headquarters that comes in xls. format and my computer
> does not accept them. I have to contact HQ and tell ...