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...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,
...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...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 ...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...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....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...Capitalize Text if 2 lists are equal
I want to compare 2 lists on separate worksheets - (A2:A9) on both
sheets. The lists contain text. If the lists are equal I want the text
in cell A1 on the second worksheet to be "PROPER"case. If the lists are
not equal I want the text to be "UPPER" case. Can I use a standard
formula or an array formula to do this? Thanks for any help!
elevdown's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29668
View this thread: http://www.excelforum.com/showthread.php?...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. ...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!
...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?
...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?
"...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...Distributed Transaction on SQL 2005
A stored procedure running from server A database db1 updates both local
tables, as well as, remote ones, on server B database db2 via a db link. All
updates are part of the same distributed transaction.
I have got it to work on one server. In other words, I have made all
provisions to make this work like turn off rpc security, configure msdtc in
However, when I changed the remote server to be server C database db2...
The two inserts done on the local server succeeded. But delete comman
against remote table never comes back. No errors or locks.
Wha...Investment Transactions not appearing in Cash Transactions
The Cash Transactions register is missing items that are
present in the Investment Transactions register, causing
the month-end money balance to not reconcile with the
monthly statement from my brokerage.
I'd like to try deleting all my transactions back through
the most recently reconciled month, and downloading them
all again. Is there any way to do that?
Version: Money2001 Deluxe & Business
What kind of items are missing? Buys and Sells?
"Jim F" <email@example.com> wrote in message
news:694601c3e668$b32bb8...Transaction in ms crm webmethods ?
Does the WebService (WS) MS CRM use transactions while updating or
creating records ?
For exemple, I want to update a contact record, and in the same
transaction add to this contact a new address.
If the update of the contact is OK, but the creation of the address
fail, I want MS CRM to cancel all the changes made.
Is this native to MS CRM, or have I to made the rollback manually ?
If I have to do it manually, have you some tips on the best way to do
Thanks a lot
CRM does not use transactions, and there is no roll-back facility. You would
need to store the original state...Unreconcied Transactions not showing in a Cash Transactions #2
I am using Money 2006 Premium.
I am downloading all my investments transactions from Broker.
They all marked as (E) transactions.
But a coupel of times I found missed transactions for stock options and add
them manualy to Investments Transactions, but these transactions marked as (
) - unreconciled and not showing up in Cash Transactions and it make my cash
ballance incorrect. I already trryed manualy make Make As.. (C) or (R) but
they still not showing in Cash Transactions.
How can I make them show up there and fix my Cash balance proble?
In microsoft.publi...Moving Transactions #2
Is there a way to move transactions up or down in a list? When I import my
account information and have many transaction on the same date, sorting by
date, I would like to be able to list those transation in a particular order.
Let's say on 4/5 I had 3 transactions a withdrawal, a deposit, and another
withdrawal imported in that order. Is there a way to move the deposit up in
the list to be the first transaction for that day?
In microsoft.public.money, lumaduc wrote:
>Is there a way to move transactions up or down in a list? When I import my
>account information and have m...How to tell when a transaction has been rolled back?
I have a CLR stored procedure that uses a transaction to insert a row into a
table. I need to tell somehow by looking at my sample data whether or not
the rollback has actually happened. The only thing I have to go on is the
HeadlineID int identity(1,1) not null column. Is this possible?
1. Run the stored procedure with sample data forcing it to succeed
2. Look at the data in the table itself. The current identity is set to 28.
3. Run the stored procedure again forcing it to fail. This is done by a
unique key column [HeadlineTitle].
4. Look at the table again to make sure this ru...