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
>...Will somebodu response to this post
No need to apologise since you were drunk and unaware of what was going on.
...Batch Not Posting
Hello all, we have an issue where when we attempt to post from several
different modules it gets so far then kills great plains. we have to go
into the batch recovery run the batch recovery at which time it will
print the reports them GP dies again. then we have to go back into
batch recovery and hit cancel on all the reports and it will them post
the batch. TIA
...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...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...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 ...Word wrap doesn't always work properly
I have something odd happening with word wrap for text fields in a report:
Word wrap is not consistent. For this text field the 'Can Grow' property is
set to yes, and the field wraps, but it often cuts off the end of words.
For example, the text "No charge work order (WO 159407) CK WTR HTR/WORKING
FINE" in this particular field appears as:
No charge work order (WO 159407) CK WTR HTR/WORKIN
As you can see, the last letter of the word "WORKING" is missing.
Anybody out there have any thoughts? Do the upper case characters have
something to do with this ...Users vs Owners level rights
Hi,I learnt at some point that it s more secure to set the queries rights atowners level rather than grant rights to the table itself. and i have beendoing that, but quite blindly.could someone clarify as to what is the exact benefit of doing this? what ican see that it limits the extent of change a user can do to the table towhatever the query will allow. Is there something besides this too?ThanksRamesh Thanks Arvin.
"Arvin Meyer [MVP]" <email@example.com> wrote in message
> You've got the main reason to secure the tables...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...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...Out of Office not Working #4
Have a user whose Out of Office is not working. Has been
suggested that he might have too much mail (How much is
too much?). It recognizes the Out of Office is turned on
but still lets mail thru without replying to sender. Any
From what I understand, Out of Office only works in an
Exchange enviroment, not when you pop your mail. Also,
Exchange has to be configured to allow Out Of Office
>Have a user whose Out of Office is not working. Has
>suggested that he might have too much mail (How much is
>too much?). ...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. ...Hyperlink not working
I'm working with Excel 2002 and what to make a hyperlink into anothe
xls file using the hyperlink function, I use this string:
("[C:\Documents and Settings\Al
where november.xls is the file I want to open and daily is the specifi
worsheet, daily file is what apears on the hyperlink, when I hit th
Hyperlin it does open the november file but does not take me to th
daily worksheet and opens a "Reference is not valid" sign, I have mak
sure that the daily Ws exists and have tried with other WS in the sam
file w...MS Duet work with MS Project
I understand the collaboration of SharePoint and SAP “Duet” will be
integrated with 2010 office suite. Does this include MS Project? Will Duet
work with MS Project?
I doubt that Reuter, but you may want to have a look at a product from TPG.
(The Project Group). they specilise in the integration between Project Server
Hope this helps
Marc Soester [MVP]
> I understand the collaboration of SharePoint and SAP “Duet” will be
> integrated with 2010 office suite. Does this include MS Project? Will Duet
>...Unable to Post Payables (Computer Check) Batch
We have a Payables (Computer Check) Batch that we are unable to post.
Originally the post was stuck with the status of "posting". We followed the
steps to unlock this batch (Link to Instructions appear below):
This has worked for us in the past. After unlocking the Payables Batch the
status changed to "Available". Unfortunately the batch still shows a "Last
Date Posted" of 01-14-08 which was the date we first tried to post this
batch. Since this...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!
...Send/Receive not working #2
Having recovered from a recent crash, which involved
reinstalling Outlook, I now find I can't Send/Receive
email. My email account settings work, and tested OK.
However, when I press Send/Receive I simply get the
message, "Operation Failed" - nothing else, no error
message or code, no nothing.
I also tried to open up Outlook Express, but I can't, it
just won't open, even uninstalled and reinstalled it, but
it still won't open, no error messages there either. Just
the none appearance of OE. All the files seem to be there
on the HD, but no action.
I can't h...CRM 3.0 Removing a Subject Level
We currently have 3 levels in our subject tree. We are looking at integretion
with Great Plains and we had set it up originally with only 2 levels.
What are the ramifications with removing a subject level? Does and item
revert up to its parent subject?
Thanks so much for your assistance!
You cannot remove any subjects that are linked to other objects. So Step 1
is to re-link all the other objects to the new subject you want to link them
to. No mean feat! Probably only doable on an industrial scale by
(unsupported but reasonably safe ) direct database updates. Take a go...Reminder is not work in default folder
I used as follow coding to send email to outlook client(outlook 2000):
Dim ll As New CDO.Message
Dim bb As New CDO.Configuration
bb.Fields(cdoSMTPServer) = "nc80012"
bb.Fields(cdoSendUsingMethod) = cdoSendUsingPort
Set ll.Configuration = bb
ll.Fields.Append "urn:schemas:mailheader:x-message-flag", adBSTR _
, -1, _...