4Site
Support Request System
View Patch #50.008.012
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02085 -
Trial balance is out by 0.01
Symptoms:
1. The original problem was that the Trial Balance was out by a penny. 2. The year end adjustments were showing on the Trial Balance 3. Can't enter Year End Closure JV - get an error that the number of columns doesn't match. This happens on the Retained Earnings line 0.
Solution:
NOTE: this patch is required by anyone who gets patch 50.003.001 Patch 50.003.001 added 2 new columns to the jvline table. The code in clsJVYE.cls to insert jvline was changed in one place but not the 2nd place (the add of the retained earnings line 0) 1. Currently the following is true: - transactions go to 6 decimal places. - Actotals is rounded to 4 decimal places. - The Year End Closure JV is rounded to 3 decimal places but since the actotals are alread rounded to 4 that rounds yet again. - The Year End Adjustment JV can only be entered as 2 decimal places so it's rounding doesn't matter so it's OK. The actotals will be updated as 6 decimals. The Year End JV will be created as 6 decimals as well. 2. There have been several changes to process the Year End Adjustments and Closures on the Trial Balance. The previous change was done to the code to check their 23:58 time correctly. However, the #Trial proc was still including period 99 if you queried the first period of the year so they in effect were included twice. Now, if the period requested is a specific period, it just gets the actotals balance for the period requested. If the period requested is yyyy00 then it gets the period balance as the whole year - eg. 200700 to 200712 (or 200713). The AC program filters out the rest as it did before. 3. I added the 2 missing columns in the Year End Closure JV code (clsJVYE in InsertJvLineZero)
Browse Patches
Find a Patch
Return to Request System Menu
