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 |
|---|
|
| Page Properties |
|---|
|
Related issues |
|---|
| Related issues | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 91fbcd9b-5d0b-3b97-a585-1a06ec62a231 |
|---|
| key | DEV-7624 |
|---|
|
|
|---|
|