Suspense account question

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have some entries the G/L suspense account and need to reclass them. I have tried to do a journal entry but it will not allow me to use the account number without the subaccount. Account validation is unchecked. We are using Version 9.

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Suspense account question

Kimberly,

When a suspense account posting is created, it typically inherits the sub-account from the original transaction so I am wondering if the sub-account is possibly a space as opposed to being a true blank. If you open subaccount maintenance, does it have a grid row with what appears to be a blank subaccount value? If so, it might be that you have a sub-account defined as a single space.

Did you run down the reason/origin of the suspense account posting? If so, you might want to look at the module batch details to see if there was a valid sub-account in the module transactions.

You could run the following query to determine if the actual sub-account contained one or more blanks:

select sub,len(sub) from accthist where acct = '000000'

the second column will tell you how many characters were in the sub-account field.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Suspense account question

The entries to the suspense account are being created by SL without the subaccount.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Suspense account question

Kimberly,

Any JE must have an account from the chart of accounts and a sub-account from the sub-account list. Account validation checks the combination of the account and sub-account against the defined valid combinations. Not having that option enabled does not allow you to utilize an account not in the chart or a sub-account not in the sub-account list nor does it allow you to leave either of these fields blank.

I am curious as to why you are trying to leave the sub-account field blank. When you re-class these postings I would think you want to take the amount out of the suspense account / sub-account combination that it hit and move it to a valid account / sub-account.