Account detail via smartlist does not tie to Trial Balance report

(0) Share

Report

Posted on by Mile129

155

I'm trying to get the detail of an account. I ran a trial balance to get the balance of the account yet it seems the balance is not the same as if I take all the debits and credits that go through the account, which I pulled via a smartlist. I need to reconcile these accounts but the smartlist for the account transactions do not add up to be the ending balance being shown via the Trial Balance report. I know not to include the BBF transactions, but besides that what is missing from my Smartlist report that is not coming over? Shouldn't all the transactions that go through the account be shown on the Smartlist if no filters are selected?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

SmartList includes unposted transactions as well as posted. The trial balance includes only posted transactions. Add document status to your smartlist and filter out any 'Work' transactions.

Was this reply helpful? Yes No
Mile129 155 on at

Like (0)

Report
Copy link

Link copied!

It's the default Smartlist under Financial - Account Transactions - *.

It's the Asterisk and I'm looking at just the Retained Earning Account detail. It's showing the same amount over and over for some of the transactions. For example when I look at the account detail via Inquiry under Financial Detail, then the transaction shows all the correct accounts that come out in the Trial Balance Balance show up, but the Smartlist is showing for some transactions the same amount over and over. I believe this is what's an error. This is the default smartlist, the one that comes out of the box.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi

I have the same issue with Account Transactions and Retained Earning Account Detail , IF the same account has multiple lines in the final Year end closing JE, Smart list is repeating the first line Amount for all records. This looks like a bug in the SQL code and it is only showing with Year End entry.

Was this reply helpful? Yes No
Tristan Clores 2,812 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The issue is caused by the BFF transactions not containing the correct SEQNUMBR after YEC was performed.

I recommend running the script below using SQL against the company database:

DECLARE @x int

SELECT @x=0

UPDATE GL20000 set SEQNUMBR=@x,@x=@x+16384

WHERE JRNENTRY=XXXX

**Where XXXX is the account number involved.

Once done, restart GP and verify in Smartlist if the issue persists.

Make sure to make a full backup of the DB prior to running the script above.

Let me know if you have further questions.

Was this reply helpful? Yes No