4Site
Support Request System
View Patch #50.028.024
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02659 -
GL may not balance after year end JE
Symptoms:
The actual problem was that acperiod was not set up for year-end adjustment in the data base procedure for posting journal entries, so it failed since it could not get supplier stats for a null period. Asset totals had the same problem. The above problem manifested when a user attempted to enter a year end Journal Entry. One of the accounts chosen was a supplier payable account, so received an error because the account was sub-ledgered by supplier. The user entered a different account and the entry was accepted. Further analysis revealed that although the first attempt did not create a JE, it did create the adjustment to retained earnings.
Solution:
In application code (JVPOSTSU.FRM) enforce condition to prevent update to actotals if, during a journal entry post, the #jvpost stored procedure returns an error, In stored procedure, - add condition to update supplier stats only if jvhdr.jvtype is not - "Y" (Regular year-end closure) - "R" (Year-end adjustment to retained earnings created by 4Site) - in subroutine ValidateFiscalPeriod: - revise condition to validate year-end JEs only if jv type is not "Y" or "R" as above. Validate if jvtype is "F" (year end adjustment entered by user)
Browse Patches
Find a Patch
Return to Request System Menu