SUB500 – Hold Unpaid Subscriptions

This batch process report provides users with the ability of placing partially paid subscription orders on hold to prevent future mailing of journals.

Parameters

Parameter

Description

Required?

Subtitle

Free Form text to be used as report sub title for printing.

 

Default Value: Hold Unpaid Subscription

N

Run Mode

This parameter has two modes EDIT and PROD. Edit mode will not update the database only use the parameters and query to select records for reporting.  Prod mode will also produce a report of records selected but will also update the order tables.

Y

Organization

Defaults to the Organization the end user is logged into when process is run.

Y

Organization Unit

Read Only parameter. Defaults to the Organization the end user is logged into when process is run.

Y

Parent Product

Used to determine the Parent_product. This must be a product of subsystem type = ‘SUB’.

Y

Product Code

Enter the parent product code to select labels for.  This is used in conjunction with the Product Code to determine the journal to select labels for.

Y

No. Of Months

This allows end users to select subscription orders that has not been paid in full, based on the number of months from the system date.

Y

Sample Report