Hi,
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.
Any suggestions?
Lynne
*This post is locked for comments
I found that if one of your accounts is a fixed allocation account, GP messes up the sum of debits and credits.
For me it excluded the debit or credit from the previous line and the debit or credit from the fixed allocation account line.
This was GP2013 R2.
To get around it, I replaced my account with posting account. Then after the paste, I manually changed it to the fixed allocation account.
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.
I also tried to round in Excel and it didn't help.
Lynne stated above that she manually entered the amounts.
My guess is that this is because of a decimal place issue. Try rounding in Excel first and then do the paste again.
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
Can you print an edit list for this journal entry? Are all the accounts active?
The entry was:
Debit 599.00
Credit 99.00
Credit 200.00
Credit 75.00
Credit 75.00
Credit 75.00
Credit 75.00
The total of debits = 599.00
The total of credits = 249.00
Even though all the lines are there.
How much is it off? Can you tie the numbers out?
There was nothing to round. I typed the numbers into the cells in Excel.
Share
Report
All responses (
Answers (
15
