Difference between revisions of "Information Systems:AR Detail Report"
Jump to navigation
Jump to search
(Created page with "A special type of A/R report was created (upon shareholder request) to provide a list of A/R transactions broken down to the item level. The utility is called IN2_ARCUST.PGM i...") |
m |
||
| Line 1: | Line 1: | ||
| − | A special type of A/R report was created (upon shareholder request) to provide a list of A/R transactions broken down to the item level. The utility is called IN2_ARCUST.PGM in Infonet. The query logic behind this report attempts to simulate the business logic that runs when the system produces an invoice, because this data is not logged to the database (rather, it is calculated ad-hoc during invoice generation). As the report is recalculating data and working around the limitations of not having the actual data to work with, this page details the caveats and flaws of this report. |
+ | A special type of A/R report was created (upon shareholder request) to provide a list of A/R transactions broken down to the item level. The utility is called IN2_ARCUST.PGM in Infonet. The query logic behind this report attempts to simulate the customized business logic that runs when the system produces an invoice, because this data is not logged to the database (rather, it is calculated ad-hoc during invoice generation). As the report is recalculating data and working around the limitations of not having the actual data to work with, this page details the caveats and flaws of this report. |
==Files== |
==Files== |
||
| − | These are the files implicated in the query in order to be able to |
+ | These are the files implicated in the query in order to be able to produce the desired results: |
| − | * Invoice lines (for items) |
+ | * Invoice lines (for items) from SROISDPL. |
| − | * Surcharge invoice lines |
+ | * Surcharge invoice lines from SROISDSU. |
| − | * Admin fee invoice lines |
+ | * Admin fee invoice lines from SROISA. |
| − | * The tax amount and discounts for invoice lines are logged to UZIVLIL1. This is a custom table that presumably was too close in proximity to base functionality |
+ | * The tax amount and discounts for invoice lines are logged to UZIVLIL1. This is a custom table that presumably was too close in proximity to base functionality that it was put in the ASW library (UP1480BFVA) instead of UWDASWPRDD. |
* AR transaction lines are stored in SRODTA. |
* AR transaction lines are stored in SRODTA. |
||
Revision as of 15:30, 7 February 2019
A special type of A/R report was created (upon shareholder request) to provide a list of A/R transactions broken down to the item level. The utility is called IN2_ARCUST.PGM in Infonet. The query logic behind this report attempts to simulate the customized business logic that runs when the system produces an invoice, because this data is not logged to the database (rather, it is calculated ad-hoc during invoice generation). As the report is recalculating data and working around the limitations of not having the actual data to work with, this page details the caveats and flaws of this report.
Files
These are the files implicated in the query in order to be able to produce the desired results:
- Invoice lines (for items) from SROISDPL.
- Surcharge invoice lines from SROISDSU.
- Admin fee invoice lines from SROISA.
- The tax amount and discounts for invoice lines are logged to UZIVLIL1. This is a custom table that presumably was too close in proximity to base functionality that it was put in the ASW library (UP1480BFVA) instead of UWDASWPRDD.
- AR transaction lines are stored in SRODTA.
Query Logic
Trying to recreate data and simulate application logic using query logic will be prone to error. These are some of the potential issues regarding this report.
- Invoices and credit notes are kept in the same file, but with positive values. Another field - invoice type - determines whether the value should be positive or negative.
- Discounts are calculated during invoice generation according to terms code and invoice. The discount amount for the invoice line is logged to UZIVLIL1, but if a line follow.