create a report -
Selection screen should have the following fields -
1- Company Code (BUKRS)
2- Customer - KUNNR
3- Posting Date - BUDAT
Output of the report is attached.
Report Function Details
Fetch all Invoice Documents from table BSAD with Document type RV,Company code Customers as per the selection screen, filter those Invoice documents based on Reconcilaition G/L account for Government Customers (450000) from Field SAKNR in table BSAD, for date range mentioned in the selection screen.
For all selected invoices check invoice amount and the clearing document Amount is equal. Display only those invoice documents, where Invoice Document Amount is not equal to Clearing Document Amount.
If the difference of payment amount is Due to Bank fees, should not be considered as short paid and should not display in report.
To Identify Bank fees, Check Clearing document has a separate line item with bank G/L ‘6819000 in table ACDOCA, if the difference amount is equal to bank fees, invoice should not be considered as short paid. If the difference of payment exceeds bank fees, should be treated as short paid and only invoice needs to be displayed in report.
Report should have the option to drill down to display Invoice document, Customer Master, when click on those fields. Report should be in interactive ALV format and should have the option to download it to Excel.