Transaction level posting not working

I have a problem with one of my clients that I haven't run in to before.  
They are running Dynamics 6.0 ctree.  They have 10 companies set up.  In one 
of their companies the transaction level posting is not working in A/P.  They 
often enter an A/P trx and print a check for it on the fly.  Their usual 
procedure is to post the transaction through transaction level posting.  In 
the company in question, when the Post button is clicked nothing happens.  No 
error msg, nothing.  The trx level posting works in all of their other 
companies.  I've checked posting settings, cleared out all of their batches, 
nothing works.
Any help would be greatly appreciated.
Bill Kersh
0
Bkersh (4)
8/17/2007 2:16:01 PM
greatplains 29623 articles. 3 followers. Follow

4 Replies
396 Views

Similar Articles

[PageSpeed] 24

Bill,

Is this happening on all computers, including the server?  Is it happening 
for all GP users, including DYNSA?  Are you able to put that trx into a 
batch at that point and post the batch successfully?

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.


"Bkersh" <Bkersh@discussions.microsoft.com> wrote in message 
news:A30C8E18-8D09-46B6-A9D6-F4831B4A5B99@microsoft.com...
>I have a problem with one of my clients that I haven't run in to before.
> They are running Dynamics 6.0 ctree.  They have 10 companies set up.  In 
> one
> of their companies the transaction level posting is not working in A/P. 
> They
> often enter an A/P trx and print a check for it on the fly.  Their usual
> procedure is to post the transaction through transaction level posting. 
> In
> the company in question, when the Post button is clicked nothing happens. 
> No
> error msg, nothing.  The trx level posting works in all of their other
> companies.  I've checked posting settings, cleared out all of their 
> batches,
> nothing works.
> Any help would be greatly appreciated.
> Bill Kersh 

0
victoria (3339)
8/17/2007 2:44:42 PM
Hi Victoria,
Thank you for your reply.  They are a stand-alone installation, only one 
computer.  I tried lessonuser1 (they do not have a DYNSA user) and it still 
did not post.  I tried saving it to a batch and posting the batch and I got 
the following error:

Unhandled Database Exception
A save operation on table 'PM_Distribution_HIST' has created a duplicate key.

I rebuilt the keys a few days ago but will try again if I need to.

Thanks again for your help.
Bill Kersh

"Victoria [MVP]" wrote:

> Bill,
> 
> Is this happening on all computers, including the server?  Is it happening 
> for all GP users, including DYNSA?  Are you able to put that trx into a 
> batch at that point and post the batch successfully?
> 
> -- 
> Victoria Yudin
> Dynamics GP MVP
> Flexible Solutions, Inc.
> 
> 
> "Bkersh" <Bkersh@discussions.microsoft.com> wrote in message 
> news:A30C8E18-8D09-46B6-A9D6-F4831B4A5B99@microsoft.com...
> >I have a problem with one of my clients that I haven't run in to before.
> > They are running Dynamics 6.0 ctree.  They have 10 companies set up.  In 
> > one
> > of their companies the transaction level posting is not working in A/P. 
> > They
> > often enter an A/P trx and print a check for it on the fly.  Their usual
> > procedure is to post the transaction through transaction level posting. 
> > In
> > the company in question, when the Post button is clicked nothing happens. 
> > No
> > error msg, nothing.  The trx level posting works in all of their other
> > companies.  I've checked posting settings, cleared out all of their 
> > batches,
> > nothing works.
> > Any help would be greatly appreciated.
> > Bill Kersh 
> 
0
Bkersh (4)
8/17/2007 3:36:00 PM
Bill,

It's possible that one or both of the transactions already posted, but are 
also in the unposted tables.  I would check to see what the status is of 
both the invoice and the payment to help you figure this out.  This would be 
a lot easier to look at in SQL, not quite sure what to tell you about ctree, 
sorry.

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.


"Bkersh" <Bkersh@discussions.microsoft.com> wrote in message 
news:005C8920-BD47-4536-923F-7B21F0038968@microsoft.com...
> Hi Victoria,
> Thank you for your reply.  They are a stand-alone installation, only one
> computer.  I tried lessonuser1 (they do not have a DYNSA user) and it 
> still
> did not post.  I tried saving it to a batch and posting the batch and I 
> got
> the following error:
>
> Unhandled Database Exception
> A save operation on table 'PM_Distribution_HIST' has created a duplicate 
> key.
>
> I rebuilt the keys a few days ago but will try again if I need to.
>
> Thanks again for your help.
> Bill Kersh
>
> "Victoria [MVP]" wrote:
>
>> Bill,
>>
>> Is this happening on all computers, including the server?  Is it 
>> happening
>> for all GP users, including DYNSA?  Are you able to put that trx into a
>> batch at that point and post the batch successfully?
>>
>> -- 
>> Victoria Yudin
>> Dynamics GP MVP
>> Flexible Solutions, Inc.
>>
>>
>> "Bkersh" <Bkersh@discussions.microsoft.com> wrote in message
>> news:A30C8E18-8D09-46B6-A9D6-F4831B4A5B99@microsoft.com...
>> >I have a problem with one of my clients that I haven't run in to before.
>> > They are running Dynamics 6.0 ctree.  They have 10 companies set up. 
>> > In
>> > one
>> > of their companies the transaction level posting is not working in A/P.
>> > They
>> > often enter an A/P trx and print a check for it on the fly.  Their 
>> > usual
>> > procedure is to post the transaction through transaction level posting.
>> > In
>> > the company in question, when the Post button is clicked nothing 
>> > happens.
>> > No
>> > error msg, nothing.  The trx level posting works in all of their other
>> > companies.  I've checked posting settings, cleared out all of their
>> > batches,
>> > nothing works.
>> > Any help would be greatly appreciated.
>> > Bill Kersh
>> 

