Journal Entry Batch has duplicate lines

Ferdie Alayon
Ferdie Alayon
Seventh Anniversary Kudos 2 Name Dropper Participant
in Blackbaud Financial Edge NXT® General Discussions

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.

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @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
    Ferdie Alayon
    Seventh Anniversary Kudos 2 Name Dropper Participant

    @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
    Ferdie Alayon
    Seventh Anniversary Kudos 2 Name Dropper Participant

    @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
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @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
    Ferdie Alayon
    Seventh Anniversary Kudos 2 Name Dropper Participant

    @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
    Doris Donovan
    Name Dropper First Anniversary Facilitator 1 September 2024 Monthly Challenge

    @Ferdie Alayon mine duplicate when I validate a report

  • Ferdie Alayon
    Ferdie Alayon
    Seventh Anniversary Kudos 2 Name Dropper Participant

    @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
    Name Dropper First Anniversary Facilitator 1 September 2024 Monthly Challenge

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

Categories