We would like to have some information on AP reporting.Our requirement are as follows.
1.Ageing analysis not readily available, in one report.Due date analysis is available in the SAP standard report S_ALR_87012078 but we are in need of list of vendors with due amount on a particular due date.
2. We do not have due date payment report, which can be useful to discharge liabilities on due dates. Presently TB is manually tracked and payments made.
3. If we give vendor, statement of accounts in standard form then the vendor does not understand this and finds difficulty in reconciling the accounts from his books. Only open items appear, no opening balance etc get reflected in statement.
Standard Report S_ALR_87012083 gives the open items but as same as FBL1N, so it is difficult to understand by vendor.
4. In statement the net of deduction (i.e. net of TDS etc) gets posted and this make difficulty in reconciliation for the vendor.
5 .Balance confirmation letter not directly getting ready to post from system with profit center option.
Thanks for your time and suggestion.