Error: Transactions with invalid account numbers

Checkout and Recalculate

Issue

A transaction has an invalid account number. 

Explanation

A transaction has an invalid account number or is missing an account number. Each transaction must be linked to a valid account number. 

Solution

To fix this error, 

• replace the invalid GL account with a valid GL account (Modify Journal Amounts), or

• reformat the invalid GL account number (Recalculate), or

• replace the unformatted account with a formatted account number (Recalculate). 

 

Editing a transaction to replace an invalid GL account

Use Modify Journal Amounts to replace an invalid GL account with a valid GL account or add a valid GL account to a transaction that is missing a GL account.  

Do this...

1. Open Connect General Ledger > Journals > Modify Journal Amounts.

2. Use the information on the Checkout report to select the journal and period for the transaction with the invalid or missing GL account and then click OK.

Journal Options

3. Enter the transaction date.

4. Enter the reference number.

5. Enter a valid GL account.

Account field in Modify Journal Amounts

If you're not sure if your using a valid GL account, you can use Search to look up and select a GL account.

Using the Search option from the Account menu

6. Click Save (CTRL+S).

The transaction is saved with a valid GL account.

2019.11, 2019Aug21

Reformatting account numbers

Transactions store GL accounts as formatted numbers that do include non-alphanumeric characters such as dashes (-), periods (.), parenthesis (()), and so on.

Do this...

1. Open Connect General Ledger > Organization > Recalculate.

2. Set up the Selection Criteria to select the accounts with formatted account numbers.

 

3. Click to select the checkbox titled Reformat Account Numbers.

4. Click GO (CTRL+G).

Connect uses the account header mask to replace instances of the unformatted account with a formatted account.

2019.11, 2019Aug21

Replacing formatted accounts with unformatted accounts

Tables in the General Ledger app store GL accounts as unformatted numbers that do not include non-alphanumeric characters such as dashes (-), periods (.), parenthesis (()), and so on.

Do this...

1. Open Connect General Ledger > Organization > Recalculate.

2. Set up the Selection Criteria to select the accounts with formatted account numbers.

 

3. Click to select the checkbox titled Replace Account Numbers.

4. Click GO (CTRL+G).

Connect replaces instances of the formatted account with an unformatted account.

2019.11, 2019Aug21

 

Copyright © 2020 Caselle, Incorporated. All rights reserved.