Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have an Excel spreadsheet that I entered my debits and credits information into.
When I copy and pasted into the General Journal Entry screen in GP all the line fill in, but the totals on the bottom of the screen don't add up.
Rounding in excel? Have you checked the actual numbers?
Use the rounding feature in Excel, that should solve your problem.
There was nothing to round. I typed the numbers into the cells in Excel.
How much is it off? Can you tie the numbers out?
The entry was:
The total of debits = 599.00
The total of credits = 249.00
Even though all the lines are there.
Can you print an edit list for this journal entry? Are all the accounts active?
All accounts are active. I was able to print an edit list and that looked fine.
The journal entry screen is still out of balance for the totals.
30604-503488 1000-000-000-0000-20010-00000 599.00
30604-503488 9999-000-000-0000-24016-00000 99.00
30604-503488 9999-000-000-0000-24010-00000 200.00
30604-503488 1000-000-000-0000-24015-M1100 75.00
30604-503488 3000-000-000-0000-24015-M1300 75.00
30604-503488 9999-000-000-0000-24015-M1400 75.00
30604-503488 2000-000-000-0000-24015-M1200 75.00
My guess is that this is because of a decimal place issue. Try rounding in Excel first and then do the paste again.
Lynne stated above that she manually entered the amounts.
I also tried to round in Excel and it didn't help.
I would delete this transaction and the batch it is in. Also, go into SSMS and make sure this batch does not exist in the SY00500 table. Another simple test would be to create a new batch and a new journal entry.