...
Creditor Sourced Purchases were being excluded from this report.
Solution
| Panel |
|---|
bgColor | #fff| Warning |
|---|
| title | SQL Management Studio required |
|---|
|
A working knowledge of SQL Management Studio is required to complete this task |
Download the two attachments and:
- apply the stored procedure to the relevant database; and
- import the updated report using Refresh from Files from System Settings > Report Configuration > Reports
| View file |
|---|
| name | usp_Jiwa_Creditors_InvoicesOutstanding.sql |
|---|
| height | 250 |
|---|
|
| View file |
|---|
| name | CRTRN050 - Outstanding Creditor Invoices.rpt |
|---|
| 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 ("reports","report","creditor_transactions","creditor") and type = "page" and space = "J7UG" |
|---|
| labels | report reports creditor_transactions creditor |
|---|
|
...