Cannot post sales journal or split journal

Overview

You are unable to post the sales journal to General Ledger or split the journal. You receive the following error:

Error Number  : 5673
Error Message : 5673 : UNABLE TO POST JOURNAL.
Error Source : EACCOUNTING.TOACCOUNTING
Error Method : TBOJOURNAL.POSTJOURNAL

Solution

This issue may be caused by a timed-out SQL statement, as the number of transactions in the journal you are trying to post is too large. To solve this issue you need to follow the steps below:

  1. Open SQL Server Management Studio on your database server
  2. In Object Explorer, connect to an instance of Database Engine and then expand that instance.
  3. Expand Databases, expand the AdventureWorks2012 database, and then expand Programmability.
  4. Right-click Stored Procedures, and then click New Stored Procedure.
  5. Copy the code from the attached file and replace everything in the Query Window.
  6. Navigate to Query > Run to save the stored procedure.
  7. When splitting the journal, please enter the following parameters:
    1. @batch_no - this is the journal number you are trying to split
    2. @tran_no_start - this is the starting transaction number
    3. @tran_no_end - this is the end transaction number.
      For best results, split the journal into 10k transaction chunks

Testing

After splitting the journal directly from the database, the resulting journals can now be successfully posted to General Ledger. If you are still experiencing issues, please contact support.

Attachments

Comments

0 comments

Please sign in to leave a comment.