...
Running the report REINF010 - Receival Slips Uninvoiced is incorrectly including reversed and reversal GRN's
Solution
| Warning |
|---|
| title | SQL skills are required |
|---|
|
A sounds knowledge of SQL is required to complete this task. |
A modified report and stored procedure is attached to the article to that excludes reversals from the report.
| Panel |
|---|
|
Download and save the attached stored procedure and report and then
- Run the SQL script over the relevant database
- 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
|
| View file |
|---|
| name | REINF010 - Receival Slips Uninvoiced.rpt |
|---|
| height | 250 |
|---|
|
| View file |
|---|
| name | usp_JIWA_Receivals_ReceivalSlipsUninvoiced.sql |
|---|
| height | 250 |
|---|
|
Related articles
...