You’re offline. This is a read only version of the page.
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
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,
Hi Kavita
Check this out.
http://www.sanjaykumar.us/index.php/econnect-getnextdocnumbers-class-vb-net-example/
Cheers!
Sanjay
Mr. Steve
How could we get such details regarding encrypted stored procedures ?
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.
That's an encrypted stored procedure, therefore, the CREATE function cannot be scripted.
I believe this piece of information is not accessible.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (