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
>...PO RCT Not showing up in Enter/Match
We've got a PO Receipt of inventoried items that is not showing up in
Enter/Match Invoices. I've run check links, reconcile, and double checked
everything. Also tried returning the items but the receipt doesn't show up
And hints on how to unstick it? Thanks in advance, and sorry if the solution
Look in the Receivings Line Items SmartList and see if it shows up
there. It may be a corrupt record that never posted. If so, you'll
likely need to go directly in the database to clean it up since none
of the other utilities have ...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...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 ...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...How do I enter the second product key after installing Office 04 on second computer
Operating System: Mac OS X 10.5 (Leopard)
I tried to follow the directions for Office 2008 but could not find the appropriate files to delete.
In article <firstname.lastname@example.orgR9absDaxw>,
> Version: 2004
> Operating System: Mac OS X 10.5 (Leopard)
> I tried to follow the directions for Office 2008 but could not find the
> appropriate files to delete.
...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...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....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?
...Calendar To Stay at Last Date Entered
I have a calendar in a form. We do data entry for information that could
have occurred today, yesterday, or a couple of days ago, like over a weekend.
The form always goes back to todays date. How do I get the calendar to stay
at the last date entered?
Somehow you will need to record the last date entered in a table somewhere.
I use a system table for such items.
>I have a calendar in a form. We do data entry for information that could
>have occurred today, yesterday, or a couple of days ago, like over a weekend.
> The form always goes back to todays date. How ...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...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!
...Getting Glyphs when entering data
I have a shared Access application. At random, some desktops have a problem
where when someone trys to enter data in a field, they get glyphs instead of
text. In the case of a lookup field, it does not recognize anything that is
typed. Any ideas of what to look for?
...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!!
...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?
...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...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...Automatically enter cell address??
I'm trying to make a formula which adds numbers from the same cel
address (i.e. column letter and row number) from various worksheets.
This same type of formula will be used over 200 times but each time th
cell address will change. My question is: is there some function whic
will automatically use the selected cells address so that I can creat
one formula and paste it into many different cells.
Otherwise I'm going to have to enter 200+ different cell addresses on
cell at a time!!!
feel free to email me at firstname.lastname@example.org
Message posted from h...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...