The Late Bill Report has multiple options for you to streamline the report data set. These are relevant if you want a report foe a specific data set. The mandatory fields are stated in the list below along with the other optional selection criteria.
The selection criteria below is described based on the SAP standard configuration and related to the invoice process, individual businesses may have customized these data items to have a specific company definitions.
Business Partner: Customer identification number.
Contract Account: Customer Account number, this relates to the general invoicing and payments level for the Customer Account structure. This is where all related contracts are held and grouped to produce a combined Invoice Documents.
Contract: This related to individual product contract that has individual characteristics for required for Billing Documents to be created..
Company Code: This is the smallest organizational unit of external accounting for which a complete, self-contained set of accounts can be created.
Division: This defines the product type the the contract relates to.
Contract Acct. Categ.: A contract account category defines a specific attribute for a contract account. e.g. Standard Contract Account or Collective Contract Account.
Account Determin. ID: A characteristic used with company code, division, main transaction and (if required) sub-transaction to determine a General Ledger (G/L) account.
Billing Class: This relates to the classification of the supply point e.g. Business or Residential.
Rate Category: This relates to the tariff on which the product is billed.
Move-In Date: This is the start date of the contract.
Move-Out Date: This is the end date of the contract.
Key Date: This is the date you would like to report up to and including.
e.g. If you want the Late Billed position at the end of Quarter 1, this might be set to 03.31.2015 (American) 31.03.2015 (Europe). The report will calculate the number of late invoicing days up to and including this date. It is recommended this is set to today’s date to allow any management decisions to be made with the current late invoicing position. Any accounts that have not been invoiced after the key date will not be displayed in the report.Start of Bill Per. => Key Date: The ‘‘Start of the Billing Period’‘ is day +1 from the last invoice with a successful print date. Selecting this option will mean the late invoicing days will count will commence from this date.
Recommendation – This view is beneficial if you would like to know how much revenue is trapped in the invoicing process or looking at late invoicing from the perspective of when did the customer last receive an invoice. If the account has never billed this date defaults to the move in date for the customer.
Sched. Bill Date => Key Date: The ‘‘Scheduled Bil Date’‘ is the date the invoice was due to be created. e.g. The last invoice the customer received covered the period January 1st to March 31st. Therefore the customers next scheduled bill date is June 30th. Selecting this option will mean the late invoicing days will count will commence from this date.
Recommendation – This view is beneficial if you would like to know the number of delayed invoices and the length of the delay.
Time Interval: This is the blocks of time you would like customers to be summarized by.
e.g. 30 day intervals would show in the summary the number of customer that are 0-30 days late, 31- 60 days late etc.
Post your comment on this topic.