Microsoft Dynamics GP (Archived)

How taGetNextJournalEntry stored Procedure giving next Journal entry number

(0) Share

Report

Posted on by kavitha B

790

When we call the stored procedrue taGetNextJournalEntry , It is giving next journal entry number.

let me know is this checking internally in GL10000,Gl20000,GL30000 tables before returning next value.

Thanks!

kavitha

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

That's an encrypted stored procedure, therefore, the CREATE function cannot be scripted.

I believe this piece of information is not accessible.

Was this reply helpful? Yes No
kavitha B 790 on at

Like (0)

Report

Yes, your correct. This is encrypted . But i need to know that how the value is coming....

Was this reply helpful? Yes No
steveendow 2,281 on at

Like (0)

Report

Hi Kavitha,

The taGetNextJournalEntry procedure retrieves the next JE number from GL40000, and it then checks the following tables to determine if the next JE number is in use:

GL10000

GL10100

GL20000

It does not check the GL30000 table.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Mr. Steve

How could we get such details regarding encrypted stored procedures ?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Kavita

Check this out.

http://www.sanjaykumar.us/index.php/econnect-getnextdocnumbers-class-vb-net-example/

Cheers!

Sanjay

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

I have an issue using the same procedure. When I call the procedure into a Transaction from stored procedure (begin and rollback/commit transaction), to create many journals, apparently for any reason the number return it (journal entry number) is not correct. This not happens ever. But if I get into the window 'journal entry', that window suggests the same number that the procedure returned, with detail information on it, as the next number for this transaction.

Have you any idea that what happens?

It's like if the procedure has not updated the last number used or something like that.

Best >Regards,

Was this reply helpful? Yes No