Problem
Running the report REINF010 - Receival Slips Uninvoiced is incorrectly including reversed and reversal GRN's.
Solution
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 91fbcd9b-5d0b-3b97-a585-1a06ec62a231 |
|---|
| key | DEV-5192 |
|---|
|
| Warning |
|---|
| title | SQL skills are required |
|---|
|
A sound knowledge of SQL is required to complete this task. |
A modified report and stored procedure is attached to the article to the that excludes reversals from the report. This correction has been included in 7.01.00 and higher
| Panel |
|---|
|
Download and save the attached stored procedure and report and then
- Run the SQL script over the relevant database
- Run stored procedure Grant_All_User_Tables
- Login to the database
- System Settings > Report Configuration > Reports
- Click Refresh from Files
- Select the report to be imported and OK
- Message displays to indicate report has been successfully updated
 Image Added
NOTE: If you get the error 'Database vendor error code 229 ...' when running the report, then step 2 has been missed. |
| View file |
|---|
| name | REINF010 - Receival Slips Uninvoiced.rpt |
|---|
| height | 250 |
|---|
|
| View file |
|---|
| name | usp_JIWA_Receivals_ReceivalSlipsUninvoiced.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 ( "grn" , "reports" ) and type = "page" and space = "J7UG" |
|---|
| labels | GRN reports |
|---|
|
...