Thomas Hill
Forum Replies Created
-
At end of December. the AP Trial Balance did match to the G/L balance. The balance sheet report of the A/P-Trade Account did not tie. I had voided a check. When that transaction was posted to the balance sheet, Great Plains ‘tagged’ the DEBIT part of the transaction AS VOID. Marked as VOID it was not included on the balance sheet print-out.
In looking at the General Journal Posting Report from the sub-ledger there was no indication of that line being VOID. When I viewed the journal entry in the table GL20000, I saw the VOID flag. My system can only VIEW the tables. The FIX was by our GP Admin, who changed the VOID flag to 0. I think we had 3 such occurrences for VOID CHECKS.
We are running the most recent GP2018.
-
@WinthropDC Thanks for those table references. You do not happen to know if there is a GL_table with fields for the JRNENTRY and the BATCHNUM from the module? GL20000 does not have it as such.
-
When I joined this company they were on GP2010, then upgraded to GP2015. Everything has been detail posted during the time. We upgraded to GP2018 to start January. Reviewing the data, the detail was posted until mid-month. Then a change put it at summary. January finished in summary and all of February has been summary posted. There was a change from GP2015 to GP2018 on the posting parameters. Automatically posting payables and receivables to the general ledger did not work as the settings from GP2015 were.
-
I am going to say that I do not think any modifications have been made to the form. The general rule of thumb is to not change anything that is working.
The process changed on this one, putting the quantity to order and the extended total price so that GP2018 backfills the unit cost. When we upgraded to GP2018 in January (for the new year). It was an upgrade. I suggested that the number of decimal places on purchase order / inventory items be expanded to 4-decimal instead of 2-decimal. So many of our vendors are doing this now.
Can that be expanded at any point?
-
I think you might be correct, accidently of course. It happened in Jan2025, the first month we went live with GP2018, upgrading from GP2015. Mid-month of January some of the settings were changed from posting all detail to the balance sheet accounts for AP Trade and AP Accrual, to posting in summary.
When I post, the various reports post to a text file, not to paper. In all of the years, never any posting issues. I was the one posting. The posting to the general ledger should have been held as out of balance and not posted. But it went through. I received no warnings of being out of balance.
I have seen (in other software programs) posting the out of balance difference to a SUSPENSE ACCOUNT to be cleared from there. It was a strange event. Fixing it was stranger as well.
Running the Financial Trial balance now may give unusual totals for the accounts that were used in the original journal entry.
-
Exactly as it shows on this printed report. To fix it the GP Administrator had to delete the exactly transactions, and then enter the Journal entry manually.
It was also strange that this originated as a batch in Payables. But when it posted GP2018 split it into two journal entries, with the larger one missing a part to be out of balance.
I thought it strange. I have imported a journal entry that I had not balanced in my off-system app. GP2015 always caught me. I have not done this since migrating to GP2018.
We do not print the various posting reports to paper. But to a file.
