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.?
...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...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-
...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,
...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...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 ...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 ...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.
...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...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, ...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 (firstname.lastname@example.org) writes:
> I have an urgent requirement to debug Transact-SQL in SQL Server 2005
> and I have a couple of questions.
> 1. Are th...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" <email@example.com> wrote in message
news:xn0f5t47t3uqcr000@msnews....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?
...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. ...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...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...Analytical Accounting Dimension ID for Bank Transaction
can any one help me out in finding TABLES of AA from which i can link
dimensions assigned in the Bank Transaction.
I need create a crystal report for it.
Thanks in advance!!
...Reconcile old bank transaction
We switched from bank A to bank B and when I go to Checkbook Balance Inquiry
screen, the old bank A still show current checkbook balance with a negative
value. The transition from bank A to B are all correct in paper works, but
not in the GP.
When I look at the data for 2 transactions in tables, I noticed 1 of the
transaction is reconciled and the other is not; otherwise, every values are
identical. How would I fix this negative balance on old bank? Thanks!
...how do i change the x-axis of a graph to a log scale?
i've got some data that i want to display on a semi log graph, but i want to
change the x-axis to a log scale, not the y-axis. How do i do this?
Double click any value on your x axis, this will bring up Axis format form.
Select scale tab, check Logarithmic checkbox. Make sure that your minimum
value is 1, 10, 100, and your major & minor units must be multiples of 10.
"anne" <firstname.lastname@example.org> wrote in message
> i've got some data that...log off
In Identities i m ubale to see the log off option ... i m
not able to log off in outlook so kindly let me know the
solution for the same
Outlook doesn't support a feature called Identities. Might you be using
Outlook Express (an entirely different program)? OE does support
"vishal" <email@example.com> wrote in message
> In Identities i m ubale to see the log off option ... i m
> not able to log off in outlook so kindly let me know th...Transaction Remains as Transaction to Read
I am using MSMNY03 deluxe on XPpro.
One checking account registered transaction remains in the list of
Transactions to Read and I have not been able to "Accept Transaction".
The account register has a note attached saying:
"This downloadable transaction is a probabale match to a manually
entered transaction. "
After clicking on Accept in the account register, the note remains and
the Transaction to Read list remains with that one remaining
transaction to be read.
How can this be corrected ?
Have you tried clicking "change" instead?
"...GP10: Payables Transaction Inquiry-Vendor window
I'm having a problem seeing the vendor records in the payables tranaction
inquiry-vendor window for some users only (including sa). I've checked the
user security settings & assigned the same security role ID to the
problematic users as the security role ID that is working properly. I've
marked (and unmarked) the task ID but nothing seems to solve the problem.
Any ideas how to fix please?
...Eaton Vance Direct Online Services
I'm finally adding direct downloads from a number of my accounts. When
I set up Eaton Vance online services and connect, all that downloads
is my account share balance - no transactions and no account dollar
value. The register show the # of shares. The account list shows a
dollar value of $0.00. When I look at account settings, for some
investment accounts" track cash transactions" is an option; for Eaton
Vance it is not. Is this a limitation placed by Eaton Vance, or else
what do I need to change to download transactions and account values?
In microsoft.public.money, k...