Understood that there's a sequential PSTGNMBR (Posting Number) assigned to each posted JRNENTRY, under what circumstance that there's a gap in the PSTGNMBR?
i'm observing 2 Gaps at least in the entire GL20000 table. Though running the Reconcile Posting Numbers can help close the gap, I'd need to know what could have caused the Gap in the first place, to answer an audit finding.
Thanks n cheers.
*This post is locked for comments
HI Richard,
Thanks for the suggestion. In fact the Posting Number was indeed enabled for this company due to this Audit Requirements. But unfortunately there were still gaps within this "solid numbering" and we got to answer why.
Thanks and best regards,
Ivan
Hi Victoria,
Thanks for the reply. In fact that's what i was trying to find out, "what went wrong" that caused the gap.
Thanks and best regards,
Ivan
Enable Posting Numbers in General Ledger Mark this option to assign each transaction a unique sequence number during posting, in addition to the journal entry number. Use this option if you want solid numbering of transactions, without gaps. Solid numbering is a legal requirement in some countries, for auditing purposes.
Hi Ivan,
This is not a setting I have ever seen used in an implementation of GP. I suspect this is true for others, as well, so that most likely accounts for the lack of responses you are getting to your actual question. :-(
Based on the description of the functionality for Posting Number in the help files, I would suspect that something went wrong during posting to cause a gap in the numbers. But without ever having seen this before, it's hard to say for sure if there are other things that may cause this. If this is important, it may be worthwhile to start a support incident with Microsoft to get more concrete information.
Hi GURURAJ,
Within the sequence of Posting Number, the SOURCDOC is all 'GJ'. But there are other SOURCDOC as well in the entire range of Posting Number.
An example is as below.
JRNENTRY PSTGNMBR
14485 35423
14486 35424
14488 35426
14489 35427
14490 35428
Thanks and best regards,
Ivan
Hi Iva,
May i know the value of SOURCDOC field of GL20000 table. Is it same for all the records where you are finding the gaps? Can you paste some sample records in your next post?
Hi Tristan,
The PSTGNMBR field is used when you set "Enable Posting Number in General Ledger" in Company Setup.
For this case here, the posting number is already enabled for this company, and the running sequence of the Posting Number had a gap hence I'm wondering what could have caused the gap.
Thanks and best regards,
Ivan
Hi Ivan,
I believe the PSTGNMBR field is not used as of yet. The sequential field in the GL20000 table is the SEQNUMBR - which is sequenced by 16384.
Please let me know if you have further questions.
Hi Mahmoud,
thanks for the script for checking gaps in Journal Numbers.
However, my concern here is the Posting Number (PSTGNMBR). Regardless of the gaps in Journal Numbers, each journal will be assigned a sequential Posting Number during posting. The highlight here is there's gap in the Posting Number sequence, which is strictly system controlled and not user-amendable.
Thanks and best regards,
Ivan
There might be un-posted journal entries in [ GL10000 ] Transaction Work, therefore, you need to check the serial in both tables [ GL20000 ] and [ GL10000 ].
In case you still have variances, you might need to check whether the "Next Journal Entry" number has been changed from ( Tools > Setup > Financial > General Ledger ), which might obviously cause gaps if used every now and then
Please consider the script below as it might help you find out your Journal Entry Gaps precisely;
Tables:
SELECT Row_ID, JE_Status, JRNENTRY,JRNENTRY+JE_Gap AS Next_Journal_Entry, JE_Gap FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY JRNENTRY ASC) AS Row_ID,
JE_Status,
JRNENTRY,
COALESCE(
(
SELECT TOP 1 JRNENTRY
FROM
(
SELECT DISTINCT X.JRNENTRY FROM
(
SELECT JRNENTRY FROM GL10000
UNION ALL
SELECT JRNENTRY FROM GL20000
UNION ALL
SELECT JRNENTRY FROM GL30000
) AS X
) AS Y
WHERE Y.JRNENTRY > B.JRNENTRY
ORDER BY
JRNENTRY ASC
), 0) - B.JRNENTRY AS JE_Gap
FROM
(
SELECT DISTINCT A.JE_Status,
A.JRNENTRY
FROM
(
SELECT 'Work' as JE_Status, JRNENTRY FROM GL10000
UNION ALL
SELECT 'Open' as JE_Status, JRNENTRY FROM GL20000
UNION ALL
SELECT 'History' as JE_Status, JRNENTRY FROM GL30000
) AS A
) AS B
) AS F
WHERE F.JE_Gap <> 1
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (