Problem
The Transaction History tab of inventory incorrectly reported unactivated Reversals. Only 'Activated' Reversals should appear in this tab.
Solution
| Warning |
|---|
| title | SQL skills are required |
|---|
|
A working knowledge of SQL Management Studio is required to complete this task. This solution applies to 7.2.1 and older. |
Download and apply the attached stored procedure to the database to correct the information that appears in the Transaction History tab of inventory
| View file |
|---|
| name | usp_JIWA_QuantityAsAt - DEV-7790.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 ( "transaction_history" , "inventory" , "inventory_maintenance" , "grns" , "goods_received_note" ) and type = "page" and space = "J7UG" |
|---|
| labels | transaction_history GRNs goods_received_note inventory_maintenance inventory |
|---|
|
| Page Properties |
|---|
|
Related issues |
|---|
| Related issues | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 91fbcd9b-5d0b-3b97-a585-1a06ec62a231 |
|---|
| key | DEV-7790 |
|---|
|
|
|---|
|