Vendor Liabilities Ageing Report

  • The monetary controller of the Purchasing-A/P module
  • This report is used to assist with determining all the money owed to your Vendors and how long it has been owed
  • To generate this report, select Business Partners -> Business Partner Reports  -> Aging –> Customer Receivables aging “or” select Financials  ->  Financial Reports -> Accounting  -> Aging
  • You may run this report either by your Vendors or by your Buyers

 

If you would like to run by Vendors, check the Vendor option as shown below:

 

 

 

 

 

 

 

 

 

If you would like to run by Buyers, check the sales employee option as shown below:

 

 

 

 

 

 

 

 

 

 

 

If you have selected by buyer, then the bottom options to select customer groups and properties will automatically be hidden.

 

You can either select a range from one business partner to another, or leave the, from and to options in the code fields blank for all business partners to be included in report.

 

 

 

 

 

 

 

 

 

 

Under Vendor group you are also given the option to select Vendors from the certain Vendor groups you have already set up.

NB: on this screen shot it says customer groups this should read vendor groups, this is an error in certain versions of SAP.

 

 

 

 

 

 

 

 

 

 

If you click on the property button, a list of all the properties will be available, if you have setup properties for your business partners and would like to run this report on those properties uncheck the ignore all option and check the properties you would like to use. If not leave the ignore all option checked and click ok.

 

 

 

 

 

 

 

 

 

You may run this report according to control accounts as well, if you would like to do so, when checking the control account option, a list of control accounts will automatically pop up. Or tick select all to include all control accounts in report.

 

 

 

 

 

 

 

 

 

Choose the control accounts you would like to run the report by checking the choose option for each account and then click ok.

 

 

 

 

 

 

 

 

 

 

 

Aging date: enter the date at which you would like to run this report, this would usually be the current date, which is therefore set as default, while you may choose a different date if you like. An example of why you would change the date would be: setting the date a week forward in case you want to display all liabilities that are due for payment during the following week.

The interval option allows you to view your Aging report in days, months or periods, it should usually be run in months.

 

 

 

 

 

 

 

 

 

 

You can run this report by:  Posting date, due date or document date.

If you would like to view all Vendor Liabilities to that aging date only fill in the “to” field in posting date and leave the from date blank, otherwise you may specify the period according to your preference.

 

 

 

 

 

 

 

 

 

 

 

Display Customers with Zero Balance = Includes Vendors with a zero balance in the report, if you would like to view all Vendor liabilities, without excluding any history this should always be checked.

Display Reconciled Transactions = Displays reconciled journal entries of the accounting documents generated for the Vendors.

Ignore Future Remit = Hides the Future Remit column in the report and excludes transactions that have a value in this field.

 

 

 

 

 

 

 

 

 

 

This is an example of how your Vendor Liabilities Report would look