ARRECENT Accounts Receivable Recurring Sales Processing

Recurring Sales Processing

Application Overview

 

In addition to normal A/R activity, most companies have several receiv­ables, which are issued on a regular basis.

 

Recurring sales can recur in two different ways.  Either they are issued on a specific day of the month (possibly every two or every three months) or they are issued every so many days (possibly every 14 days or every 30 days).  These two types of recurrence are type M for monthly and type N for number of days.

 

Each recurring invoice has a starting date and an ending date.  The starting date is the date the first invoice is issued.  The ending date is the date of the last invoice.  In some cases, there will be a certain number of invoices at one amount and then more invoices at another amount.  Two recurring invoices could be set up with con­secutive date ranges to handle the change in invoice amount auto­matically.

 

Once the Recurring Sales file is set up, all that remains to be done is to post the recurring invoices to the A/R Transaction file on a regular basis.  These transactions are, in turn, posted to the A/R Open Item File, the same as the transactions entered through Sales & CR/DR Memo Processing.

 

Even if recurring invoices are not posted to the Sales & CR/DR Memo Processing file frequently enough, invoices will not be skipped by the application.  The recurring invoices posting program will create automatically as many sales transactions as needed to bring the invoices up to date.

Run Instructions

 

Select Recurring Sales Processing from the pull down A/R Processing window. The following screen will then be displayed:

 

 

 

Recurring Sales Processing Entry Screen

 

 

 

The following options are available:

  • Add sales invoices that are issued on a regular basis
  • Make changes to the recurring transactions entered
  • Delete transactions entered
  • Print to screen, the recurring invoices presenting invoice amounts, descriptions, recurring ID code, and G/L distributions

 

To return to the menu bar, press the ESC or F10 key.  To leave this application, press X for EXIT when positioned at the menu bar.

  

Entry Field Descriptions

 

Name

Type and Description

1.  Customer No

6 alphanumeric characters.

Enter the customer number of the customer to whom the invoice will be issued. The customer's name will be displayed automatically.

If you do not know the customer number of the customer you want, press the F7 key for customer search by number or press the F8 key for customer search by name.

2.  Recurring Id

4 alphanumeric characters.

This field defines the recurring invoices for a customer.

It is used to define one of several recurring invoices for a customer.

The default recurring ID is 1, so if you only have one recurring invoices for a customer, use this default.

Pressing the F1 key will bring up the next recurring invoice for this customer, in change and delete mode.

3.             Description

30 alphanumeric characters.

Enter a description of the recur­ring invoice.

For example, a recurring invoice might have a description: Membership Dues.

4.             Type Of Recurrence

1 alphanumeric character.

The valid values for this field are:

M             =              Monthly invoice

N              =              Number of days between invoices

If the invoice will always be issued on a certain day of the month, even if there will be more than one month between invoices, enter M.

If the invoice is issued every specified number of days (such as once every 30 days), then enter N.  There is no default for this field.  Once entered this field it can not be changed.

5.  Interval

3 numeric digits (999).

If M was entered above, enter the number of months between each invoice.  If the invoice is issued every month, enter 1. If the invoice is issued every other month, enter 2.

If N was entered above, enter the number of days between invoices.  If the invoice is issued every week, enter 7.  If the invoice is issued every other week, enter 14.

The default for this field is one (1).

6.  Starting Date

Enter a date in the standard date format.

Enter the date that the first invoice is to be issued.  If this is a type M recurring invoice, invoices will always be issued on the same day of the month as this date.

When this field has been entered, a description of when the invoice is issued will be displayed on the screen.  Take a look at this desc­ription to ensure that the data entered is correct.

This field defaults to the system date.

If this date is changed, the last invoice date will be set to zero.

7.  Ending-Date

Enter a date in the standard date format.

Enter the date that the last in­voice is to be made or the date after which no invoices should be made.  This date need not fall exactly on an invoice date.

8.  Sale Amt

9 numeric digits with 2 decimal places and an optional minus sign (9,999,999.99

-). 

Enter the sale amount.

9.  Misc Amt

8 numeric digits with 2 decimal places and an optional minus sign (999,999.99).

Enter the miscellaneous charges for each invoice.

10.  Freight Amt

7 numeric digits with 2 decimal places and an optional minus sign (99,999.99).

Enter the freight amount for each invoice.

11.  Calculate Tax?

Y or N.

Enter whether tax should be calc­ulated on this invoice or not.

If the customer is taxable, this field defaults to Y.  Otherwise it defaults to N.

12.  Calculate Comm ?

Y or N.

Enter whether commission should be calculated on this invoice or not.

This field defaults to Y.

13. Terms Code

2 alphanumeric characters.

Enter the terms code to be used with this recurring invoice.

If you do not know the terms code, press F7 to search the terms code table.

14. Last Invoice Date

A date in the standard date format.

This field will be used by the package to keep track of the last invoice that was posted from this recurring invoice.

This field should be left blank when a new recurring invoice is entered in the add mode.

If for some reason, you wish to have the recurring invoice posting program skip an invoice or two, this can be done by setting this date to the date of the last invoice which should be skipped. This would cause the system to think that invoices had already been created up to this date, so it would skip them. 

If this date is changed, the starting date will be updated to a date one interval following this date.

  

Distribution Screen

 

The customer name and number and the description of the recurring invoice being entered or changed is displayed on this screen automatically.

 

Name

Type and Description

Account No

An account number in the standard account number format.

Enter the account to which the expense distribution will be made when the recurring invoice is posted to the Sales Transaction file.  The description of the account will be displayed.

In add mode, the F1 key may be used to automatically distribute the amounts to the A/R Setup defaults.

