OpenPro Application Guide - Sales Order Templates and Recurring Orders Processing

Sales Order Templates and Recurring Orders Processing

Introduction

Purpose of this manual is to describe what the recurring sales order processing is, how to setup the system with-in OpenPro and how to run transactions through the system.

Template Recurring sales orders are used for two reasons:

  1. to create a template order for a customer. If a customer orders the same products over and over again, with the template order you can create a template,and then just select the template during order processing. This process can be a great time saver.
  2. to create Invoices/Sales Orders/Bills on a monthly, daily, weekly or annual basis that get processed. These recurring invoices are used in many organizations, Warranty, Service, Rental, Subscriptions, Internet users, etc.

To use OpenPro Recurring sales order the following items need to be configured.

  1. New sales order types need to be defined.
  2. Groups need to be setup in the tables.
  3. Programs need to be added to the menu.
  4. Then you can start entering recurring sales order.
  5. Then you use the selection process of the recurring orders.

Basic Process Flow

This section shows you the overall OpenPro system data flow and integration between systems.

Setup Recurring order types as follows:

The RECUR are for orders that are not being pulled in as template orders, they are orders that will be billing once a week, month, qtr, etc.
RECSO order types can be pulled in during the entry of sales orders and fills out the sales order line items.

Here are the detail records for order types:

  • RECUR is for recurring orders, daily, weekly, monthly, quarterly, and annually.

  • RECSO are for orders that you pull up templates during order entry and fill in a sales order. This is for customers who call in and purchase the same merchandise all the time.

Also a recurring incremental code needs to be created. The incremental codes are used to specify the time period for the recurring invoices.

Each record needs to be setup:

  • Days – if you bill every so many days.
  • Week – for weekly billing or multiple increments of weeks
  • Month – for monthly billing and increments of months.
  • Quarterly – for quarterly billing (every 3 months)
  • Yearly – for annual billing or every 12 months 365 days.
  • Day of Month (DOMONTH) - this is used if you want to bill on the 10 day of every month, you specify this code and put in the day in the increment field. If you put 10 in the increment field it will bill using the invoice day of the 10 day of the month.

New sales order types need to be added.

This table is for grouping your recurring billing. So when you select the invoices you can batch them into groups.

The table Types need to be setup like above.

Sales Recurring groups can be named anything you would like.

Examples are below. Need to setup the Recurring Order.

One needs to be setup a Default group, so during adding new recurring orders that is the one defaulted.

Groups are used so you can select certain groups for certain days of the week, months, etc.

Menu items need to be added to the system, if you don’t already have them setup. The following programs are used for this process.

Go into menu maintenance mode, add the Category Template and put it under the Sales Order Process.

Then add the following programs to the Sales Order Template Menu.

Programs
So_template_add – adds a template order.
So_template_find – finds and edits template orders.
So_template_select – select template orders for invoicing, sales order processing and billing.

Here are the detail menu items. One menu item for entering recurring orders, one for selection process of those orders. And one for the editing of the orders.

When you are adding recurring order templates, its just like adding sales orders.

It will default to the recurring order types.

Remember based upon this order type, it can be used during sales order entry or you must use the Template Select process for the order.

  • RECUR – recurring order - are for orders that are not being pulled in as template orders, they are orders that will be billing once a week, month, qtr, etc.
  • RECSO – sales order template - order types can be pulled in during the entry of sales orders and fills out the sales order line items

Select the customer you need for billing.

Then you can select the items you want to use for the billing process.

Just like in standard order entry process.

When you click on Detail it will display more information than the standard order entry screens.

Then on the order header is the recurring information. All the other fields are standard order entry fields.

Template Name – What name you want to call this to help select during order entry processing or the select for recurring billing.
Last Template Date – is the date you added this template or the date the template was billed or used last.
Next Run Date – this is based upon the last run date it calculates the next date for processing. If you are adding a new one, enter in the date you would like this to process.
# Times Processed – this is the number of times this order has processed from when the recurring order has been added.

Template Increment This is based upon how often billing should occur.

  • IE. Days – if you bill every so many days.
  • Week – for weekly billing or multiple increments of weeks.
  • Month – for monthly billing and increments of months.
  • Quarterly – for quarterly billing (every 3 months).
  • Yearly – for annual billing or every 12 months 365 days.
  • Day of Month (DOMONTH) this is used if you want to bill on the 10 day of every month, you specify this code and put in the day in the increment field. If you put 10 in the increment field it will bill using the invoice day of the 10 day of the month.

# of increments, based upon the template increment, you enter in the number associated to it.

Template Group – used to group the templates for selection processing and reporting.

When completed entry, click on ADD TEMPLATE to add the template to the recurring order processing system.

Then for the selection process you can select the recurring orders entered in.

It will convert templates into invoices, or sales orders and you can select an invoice date.

  • Selected by – Auto will check off all the records found, so you can process them. Manual will make you click on each order you want to process.
  • As Of Date – what date you want to select the recurring bill orders up to.
  • Customer – if you want to just select a special customer for billing.
  • Create – Invoice or Sales Order. Invoice will move the order to the Select for invoice stage of the order processing cycle, Sales Order will put the order in the picking shipping stage of the order processing cycle.
  • Invoice Date – this will be the invoice date for the invoices created.

Template find, edit and update.

This is where you can search and review your templates.

During this process you can Edit (blue), Copy (Green) or Delete (red) the templates.

When you edit the screens look just like during entry.

[Last Review Date November 2017]