0
victoria (3339)
8/17/2007 4:11:58 PM
Hi Victoria,
The transactions never posted but I think I'm onto what might be the 
problem.  I have tried just about everything I can think of so just on a 
hunch I tried setting up a new checkbook and trying to post at trx level with 
the new checkbook and it worked.

I don't know whether their checkbook file is damaged or what but I'm going 
to inactivate their old checkbook (they only have 1 for this company) and set 
up a new checkbook and hope that fixes the problem.

Gotta get these people off c-tree and on SQL!  I never knew much about 
c-tree and it's probably been 3 years since I last worked with it.

I really appreciate your help with this and I want to say thank you again. 
Bill Kersh

"Victoria [MVP]" wrote:

> Bill,
> 
> It's possible that one or both of the transactions already posted, but are 
> also in the unposted tables.  I would check to see what the status is of 
> both the invoice and the payment to help you figure this out.  This would be 
> a lot easier to look at in SQL, not quite sure what to tell you about ctree, 
> sorry.
> 
> -- 
> Victoria Yudin
> Dynamics GP MVP
> Flexible Solutions, Inc.
> 
> 
> "Bkersh" <Bkersh@discussions.microsoft.com> wrote in message 
> news:005C8920-BD47-4536-923F-7B21F0038968@microsoft.com...
> > Hi Victoria,
> > Thank you for your reply.  They are a stand-alone installation, only one
> > computer.  I tried lessonuser1 (they do not have a DYNSA user) and it 
> > still
> > did not post.  I tried saving it to a batch and posting the batch and I 
> > got
> > the following error:
> >
> > Unhandled Database Exception
> > A save operation on table 'PM_Distribution_HIST' has created a duplicate 
> > key.
> >
> > I rebuilt the keys a few days ago but will try again if I need to.
> >
> > Thanks again for your help.
> > Bill Kersh
> >
> > "Victoria [MVP]" wrote:
> >
> >> Bill,
> >>
> >> Is this happening on all computers, including the server?  Is it 
> >> happening
> >> for all GP users, including DYNSA?  Are you able to put that trx into a
> >> batch at that point and post the batch successfully?
> >>
> >> -- 
> >> Victoria Yudin
> >> Dynamics GP MVP
> >> Flexible Solutions, Inc.
> >>
> >>
> >> "Bkersh" <Bkersh@discussions.microsoft.com> wrote in message
> >> news:A30C8E18-8D09-46B6-A9D6-F4831B4A5B99@microsoft.com...
> >> >I have a problem with one of my clients that I haven't run in to before.
> >> > They are running Dynamics 6.0 ctree.  They have 10 companies set up. 
> >> > In
> >> > one
> >> > of their companies the transaction level posting is not working in A/P.
> >> > They
> >> > often enter an A/P trx and print a check for it on the fly.  Their 
> >> > usual
> >> > procedure is to post the transaction through transaction level posting.
> >> > In
> >> > the company in question, when the Post button is clicked nothing 
> >> > happens.
> >> > No
> >> > error msg, nothing.  The trx level posting works in all of their other
> >> > companies.  I've checked posting settings, cleared out all of their
> >> > batches,
> >> > nothing works.
> >> > Any help would be greatly appreciated.
> >> > Bill Kersh
> >> 
> 
0
Bkersh (4)
8/17/2007 6:00:01 PM
Reply:

Similar Artilces:

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. Any Ideas???? -- 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
Hi No need to apologise since you were drunk and unaware of what was going on. Regards Roberts ...

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 account were. 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 more invoices. 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- categorize things? Thanks! -Aaron ...

PM Transaction Work vs Open
What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN? Thanks, Steven work = saved open - posted "Steven" wrote: > What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN? > > Thanks, > Steven As an add on, the work also includes recurring transactions. "Doug" wrote: > work = saved > open - posted > > "Steven" wrote: > > > What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN? > > > > Thanks, > > Steven Thanks, Guys! Steven "klewis&quo...

V10 - Transaction by debtor enquiry report
Hi, 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. Thanks Jean -- JB 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 installed? "JB" wrote: > Hi, > > 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. Assessment: 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 *
Hi all 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 FINE 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. Ramesh "Arvin Meyer [MVP]" <a@m.com> wrote in message news:uYrxsSUcHHA.5052@TK2MSFTNGP05.phx.gbl... > 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? -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com 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 happened. You will have to develop a customisation to track it in a parrellel table. (Or use VBA & DUOS table) ------ Robert "Japheth Nolt" <japheth.remove@landiscomputer.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 capability? Thank you very much in advance. allanc (allan.for.g.groups@gmail.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 suggestions? 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 responses. >-----Original Message----- >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?). ...

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
Hola Familia 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 Users\Documents\november.xls]daily",("daily file")) 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 and SAP Hope this helps -- Marc Soester [MVP] http://www.i-pmo.com.au "Reuter" wrote: > 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): https://mbs.microsoft.com/customersource/productsservices/products/articles/111005_tntgp.htm?printpage=false 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! Shauna Shauna 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 bb.Fields.Update Set ll.Configuration = bb ll.Fields.Append "urn:schemas:mailheader:x-message-flag", adBSTR _ , -1, _...