Pressing the F7 key will allow you to search for the account by number. Pressing the F8key will allow you to search for the account by name.

Amount

9 numeric digits with 2 decimal places and an optional minus sign  (9,999,999.99-).

Enter the amount, which is to be distributed to the account.

The total of all distribution amounts must be exactly the amount of the recurring invoice.

The amount remaining to distribute is displayed at the bottom of the screen and will be automatically updated after each distribution is entered.  You will not be allowed to leave this screen until the amount remaining to distribute is zero.

 
Print Recurring Invoices List

 

Name

Type and Description

Starting Customer No

6 alphanumeric characters.

Enter the beginning of the cust­omer number range, which you wish to print on the report.

This field defaults to All.

Ending Customer No

6 alphanumeric characters.

This field is not entered if All was selected above.

Enter the end of the customer number range, which you wish to print on the report.

This field defaults to the start­ing customer number to facilitate printing the recurring invoices for a single customer.

 

  Date filled out ______ by _______         ADD   CHANGE   DELETE

 

                  RECURRING INVOICE PROCESSING FILE LOAD SHEET

       1)  Customer No    _ _ _ _ _ _

       2)  Recurring ID   _ _ _ _

       3)  Description    _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

       4)  Type of Recurrence  _   M = Monthly, N = Number of Days

       5)  Interval       _ _ _

       6)  Starting Date  _ _ / _ _ / _ _

       7)  Ending Date    _ _ / _ _ / _ _

       8)  Sale Amount    _ , _ _ _, _ _ _ . _ _

       9)  Misc Amount    _ _ _, _ _ _ . _ _

      10)  Freight Amount _ _, _ _ _ . _ _

      11)  Calculate Tax       Y=Yes   N=No

      12)  Calculate Comm      Y=Yes   N=No  

      13)  Terms Code     _ _

      14)  Last Invoice Date   _ _ / _ _ / _ _

 Recurring Invoice Distributions

            Account No                                                Amount

  1.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  2.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  3.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  4.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  5.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  6.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  7.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  8.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

  9.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

 10.  _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _         _ , _ _ _ , _ _ _ . _ _

 

 

 

 

 


 

Customer Search By Number

 

 

 

 

 


 

Recurring Sales Processing (Screen #1)

 

 

 



           

Recurring Sales Processing (Screen #2)

 

 

 

 

 

 


 

Recurring Sales List

 

 

 

 

 

Recurring Sales List

 

 

 

Run Date: Sep 25, 2001 - 11:09pm         Elliott Demonstration Company                                                     Page    1

                                                                                                                                    

                                              R E C U R R I N G   S A L E S   L I S T                                              

                                                                                                                                  

                                       

 

  

Post Recurring Sales Transactions

Application Overview

 

The Post Recurring Sales Transactions application transfers all transactions that were previously created in Recurring Sales Processing into the sales transaction file.  You may then edit these transactions via Sales & CR/DR Memo Processing application under the A/R Processing pull down window.  After verifying the transactions, you may post using the Post Sales & CR/DR Memo Transactions under the A/R Processing pull down window.

 

When you perform a posting, the system prints a journal of all transactions that were posted.

 

Run Instructions

 

Select Post Recurring Sales Transactions from the pull down A/R Processing window.   The following screen will then be displayed:

 

 


 

Post Recurring Sales Transactions Entry Screen

 

 

 

 The following option is available:

  • Post recurring sales transactions

 

To return to the menu bar, press the ESC or F10 key.  To leave this application, press X for EXIT when positioned at the menu bar.

 

Entry Field Descriptions

 

Name

Type and Description

Do You Want To Post At This Time ?

Y or N.

Enter Y to post recurring Sales transactions or N to decline.

 

 

 

  

Post Recurring Sales Transactions

 

 

 

 

 


Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check an Order After Filling Back Order
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - ACH Deposit Effective Date
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. Feature - Customer Account Inquiry Reference Search
  64. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  65. ARFRMMNT Accounts Receivable Invoice Form Setup
  66. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  67. Feature - Ship Via Group Support
  68. Feature - Scheduling ACH Payments
  69. How to Print A/R Aging Report by Salesman
  70. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  71. Refund customer open credit / overpaid
  72. Feature - Add Acct Name to ACH Account Detail Screen
  73. Feature - ACH Add and Change Event
  74. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  75. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  76. Feature - Age Customer Accounts When Cash Receipts Are Posted
  77. Feature - Validate Collector Against Salesman File
  78. NSCTLMN2 Accounts Receivable Global Setup 1
  79. NSCTLMN2 Accounts Receivable Global Setup 2
  80. NSCTLMN2 Accounts Receivable Global Setup 3
  81. NSCTLMN2 Accounts Payable Global Setup 1
  82. NSCTLMN2 Accounts Payable Global Setup 2
  83. NSCTLMN2 Accounts Payable Global Setup 3
  84. NSCTLMN2 Accounts Payable Global Setup 4
  85. NSCTLMN2 Accounts Payable Global Setup 5
  86. NSCTLMN2 Accounts Payable Global Setup 6
  87. NSCTLMN2 Accounting Global Setup: Index
  88. Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
  89. What Does the Asterisk Mean in A/R Account Inquiry?
  90. Refund Customer for Open Credit or Over Payment
  91. Feature - Defer Cash Receipts with Wildcard Batch Entry
  92. Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd
  93. Change - Sync Order Addresses in Customer Change Program
  94. Feature - Append Re-Apply Cr/Dr Memos Info To Log File
  95. Feature - Zone Breakdown Method by Freight Pay Code and State

Feedback and Knowledge Base