Past Due Create Workfile

Use the Past Due Create Workfile routine to create a Workfile containing the customer detail that is needed to print past due notices alerting customers about the overdue status of their account.  During the Create Workfile routine you can determine the customers to consider in the past due process by choosing the services, the companies, the finance periods, and the Age Balances to include.  There are also options to create the Past Due workfile for open item customers only and for customers with payment plans.

Notes:  

• The Past Due Create Workfile is the first step in creating customer past due notices.  For the sequence and timing of the past due steps, see Past Due Procedures.

• The Past Due Service Parameter record can limit the customer services that are considered during the Past Due Create Workfile routine.

• For more information about working with data in fields, see Data Entry Guidelines.

Directions:

To see directions for...

• Opening the Past Due Create Workfile routine, click More.

   

  1.  Click Processes from the Menu Bar.

  2.  Click Past Due.

  3.  Click Create Workfile.
  
  Or, use the keyboard shortcut:  [ALT] [p] [p] [c].
   

  Past Due Create Workfile Window Example:

  

• Choosing the selections, click More.

   

  Past Due Create Workfile Prompts Tip:  To see more information about a field, click the hyperlink for the field name.
  Services	To select the services to consider, click to check the appropriate services listed. Tip:  To quickly select or de-select all services listed, click Check All .
  Companies	To select the companies to consider, click to check the appropriate companies listed. Tip:  To quickly select or de-select all companies listed, click Check All .
  Status	To select the customer statuses to consider, click to check the appropriate statuses listed. Tip:  To quickly select or de-select all statuses listed, click Check All .
  Finance Periods	To select the Finance Period to consider, click to check the appropriate Finance Periods listed. Tip:  To quickly select or de-select all Finance Periods listed, click Check All .
  Rate Class	To select the rate classes to consider, click to check the appropriate rate classes listed. Tip:  To quickly select or de-select all rate classes listed,click Check All .
  Credit Rating	To select the customer credit ratings to consider, click to check the appropriate customer credit ratings listed. Tip:  To quickly select or de-select all credit ratings listed, click Check All .
  Ages	To select the customer Age Balances to consider, click to check the appropriate Ages listed. Tip:  To quickly select or de-select all Ages listed, click Check All .
  Lien	To include lien amounts on the report, click to select this box. To omit customer lien amounts on the report, leave this box unchecked.
  Lien Cost	To include customer lien costs on the report, click to select this box. To omit customer lien costs from the report, leave this box unchecked.
  Lien Interest	To include customer lien interest amounts on the report, click to select this box. To omit customer lien interest amounts from the report, leave this box unchecked.
  Roll Principal	To include customer roll principal amounts on the report, click to select this box. To omit customer roll principal amounts from the report, leave this box unchecked.
  Roll Cost	To include customer roll cost amounts on the report, click to select this box. To omit customer roll cost amounts from the report, leave this box unchecked.
  Roll Interest	To include customer roll interest amounts on the report, click to select this box. To omit customer roll interest amounts from the report, leave this box unchecked.
  Minimum Balance	Enter the Minimum Balance a customer must have to be included in the past due process. (7.2 numeric)
  Notice Date	To accept the system date as the Notice Date, press [TAB] or enter another date as the date to print on the Past Due Notices. (mmddccyy, slashes and century are optional)
  Due Date	To accept the due date displayed, press [TAB] or enter another date that the arrears payment is due. (mmddccyy, slashes and century are optional)
  Last Billing Date	To create the Past Due workfile based on the customers' last bill date, enter the last bill date.   Note:  The Last Billing Date option only pertains to Open Item customers.
  Open Item Accounts Only	To only create the Past Due workfile for open item customers, click to select Open Item Accounts Only. Otherwise, please leave blank. Note:  The Open Item Accounts Only option only pertains to Open Item customers.
  Customers	Entry Options: To consider all customers in the Create Workfile process, please leave blank. To include an individual account in the workfile, enter the Customer ID. (up to 12 characters) To build a list of customers for the workfile: Enter the Customer ID followed by a comma (,). Continue to enter the desired customers. To complete the customer list, press [TAB]. To search for the appropriate customer ID, click Search . To build a range of customers, enter the beginning Customer ID, followed by a hyphen (-) and then the ending Customer ID.
  Payment Plans	To specify if customers with payment plans should be included in the past due workfile, click to select a choice from the drop-down list. Entry Options: Include All Customers Include Only Customers on Payment Plans Include Only Customers not on Payment Plans
  	To start the Create Workfile, click Proceed. Keyboard shortcut:  [ALT + p]
  	To escape without creating the Workfile, click Cancel. Keyboard shortcut:  [ALT +c]
  	To close the Create Workfile routine when the routine is complete, click Done. Keyboard shortcut:  [ALT + d] Note:  The number of customers processed and the number of past due notices generated during the Create Workfile routine displays for your reference.