Transaction to read when no actual transaction
I have an account called 'Honda accord'. It is an asset account that has a
loan associated with it. The loan account is 'Honda loan.' I imported a
transaction into Honda accord and says i have 1 transaction to read. I have
view all dates/transactions selected and nothing comes up. The box to the
left says i still have a transaction to read and I cant find the darn thing.
Stephen and Erica Chenelle
In microsoft.public.money, Stephen & Erica Chenelle wrote:
>I have an account called 'Honda accord'. It is an asset account that has a
>...Paid Transaction Removal not removing some transactions
When running Paid Transaction Removal two transactions for an account were
not removed to history while seemingly identical transactions in another
As I understand the rules of paid transaction removal, a transaction will be
removed if it meets the following criteria.
1. If it's an invoice it must be fully paid.
2. If it's a payment, the document amount must be fully applied to one or
3. The removal date must be after the document date.
The documents are debit notes, are fully paid off (CURTRXAM = .00000) and
the document dates precede the cut-off d...Logging on as another user
Is is possible to log onto CRM as another user other than the one logged
There are two ways to do this. One is to go to Start...Programs...then
right click on Internet Explorer and choose Run As. Another way is to
open IE...Tools menu...Internet Options...Security....Local
Intranet....and choose Custom Level in the security level section. At
the end of the list you can choose Prompt for Username and Password.
Chubbly Geezer wrote:
> Is is possible to log onto CRM as another user other than the one logged
> into Windows.?
...V10 - Transaction by debtor enquiry report
Anyone any ideas why when printing the transaction by debtor enquiry report,
the last digit of the amount is dropped off?
This is when printed as A4 - payables is okay going to same printer.
Okay when displayed to screen - only lost when actually printed.
Is the last digit perhaps trying to print outside the 'printable' area of the
printer? If you do not use A4 paper does it work? Do you have the A4 module
> Anyone any ideas why when printing the transaction by debtor enquiry report,
...Exchange System Manager Error #3
I just installed a new certificate on my Enterprise exchange server. I had
been using a Small business server as a front end server and recently ran
the transition pack to convert to a full Windows 2003 server. I am no
longer using the exchange that was on the small business server and have
disabled all of the services until I get a chance to remove it. When I try
to access public folders from Exchange System Manager, I get the following
the SSL certificate server name is incorrect
ID no: c103b404
Exchange System Manager
I am not sure what is causing this. All of the public ...How are transactions automatically assigned to categories?
When I download my credit card statements into Money, I
notice that some of them are automatically assigned to
categories. How does Money do this? Is the information
included in the info I download from my bank, or are
there rules within money?
More importantly, how can I add my own rules to auto-
...PM Transaction Work vs Open
What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN?
work = saved
open - posted
> What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN?
As an add on, the work also includes recurring transactions.
> work = saved
> open - posted
> "Steven" wrote:
> > What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN?
> > Thanks,
> > Steven
"klewis&quo...Receivables transactions not aging individual transactions
Looking at smartlist, the Receivables transactions have a search/favourite
added, including the aging periods.
When you look at the search, it doesn't age the individual transactions, but
instead ages the entire customers balance.
I would expect it to show the aged balance per transation.
With how Smartlist is currently designed, the default smartlist object pulls
from the Summary table for those aging period amounts. This is the reason why
it does not show the aging for individual transactions.
I know that the ability to see the aging of the individual accounts would b...Logging mail content
The management give me the following task: they need an easy way to log and
view the messages sent and received from specific users. I can enable some
users to have access to others' mailboxes, but the process of attaching the
Outlook client to different mailboxes requieres reconfiguring Outlook (a too
difficult task for the person that will do the task regularly), and you can
miss e-mails deleted by the user. What they want is that for each message
sent from this selected mailboxes, will be silently sent a copy to a
designated mailbox; and for each message received, the same. How can ...TRANSACTION and SELECT *
I have a question about SQL Transactions:
For example, I have a table with 3 rows (ID 1, 2 and 3).
Now I insert a new row within BEGIN TRANSACTION, and I do not commit yet.
In another SQL Session, I try to select data.
When I do SELECT * FROM Table, it is blocked.
When I do SELECT * FROM Table WHERE ID = 2 I get a result.
How can I make SELECT * FROM Table possible even when
there is a open Transaction ? Of corse I only expect to get
the ID's 1, 2 and 3 back and not the new row.
I have looked about IsolationLevel, but this does not help.
Thanks for any comments ...log inverse
i want to take the inverse log of a value. like inverse log (0.69897) in
micro soft Excel.
> i want to take the inverse log of a value.
> like inverse log (0.69897)
Depends on how you computed the log in the first place.
If LOG(n) = 0.69897, then 10^0.69897 is n, the inverse
log to the base 10. If LN(n) = 0.69897, then EXP(0.69897)
is n, the inverse log to the base e -- effectively e^0.69897.
In general, if LOG(n,b) = 0.69897, then b^0.69897 is n,
the inverse log to the base b, where "b" is a constant or
a cell reference.
...Upgrade Paths for OneNote
Will customers be able to upgrade from OneNote 2003 to OneNote 2010?
Yes, but not for free.
"LH1962" <LH1962@discussions.microsoft.com> wrote in message
> Will customers be able to upgrade from OneNote 2003 to OneNote 2010?
...Sorting - Keeping multiple locations together
Have a spreadsheet with items.
A = Multiple Locations
B = item id (in each location)
C = Description
D = Qty on Hand (some have zero)
E thru J = has misc data
I am trying to sort by D - Highest qty on hand and bring all locations with
it - no matter what qty is showing.
A B C D
100002 PC12345 tool for PC 2500pc
100003 PC12345 tool for PC 0pc
100004 PC12345 tool for PC 400pc
100005 PC12345 tool for PC 10pc
date: Thu, 5 Nov 2009 21:58:00 +0800 author: CARM
Re: Sorting - Keeping multiple ...Rounding on Investment transactions
I've seen this problem for quite a while in Monday (at least 01, 02, 03,
and 04). But when I'm entering my transactions, often times the final
amount (shares*cost+comm) don't equal out, it's always the matter of 1
penny, but I'm a bit anal that way.
For instance. 0.78800 shares at 27.8900 per share. Fully worked out it
comes to 21.97732. So when Money does the transaction it rounds it to
21.98 (makes perfect sense). My brokerage relays the cost as 21.97.
What options do I have to make these transactions actually work out? Since
I can't do a negative commis...Running a MFC-app as a system service
I want to run an MFC-app as a XP-system service.
I made a wrapper service which is started as a service upon boot and the
launches the mfc app.
When started manually everything is fine but when the service starts
after boot, the mfc pops up a message box which states that there "was
an error creating an empty document".
I tracked down that ProcessShellCommand in InitInstance fails.
Do I have to delay the appstart until all other services (designs et
al.) are running, i.e. make it dependant from above services?
Withdraw my question....
...Receivables Transaction Entry #2
Anyone have any idea why the Address ID does not get saved on the
Receivables Transaction Entry when posted?
Microsoft SBF Specialist
5/4/2007 3:27:40 PM
There is no field available in the Receivables Open table to store it!
I have put in this suggestion since version 5.5, and it still hasnt
You will have to develop a customisation to track it in a parrellel table.
(Or use VBA & DUOS table)
"Japheth Nolt" <firstname.lastname@example.org> wrote in message
news:xn0f5t47t3uqcr000@msnews....Debugging SQL Server 2005 Transact SQL
I have an urgent requirement to debug Transact-SQL in SQL Server 2005
and I have a couple of questions.
1. Are there any *free* programs that will allow me to debug (step
through line-by-line, look at cursor results, variables, etc).
2. If the answer is 'no' and Visual Studio is the least expensive
alternative, which versions are compatible and have debugging
Thank you very much in advance.
allanc (email@example.com) writes:
> I have an urgent requirement to debug Transact-SQL in SQL Server 2005
> and I have a couple of questions.
> 1. Are th...Log Database Opening without a Form
Is there anyway to log an entry each time a MDB is opened without a
form. e.g. log an entry even if a user presses the "Shift" key when
opening the DB.
On 02.02.2010 17:35, rm wrote:
> Is there anyway to log an entry each time a MDB is opened without a
> form. e.g. log an entry even if a user presses the "Shift" key when
> opening the DB.
No, not really.
--> stefan <--
Since the purpose of the "Shift" bypass is to bypass the normal startup,
anything you put into the normal startup for logging purposes would get,
well, ...Formula to reference another worksheet, locate data, then record i
It has been over 10 years since I did my Excel studies and I've
unfortunately forgotten everything I haven't used regularly. My office has
recently upgraded to Office 2007 (upgrade not being the descriptor I'd have
chosen!) and I'm struggling with Excel. I've found my way around most issues,
but I'm REALLY stuck now and suffering Friday-itis on top of it all!
Essentially I have a multi-sheet workbook for my debtors ledger. Each page
has separate columns for the customer numbers, names, total debts in each age
range (7 days, 14 days etc), totals and lastl...Exchange System Manager #7
I have two forests, forest A and forest B.
In forest A there is an exchange organization 2003.
In forest B there is not an exchange structure.
Is possible open exchange organization in forest A by Exchange System
Manager installed in one machine in Forest B?
If yes, how do I do?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Simone" <Simone@discussions.microsoft.com> wrote in message
&...PM/RM Batch--Transaction Threshold?
1) Does anyone have insight as to the practical limits on the number of
transactions which either a PM or RM batch can hold/process prior to
presenting a problem.
2) We have had problems in past scenarios where high-transaction volume
batches (200+) have caused system problems with posting to the G/L and the
Sub-ledgers of either RM or PM. Any way to avoid this w/o reducing the
number of transactions contained in the batch?
...Paid Sales Transaction Removal error message
When I try to do run a "Paid Sales Transaction Removal" against a specify
customer (Microsoft Dynamics GP menu >> Tools >> Routines >> Sales >> Paid
Transaction Removal) in Dynamics GP 10 with SQL 2005, I get the following
error: [Microsoft] [SQL Native Client] [SQL Server] Violation of PRIMARY KEY
constraint ‘PKRM30101’. Cannot insert duplicate key in object 'dbo.RM30101'.
I searched for the error message in Customer Source Knowledge base and found
Article ID : 861084, which I followed and it showed the duplicate document
(invoice...Batch is Receiving Transactions
After going to Transaction>>Financial>>General, clicking on the find and
trying to double-click on on a Batch, I receive the message "This batch is
receiving transactions." This transaction and another one posted at the same
time have been showing this message for over 24 hours. Is there a way to
clear/fix this message so the entries can be viewed and posted to the GL?
There are 2 things you can check.
First check the Dynamics table SY00800 for records related to the batches
and clear these records after checking to see that no one is logged into
Great Plains. ...URGENT System hanging on boot at "Loading your personal settings"
I'm using XP Pro SP3 with all updates. This started out with OE 6 losing
the face of the app. (menu bar shows, and frame - but nothing else) I was
unable to shut it down either by using the red X in top right corner, using
Alt F4, or right clicking the icon on the task bar and choosing close (or
exit?). Using CtrlAltDel showed the program not responding and choosing end
now did nothing. The whole system then became totally unresponsive and I
had to shut down manually with the power button. When I rebooted, I did a
system restore to the last restore point logged. Everyth...Logged in User as Report Parameter?
I need to be able to set the default user of a report to the person
logged into the CRM system. How can this be done? Where do I get the
user's login credentials as they are in the system?
The CRM standard for discovering the current user inside of a report is the
function fn_FindUserGuid(). You can call this function from your repory SQL
statements and it will return the SystemUserId of the current user.
This posting is provided "AS IS" with no warranties, and confers no rights.
> I need to be able to set the default user of a report to...