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.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 |
|---|
|