Where there are only 2 unrolled years in the General Ledger > Configuration > Setup form, running the Trial Balance report, GLMGT300 - Trial Balance .rpt for NEXT YEAR period 12, an displays are incorrect date is displayed at the top of the report. (Usually 13 Mar 1905).
Image Added
Solution
...
| Warning |
|---|
| title | SQL skills are required |
|---|
|
A working knowledge of SQL Studio Management is required to complete this task |
Download and apply the attached script to the database to correct the report.
| View file |
|---|
| name | ufn_Jiwa_GL_PeriodEndDate.sql |
|---|
| height | 250 |
|---|
|
Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | J7UG |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label in ("general_ledger","trial_balance","report") and type = "page" and space = "J7UG" |
|---|
| labels | general_ledger trial_balance report |
|---|
|
...