journal entry number error :
input variable contains a duplicate journal entry number (JRNENTRY) number in General Ledger - ( GL10000- GL20000)
This is my one of the client facing this error.He is using GP 10.0 version.
how can i duplicate this error on my system.and let me know how can i solve this…
Run this script against company db
select MAX(jrn) + 1 as jrn from (
select MAX(jrnentry) as jrn from GL10000
select MAX(jrnentry) as jrn from GL20000
select MAX(jrnentry) as jrn from GL30000
) as t
Take note of the journal number. Update the next journal number at GL setup.
Sanjay Kumar Rajarao. ACA, MCPhttp://www.sanjaykumar.us | email@example.com
Thanks for your reply...i need to duplicate this error in my system. Let me know how can i do....
Sanjay's reply will get you the maximum journal entry plus 1 in all three ledger tables. Now if you want to replicate the error, go into ledger setup and set the journal number to something lower than what Sanjay's query returned. The question is why do you want to do this? It will not post and may not allow you to enter it at all. It should sense it is a duplicate journal entry number. I think it would be more important to remove this error from your client's database. I would look for gaps in the journal entry sequence and then fill the gap. Which table contains the duplicate? If it is the GL10000 just delete it from the batch and re-enter it making sure your next journal number in GL setup has been set correctly.
Richard E. Wheeler 2013 MVP
MS Dynamics GP Support
www.rbsolutions.com Revered Business Solutions Ballston Lake, NY 518-877-0763 x10
Thanks Richard for explation,
I have used taGetNextJournalEntry stored procedure to get next journal entry number. But i am getting number that is already exist. so what i did , After getting journal entry i am checking in GL10001 Table. If it is already there in this table so again am calling ' taGetNextJournalEntry ' to get next number , until i find new number i am calling the stored procedure. Using this process am not getting any error.
But one of the client system getting journal entry number error.
Let me know am i doing correct way to get next journal entry number. If not what is the best way to get journal number.
" It will not post and may not allow you to enter it at all. It should sense it is a duplicate journal entry number"
but it obviously has posted if the client has it in their dbase. Yes GP should sense the error, but it has not.
that makes replication very difficult.
as a user I want to hear my VAR say do this this and this and you get the error, so that I know what not to do again.
as a former VAR the expectation is that you are an expert on everything. VAR's certainly charge as if they are.
Not knowing how this happened then is a hard thing to tell your customer. I would expect it of my current VAR.
Not necessarily. What if someone did a back-end correction and just changed a journal entry number or had errant custom code that dumped records into the GL20000 or GL30000 table? There would be two ways to do this. The first is the script you provided and the other would be to go to the GL setup table and get the next J/E number and then increment it. Now if someone has access to the GL setup screen and sets the number back, you have a problem.
Just as a side note - A journal entry number is duplicated if you are using a recurring batch or creating a reversing entry. You can also duplicate a JE without error if you are posting a transaction to history, and that JE number already exists in the history table. Seems like there is another scenario, but I can't think of it right now.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics