eConnect - taGetNextJournalEntry

This short piece of SQL code shows how to use the taGetNextJournalEntry stored procedure to get the next GL Journal number.

taGetNextJournalEntry is a stored procedure that is part of eConnect, and is used internally when you call the 'GetNextJournalNumber' endpoint in eConnect.

But if you know how, it can be called manually as well.

Related Articles

... and you 'll find more on the SQL (Dynamics) Menu

declare @p2 char(13)
set @p2=''
declare @p3 int
set @p3=0
exec taGetNextJournalEntry @I_vInc_Dec=1,@O_vJournalEntryNumber=@p2 output,@O_iErrorState=@p3 output
select @p2, @p3

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences