JE # reverted to old number used...

(0) Share

Report

Posted on by Community Member

I went to create a journal entry for the August admin fees. When I go to enter it, GP is assigning JE#29,891 to my entry. But last month, July’s admin fee was JE#39,563. In the past, the JE entry number for a subsequent entry would be sequentially a higher number.

Out of curiosity, I went into JE Inquiry for the JE#29,891 that GP wanted to assign to my entry. That JE was used back in November, 2014.

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: JE # reverted to old number used...

Go to Tools->Setup->Financials->General Ledger and set the next J/E number to what it is supposed to be. You may want to restrict access to this screen. As per Sanjay, you can run this script in SSMS to get the next J/E number.

Run this script against company db

select MAX(jrn) + 1 as jrn from (

select MAX(jrnentry) as jrn from GL10000

union all

select MAX(jrnentry) as jrn from GL20000

union all

select MAX(jrnentry) as jrn from GL30000

) as t

Take note of the journal number. Update the next journal number at GL setup.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: JE # reverted to old number used...

Thanks Richard,

I'm pretty new to this, that script, What is it doing? and also are there any areas in which I would need to change to script?

Thanks!

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: JE # reverted to old number used...

The script looks at the unposted, current year and historical ledger tables to find the highest existing j/e number. You would set your next number to be one higher. Just run this against the company in question.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: JE # reverted to old number used...

Hi,

Just as an aside, GP will let you reuse a journal entry number if the transaction date is in two different years. Also, the same journal entry number is assigned to reversing transactions and entries in recurring batches.

Kind regards,

Leslie

Was this reply helpful? Yes No