RMA ( Credit) Missing Line Items
This is a multi-part message in MIME format.
Two RMA documents were received and then set as "Ready to Close". Both =
documents show, in GP, as "History" but missing the line items.
Checked the SQL tables and both RMA documents are in the "open" tables =
(SVC05000 and SVC05200) and the line items are in the tables and appear =
to be linked to the header. =20
How do we get the line items to appear on the RMA docu...Can't create the item
I use Outlook from MS Office 2003 Business Edition.
Everything has worked fine until the past few days. Now,
whenever I click on an E-mail address link inside a
webpage, I get a message from Outlook that says "Can't
create the item."
One person on this group gave me the following advice:
>Close Outlook, find and rename the frmscache.dat to .old
I did searches on all my drives and the file named above
was not found.
are you using the advanced option to search all hidden files and folders?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outl...Using Float Type Variables for Primary on SQL 2005
We seem to have hit an oddity.
We have a stored procedure that gets the next sequence number. It is
protected by a transaction so no two processes could update the table of ids
at the same time. Every so often, we get duplicates. How could that happen?
Is the value based on mantissa? If so, is there a way to expanded it?
Keep in mind, I can't change the type from float.
Any help is greatly appreciated.
Thanks in advance
On 2010-07-19 16:19, RG wrote:
> We seem to have hit an oddity.
Please don't multi-post. If you have to post to multiple newsgroup...CRM 4.0 Email Router Mailbox not deleting items
We are using the Email Router for Dynamics 4.0. An account and mailbox has
been setup called CRM Mail. This accounts mailbox has grown to 9 Gig. Upon
further inspection it looks like there are "forwards" of individuals emails
in the Inbox of this account, that have been sent from our CRM Users.
Do these messages need to remain in the Inbox or can we safely delete them?
Are they supposed to be automatically deleted?
Also, why are all these emails showing up?
The emails in the forward mailbox should be deleted automatically after being
processed by the router. ...How do I use a variable in a cell reference? #2
I'm trying to reference a cell using other cells, for example: B(60-A30),
which is to mean reference the cell in the Bth column, and the (60-A30)th
row. How do I do this in Excel 2000?
I think you can use a command called Indirect.
eg if you had "B1" written in cell A1 you could do the following:
=indirect(A1) and it would retrieve the contense of cell B1
You can also use concatenate formulas within the indirect to construct a
cell refrence from two cells.
eg if Cell C1 contained the number 3
=indirect(concatenate("A",C1)) would retrieve the contense of Cell A3...Outlook removes in box items upon reply
When I reply to an item (all items) they are removed from
my inbox and disapper -- not in deleted items -- I cannot
find them. What is up with that and how do I fix it ?
"Jeff J" <email@example.com> wrote in message
> When I reply to an item (all items) they are removed from
> my inbox and disapper -- not in deleted items -- I cannot
> find them. What is up with that and how do I fix it ?
View-Current View-All messages.
When I look at that, it does nothing. If I cahnge the
View to "View Me...Using possibly If and Vlookup
I have a spreadsheet where I want to first of all look up hours worked in
cell N2 (within this cell is the number 35.00 or the number 37.00).
I then want to use this cell to do a lookup bringing back one salary if N2
is 35 or another salary if N2 is 37.
In my main spreadsheet I have a spinal column point in cell J2.
I have created two lookup tables on another spreadsheet named salary35 and
salary 37. These tables show the spinal point in one column and the
appropriate salary in anoter column.
7 12...Sent Items issue
When i send an email they sit in the outbox instead of going to my sent items
folder. The items that are in my sent items folder cannot be moved or deleted
as it comes up with an error. Any help would be appreciated. Thank.
On Thu, 20 Jan 2005 06:41:04 -0800, ctdude wrote:
> When i send an email they sit in the outbox instead of going to my sent items
> folder. The items that are in my sent items folder cannot be moved or deleted
> as it comes up with an error. Any help would be appreciated. Thank.
What version of Outlook? What sort of mail account(s)? What is the error
th...Adding items (hours) into invoices
In my M07 Home and Business, I get an error while entering an invoice as
soon as I add hours and press enter. The program says that there's an error:
"This operation can not be performed"
When I select more help, I get a help page that say:Details
When I search on this I see that it is an error that's related to homepage
settings, but that does not work for me.
...Help with variables for chart
I'm hoping someone can point me to a tutorial or helpsite with information
as I can't seem to find any.
I set up a basic Access database to record stats for my team (it's a contact
centre). However, I've now found that the Agent PC's don't have Access,
just Excel and Word, so I'm trying to put together something similar.
What I had: The Agent chooses a start and end day for their stats. This
displays all the data for that time (incoming calls answered, talk time,
wrap, idle) and creates a chart for each stat. In addition, it also
includes the average for ...Want to use same Chart against changing data and variable titles?
Excel 2003: I have data for a number of branch offices that is set up in the
same format on a spreadsheet. I want to use the same chart to successively
display each branch's data and change the title to identify the branch.
I have daily data of some of my scrips in rows in a sheet.
when I click a particular scrip name that scrip's chart comes up.
I presume that this is the similar thing you want.
if so send an email I shall send you my sheet as attachment by email and you
can modify to suit you
remove dollars from the following address
"J...SQL Command match Items to Matrix
SQL command that will put all items which contain a certain Supplier ID # to
be added to a matrix that I have created. We have a company and we want to do
a matrix for all of there items. But instead of manually adding each item to
the matrix. If I could run an SQL command that will take all items with the
supplier ID attached to them and have them added to the matrix. I am aware
that I will still have to label the dimensions. It would just be fantastic if
I could do a mass add. Hopefully someone has a creative mind. I tried some
commands, but I am not an SQL master either. I know that ...Possible to get rid of without rebuilding everything?
Back to years ago, the consultant set up our forest
with empty root domain and one child domain. Right
now, the forest functional level is windows 2003.
and all DCs are windows 2003 domain controller. All users
and servers are on the child domain.
Currently, we are thinking to move to Windows 2008
DCs. If we need to get rid of the empty root domain.
is this possible without affecting our applications
(exchange etc..)? BTW, why is the reason to keep this
empty root domain?
You are stuck with the root domain forever. Root domain is no longer
Is there a way to have excel auto-sort (cutom) by criteria in 3 columns?
I think it might be easier to explain by viewing the workbook
The picture shows how I need it to sort. I found some information on
auto-sort in help and also on the net, but I don't know how to
incorporate the multiple criteria or if it's even possible. Any ideas?
Pools's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35961
View this thread: ht...Display public variable in Header
I have page breaks when a variable changes. How can I
display what that variable is in the header?
Thank you in advance
God bless you
...HTREEITEM variables need to be defined as STATIC?
Does HTREEITEM variables need to be defined as STATIC, otherwise after
calling the CTREECTRL member function, the variable's value will be
Thanks for your answer.
>Does HTREEITEM variables need to be defined as STATIC, otherwise after
>calling the CTREECTRL member function, the variable's value will be
Generally the answer is no, but it'd be clearer if you showed some
example code that you're worrying about.
...Q: Charting with two variables on the Y-axis
Using Excel 2000:
I have two tables and want a line graph based on one row,
but with the values of another row:
Region1: 10, 10, 15
Total: 50, 60, 100
Region1: 60%, 80%, 45%
Overall: 50%, 90%, 50%
I want a line graph that compares the satisfaction rates
of region 1 vs. overall (ie, it will show two lines, one
for region1, one for overall). That's pretty
straightforward. However, what I also want is, for
Region1, to show the vote counts as values above (or
below) the datapoints for the region 1 line.
Can this be ...Days containing Items are not Bold in anything 2 months earlier than current month
Thanks for reading my first post to this list.
I have a simple question that I still cant answer :(
I just did an archive of Outlook 2003. After I did that, the days containing
Items are not Bold in anything 2 months earlier than current month. Funnily
enuf, the days still contain those items. They are just NOT bold. Anything 1
month earlier than the current month is bold so its not an
options-configuration problem, I thinik.
I just archived folders that had items of last year, thats all, nothing
I appreciate any help/pointers/tips given.
This is the defau...Is it possible to run an Oracle PL\Sql procedure within Excel?
Is it possible to run an Oracle PL\Sql procedure within Excel?
Yes, but you would need to use ADO to setup the commandtext to issue to the
database, and process the results.
Do a Googl on 'ADO Oracle Stored Procedure'. Top result is
"mowee" <firstname.lastname@example.org> wrote in message
> Is it possible to run an Oracle PL\Sql procedure within Excel?
...Variable item costs
Hello. Our business (jewelry) has many items whose costs fluctuate based on
current exchange rates...also our discount rates with some of our suppliers
can vary based on different currency rates as well. Is there any work
around, offset, best practice or method that anyone can think of or is using
to deal with this situation with respect to configuring item prices?
finally a question i can help answer! (hopefully :-)
I'm pretty sure what you need to do is start using a "Weighted Average". RMS
has this feature where the cost of an item is averaged over time ...Re: Unresolved item
This well known problem has come back to haunt me. See
If an appointment has been made containing an email address that is not in
Contacts it will refuse to sync (ActivSycn 3.7.1).
One way is to add each contact to the address book - not very sensible if
this is one off meeting with people you are never going to meet again.
So I'd like to know if there is a way of listing (or searching for) only
those appointments that have emails (attendees?) attached to them?
Try posting to microsoft.public.pocketpc.activesync it is not an Outlook
-...Item Transaction Entry
We currently have two companies and would like to know the best way to
transfer inventory from one to the other.
Currently we use Transactions-->Inventory-->Item Transaction and enter a (-)
Qty to get the item out of Compay A, and do the same (+) Qty in Company B to
get the item into the Inventory of Company B.
We follow up with a report (using a batch name to mark these transactions)
to do Intracompany transactions to match the totals. Without purchasing a
3rd party software to handle advanced intercompany transactions, what is the
best practice at this point.
Ric...Sale batch report with the total quantity sold per item
How i can setup a sale batch report with the total quantity sold per item in
the given batch # range for each item
Item :464343 Qty 12
Item :678445 Qty 67
here is a query that will give that result for the current day:
select t.storeid, batchnumber, itemlookupcode, sum(e.quantity) qty
from [transaction] t
join transactionentry e on t.storeid=e.storeid
join item on itemid=item.id where time>convert(char,getdate(),101)
group by t.storeid, batchnumber, itemlookupcode
order by t.storeid, batchnumber, itemloo...Is it possible to display a CView in a Cdialog
Would it be possible to insert a CView in a CDialog.
I explain I have a CDialog based app with a CStatic control
(IDC_CARD_GOES_HERE) inside and I am loading a Cwnd control for now like
CWnd* pWnd = GetDlgItem(IDC_CARD_GOES_HERE);
m_editor.Create( WS_CHILD | WS_VISIBLE, CardRect, this, &m_objs ); //
Create the control over CStatic
But now I have a CView instead of my Cwnd and could it be possible
to load it ?
Yes it can be done, but why would you want to do it? Why not insert the
c...How do I prepare a cost-volume-profit (CVP) graph using EXCEL?
How do I prepare a cost-volume-profit (CVP) graph using EXCEL?