Formula definition

The Amortization Formula Definition maintenance program is used to define amortization types. For example over one year, two years, three years and months for example 6 months. A new formula can be created or an existing formula can be maintained or deleted. The formulas represent different amortization types defined at different title levels.

Add amortization formula defintion

  1. In the menu, expand Publishing Modules Book Publishing > Others > Amortization > Maintenance and double-click Amortization Formula DefinitionBPM070 Amortization Formula Definition panel appears.
  2. Click Add.
View the fields on this panel
 Field Description 
Sequence number level 1-5 The sequences used in both Amortization Formula Definition and Amortization GL Definition. There are five Title levels. Level codes can be used in the Amortization Formula Definition and Amortization GL Definition.  To accept all Level codes in a level field use *** as a wildcard
Classification type Classification types can be used in the Amortization Formula Definition and Amortization GL Definition.  To accept all Classification Type codes use *** as a wildcard.
Classification code Classification codes can be used in the Amortization Formula Definition and Amortization GL Definition.  To accept all Classification codes use *** as a wildcard.
ISBN ISBNs can be used in the Amortization Formula Definition and Amortization GL Definition. To accept all ISBNs use *** as a wildcard 
Start from code/date

Formula start from codes are established in TMSBP/AMT-STRT.  This Control File is system defined.

The following  are examples of code.

C=  PROJECT CLOSE DATE

I  = IMMEDIATE      

L = WHICHEVER LATEST PUB DATE

      (Pub date and stock receipt comparison)

N = NEVER

O = OVERRIDE DATE

P = PUBLICATION DATE

R = RECEIPT DATE

 If using C=Project Close Date the result could be:

Start period code . . . . .       C PROJECT CLOSE DATE

Start date  . . . . . . .     .        n/a

Duration/Rate                       mandatory

If using C=Project Close Date the result could be:

Start period code . . . . .       C PROJECT CLOSE DATE

Start date  . . . . . . .     .        n/a

Duration/Rate                       mandatory

If using I=Immediate the result could be:

Start period code . . . . .       I IMMEDIATE

Start date  . . . . . . .     .        n/a

Duration/Rate                       mandatory

If using L=Whichever latest pub or stock receipt date the result could be:

Start period code . . . . .       L WHICHEVER LATEST PUB or STOCK RECEIPT

Start date  . . . . . . .     .        n/a

Duration/Rate                       mandatory

If using O=Override Date the result could be

Start period code . . . . .            O OVERRIDE DATE

Start date  . . . . . . . .                 01/10/98 mandatory

Duration/Rate                            mandatory

Entry of the start date is required when using a Formula Start From code of O=Override. 

If using P=Publication Date the result could be

Start period code . . . . .             P PUBLICATION DATE

Start date  . . . . . . . .                  n/a

Duration/Rate                             mandatory

If using R=Receipt Date the result could be

Start period code . . . . .             R RECEIPT DATE

Start date  . . . . . . . .                  n/a

Duration/Rate                             mandatory

Enter the start period code which is to be used to determine the beginning of amortization.  For example project close date.

Months duration / % rate  

Enter the amortization periods in months.

If using C=project close date this uses the date from the Project and the percentage rate is used in the calculation.

If using I=immediate the calculation is for the current period and duration is relevant to the calculation.

If using L=whichever latest pub this uses the latest publication date or stock receipt date from the Project stock file and the percentage rate is used in the calculation.

If using O=Override the date entered, the months duration and the percentage rate is used in the calculation.

If using P=Publication date this uses the date from the Project or Title file and the months duration can be broken down into the respective periods.

If using R=Receipt date this uses the date from the Stock file and the months duration can be broken down into the respective periods.

The percentage rate must equal 100%.

Total Calculated total of period and percentage rate. 
  1. Enter the above information, as necessary.
  2. Click OK to confirm.