nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Journal Entry Batch has duplicate lines

Ferdie Alayon

I only found out about this when I exported batch details to Excel. Export file had more than 2,000 lines when the expected record count was about 100 lines.

For the first screenshot below showing account 01-2010-0000, amount was $354.94 and only project ID 15 was used. However, it shows three proj. 15 lines with the same amount. Not sure where the duplicate lines came from. GL balance for 01-2010-0000 was correct.

6384ee76dafcef938780ccaf07b5cf6e-huge-ca

For the next screenshot, there were multiple project IDs involved but notice duplicate lines for projects 27 and 23.

2ac6eca0a48bf8ed122ddbb292c16734-huge-ca

Thanks in advance for your help.

Find more posts tagged with

Comments

Kevin Brazell

@Ferdie Alayon it looks like the extra lines are the break out of the otherside of the entry. I"m assuming expense accounts based on the liability account in your images. Go to the transaction that made these and visually verify the distributions. I'd expect, 3 breakouts, in this case I'm thinking accounts and it's the same project on all of them.

Ferdie Alayon

@Kevin Brazell thanks for your reply.

This particular entry is to post a payment batch.

It has a debit to liability and a credit to cash for the same amount and same project ID.

It was working perfectly through end of June but all my July batches had the same errors of duplicate lines affecting both liability and cash accounts.

Ferdie Alayon

@Kevin Brazell this one's from this week's batch so the issue continues in August. It correctly shows 30 transactions.

765cfdd43be3be113577f334c6f9f9ed-huge-ca

However, export file shows 2,218 detail lines.

fab0068d05d143b542ea17ff7f52d6bc-huge-ca

Kevin Brazell

@Ferdie Alayon Then I would check the invoice(s) distributions. Depending on your accounting funds setups and requirements, it may be pulling the projects over from the Invoice.

Ferdie Alayon

@Kevin Brazell
I did check and everything is in order. Individual AP invoice transactions have correct distributions and number of lines.

GL postings don't show duplicate transactions. Bank reconciliation is complete and aged AP report matches trial balance.

Exporting JEs is a routine task for us to assist in project ID reconciliation. It's just weird why we suddenly have this issue in July.

Doris Donovan

@Ferdie Alayon mine duplicate when I validate a report

Ferdie Alayon

@Doris Donovan I just exported two files to Excel. The issue has been fixed.

As far as validation is concerned, I didn't notice any issues. I have control totals and they always match the validation report.

Doris Donovan

@Doris Donovan that does seems to be the time that happens