Error: - Finance - Message - You have one or more documents that must be posted before you post document no. XXXX

Error message whilst trying to post a general journal.

Issue

A general journal has been fully prepared with all lines ready but not immediately posted.  Later, the journal posting is revisited to complete it but it will not post stating the following error message:

You have one or more documents that must be posted before you post document no. XXXXX

Why?
The system has automatically set the Document No. for you as defined by the systems No. Series function. It allocated the next available Document No. & added it your journal. Then, you or another user creates another journal & posts it with the same Document No.. The Doc. No. on your un-posted journal is now a lower number than the last used Doc. No. recorded in the No. Series.

E.G.

Journal line made with a Doc. No. ending in 118 but the No. Series controlling the Doc. No. allocation has now moved on to 120

Resolution

If there are only a couple of lines on the journal, just make a new one & the latest available Doc. No. will be added to the journal by the system.

If there are many lines & you don't wish to recreate it, you could do one of the following depending on permissions available.

Steps

1. Look in General Ledger Entries & find the last used Document No.
   
2. Open the No. Series configuration & look for the last used Document No. (not recommended)
   

1.

Open General Ledger Entries

Tell me what you want to do

Apply a filter to the Document No. field & then sort it 'Descending'.

Why don't you save the filter for use later?
Will be available in all companies.

Note the highest Doc. No. posted & then set your journal to use the next number e.g. 118

2.

Open the No. Series setup & look for 'Last No. Used'

This is not recommended & is not without risk.

Your permissions may prevent access.

v0.03, MPE, 08/11/2022

• Related Articles

• Correction: Intra invoicing - indentify part posted intra documents &or post additional intras.

  How to identify part posted or partly corrected intra invoice documents in Navision. Issue Intra invoices are always made in pairs. Accounting can't complete their monthly VAT tasks due to unbalanced general ledger entries as a result of a User not ...

• Ref.: - Message - Quantity Received must be 0 in MBP Ref No. No.=000-123456

  Problem trying to receive & ship a direct delivery ref. where the Quantity Received has a value on the Ref. General tab. Issue Navision function Actions -> Receive Purchase/Transfer results in an error message: Checking the General tab shows a value ...

• Ref.: - Message - Item <any item code> is not on inventory

  Problem trying to receive picked up inventory from Transit. Issue Navision function Actions -> Receive Purchase/Transfer results in an error message: Checking the General tab shows a value in Quantity Received. Checking the Receive/Ship tab shows a ...

• Variable Pricing Error Message

  There may have been times that a Contract has been changed from a Purchase to a Sales when there are already line items present. This scenario can cause knock on affects. One such instance is when creating a variable price on the Contract. Error ...

• Contract: Message - NAV Contract No. must have a value in Contract Header

  Issue The system is prompting for a Nav. Contract No. when you make a new contract in Business Central. Resolution Working in Business Central 'Live' or 'Prod.' (e.g. 200) The Production companies e.g. Solutions may be configured to require data in ...