Dynamo RENTAL processing

Technical Overview

 Last Revised: 01/30/08

Dynamo supports rental transactions, as well as sale of product.  This document describes technical information related to rental transactions.

  1. Rental transactions are enabled in Dynamo by setting the Rental Indicator (CW00.RENTAL) to Y using Company Wide Parameter Maintenance (CWP).
  2. Items are enabled for rental by assigning a Rental Code (IM01.RENTALCODE) using Item Maintenance (IML).
  3. Items that are sold use the product class (IM01.PCL) using Item Maintenance (IML).  Items that are rented must have a Rental Product Class specified in Product Class Maintenance (IML).
  4. Rental transactions can be for serialized and non-serialized items.  Serialized items to be rented are described using Serialized Item Maintenance.  Non-serialized items are often called rental accessories.
  5. Cost of sale of rental transactions is always zero.  Likewise, there is no inventory value change for rental transactions.
  6. Rental inventory is kept separate from inventory for sale.  The Warehouse Type (CW12.TYPE) is set to R in Warehouse Information Maintenance (CWP).  The warehouse code for a rental warehouse is often set to the lower case of the corresponding sale warehouse.
  7. Products that are out on rent 28 days are invoiced by Generate Monthly Rental Invoice (SOP).  Invoice Update will create a 'backorder' listing the items that remain out on rent that have not been returned.

Data Files used for rental transactions

Name Description Usage
XXCW12 Warehouse Information Maintained using Warehouse Information Maintenance (CWP).  Warehouses used for rental must be coded as type R.
XXIM12 Rental Code Descriptions Maintained using Rental Rate Maintenance (RML)
XXIM66 Rental Rates Maintained using Rental Rate Maintenance (RML).  Rates can be for specific customers, pricing customer, or all customers.  Rental rates are date sensitive, like all Dynamo pricing.
XXSO42 SOP Rental Transactions Record for each rental line item on a sales order
XXSI01 Serialized Inventory Used for rental of serialized items
XXSI02 Serialized Sales History Used to identify what serial numbers are linked to a sale order line item.  This applies to both rental and sales.  There will be an SI01 record for all serialized rental transactions, and any serialized sale transaction where the item serialized indicator (IM01.SERIALIZED) is F.
XXSO41 SOP Line Items
Field Name Usage
BOMSG BO Message/Serialized Line Type - always blank on rental line items, as there are no SI02 records for serialized rentals.
QTYORD Quantity Rented
QTYSHP Always same as Quantity Rented - so that Item Inquiry, Sales Orders option displays rental lines similar to sales line items.
QTYBO Not used
QTYRETN Quantity Returned
CU Costing Unit - always blank on rentals
COST Unit Cost - always zero on rentals
EXTCOSTORD Extended Cost Qty Ordered - always zero on rentals
EXTCOSTSHP Extended Cost Qty Shipped - always zero on rentals
PU Pricing Unit - always blank on rentals
PRICE Discounted Unit Price - Set by SO113 based on length of time of rental and quantity rented
PRICEUNDISC Set to the same as PRICE
DISCPCT Discount percentage - always zero for rentals

Temporary Work Files

Name Description
XXVR170. Vendor Return Generation
DYVM040. Select Vendor

Programs attached to Menu

Name Description Menu Note
RN120 Rental Code Listing RML  
SO421 Generate Rental Invoice SOP Used to invoice an open rental not yet returned that has one or more line items that have been out on rent 28 days.

Called Routines

Name Description Data Dictionary Company Note
SO913 Rental Interface N/A Called by XXU012 to process a rental transaction.  Input variables are order# (X$), order detail key (X0$), and action (ACTION$).  This program will be phased out once SOP uses template fields.  SO913 calls template based SO113.
SO113 SOP Rental Line item N/A Called by SO913 to Add, Modify, Display, or Delete a rental line item
SO144 SOP Compute Rental BILLDAYS, WEEKS, MONTHS N/A Called by SO113 and SO421 to set SO42.BILLDAYS, BILLWEEKS, and BILLMONTHS based on the dates rented, returned, and lease dates.
SO145 SOP Compute Rental Charge N/A Called by SO113 and SO421 to set SO42.AMTDAYS, AMTWEEKS, AMTMONTHS, AMTRENT, BILLUSAGE, AMTUSAGE, and AMTTOTAL.
SO146 SOP Build Rental Printing Strings DY Called by order and invoice printing routines with SO42$ as input.  SO146$ contains various output fields used when printing rental line items.
SO420 SOP Rental Transaction Field XX Called by View Manager (CDS550) for fields named SICNO, QTYRNT, QTYRET, DATEOUT, DATEIN, BILLDAYS, AMTADJ, and AMTTOTAL.

   

CDS037/38 Type External Routines

Program Input Output
     

Utility Routines

Program Description
   

Open Issues