web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Payment Journal Numbering Issue

(0) ShareShare
ReportReport
Posted on by 266
Hello, 

I initially configured the payment journal number series with Default No = TRUE, Manual No = TRUE, and Allow Gaps = FALSE. This setup caused an issue where journals created on different days were somehow posted under the same journal number.

To resolve this, I updated the number series to Default No = TRUE, Allow Gaps = TRUE, and Manual No = FALSE. This prevents duplicate postings by triggering an error when a journal is posted with a previously used number, prompting the user to renumber.

However, under this configuration, if a user runs Suggest Vendor Payments, deletes some lines, and then attempts to use the Export File action, they receive the following error: "You have one or more documents that must be posted before you post document no. XXX according to your company's No. Series setup."

Additionally, since all payment journals are meant to go through approval, using No. Series and Posting No. Series in the journal template creates a disconnect in the approval entry as there’s no “pre-assigned number” concept, so it’s difficult to trace the approval entry back to the original journal.

Does anyone know how to configure the number series so that it:
  • Allows exporting the payment file
  • Maintains approval history integrity
  • Prevents multiple journals from posting under the same document number

Thanks

Alejandra
 
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 3,048

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,326 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans