WP.24: Storage Schemas
Table of Contents
WP.24: Storage Schemas
wp24
Note that you can click the button (or press F5) to invoke field help at any time from within the job panel itself.
Business Benefits
Many of your Clients may have similar arrangements; e.g., anniversary billing, recurring dates, etc.
Rather than enter this common information for each Client, you can use this program to set up these common Schemas/Schedules, then assign a whole Schema to each Client.
Note: For related documentation and workflows, see WP - Warehouse Profile.
Usage
Use this job to define Storage Schemas or Billing Arrangements to be used by the system to calculate Initial Storage Charges and Recurring Storage Charges.
It defines whether a Client's Recurring Storage will be billed on the anniversary of Receipt or on the basis of the Date tables set up in program WP.23 [Billing and Inventory Dates].
As with other programs in this system, different Clients may have different Schemas, or they may share a General or common schema.
This program also defines how the system will generate Charges for Recurring Storage. There may be several different Anniversary Date Schemas (in program CR.14 [Storage Billing Schemas]), as well as several Specified Date Schemas controlled by program CR.12 [Storage Periods/Billing Dates].
During system startup, only the default Billing Schema is required. At this point, no Clients would have been set up; therefore, only GEN codes may be set up.
Two Basic Types of Storage Schemas:
Anniversary Date Billing:
Anniversary Date Billing is used only for multi-Lotted Products. Lots are renewed on a periodic (i.e., anniversary) schedule based on one of the following:
- The same date each month, based on Receipt date
- The same date each month, based on the first renewal date
- A cyclical schedule (e.g., every 10 days)
- A daily basis.
Anniversary-Date-Billing Invoices may be generated on specified Billing dates. This avoids daily Invoices. The charges will always reflect balances as on the actual Anniversary Date because the system retains the balance On-Hand up to the end of a Billing Period in a separate field until Recurring Storage Invoices are generated.
Specified Date Billing:
Specified Date Billing (also called Monthly Billing) uses Storage Periods that are defined by the Date tables created in program CR.12 [Storage Periods/Billing Dates], and then referenced later by either the Client's Nominal Schema or the Product Master file for a Client.
You can create variations on either of these Schemas (1 or 2) by using various reference codes.
For a complete explanation of how renewal storage is calculated see the documentation attached to IP.00 [General IP Documentation].
Preconditions
If you wish to specify a schema of Anniversary Dates, you must have set up Field 33 (Anniversary Date Clients) in program WP.95 [Receiving Profiles] to allow Anniversary Date Clients. If you have not done this, you will not be able to access the section of the screen referring to Anniversary Dates.
Also, Field 14 (Recurring on Holidays) of program WP.92 [Invoicing Profiles] must indicate what to do if a Recurring Storage Charge falls on a holiday.
The default Schema code is set up in Field 1 (Schema Recurring Default) of program WP.90 [Client Definitions].
Client codes must be set up in program CR.06 [Client Names and Addresses].
Subsequent Actions
You may print a list of the Storage Schemas using program CR.14 [Storage Billing Schemas].
A Billing Profile Default is used in Field 1 (Schema) of program WP.90 [Client Definitions].
The Billing Profiles are used in Field 4 (Billing Schema) under Option #1 (Billing Profiles) of program CR.63 [Product Billing Profiles].
Daily flat rate Charges will be generated by program IP.31 [Recurring Storage - Generate].
Program Fields and Functions
To review a text version of the field help, click here. Click the button (or press F5) to invoke field help at any time from within the job panel itself.