How to change publication frequency

In order to change the frequency of your publication, you need to use the fix frequency program. The program FIXFREQ makes generic frequency changes based solely on command line arguments.   FIXFREQ is run from the QuickFill program directory (\QFW). You can enter the command line from a command prompt or the 'Run' menu item on the Windows 'Start menu'.  Prior to running this program, make sure that no one is in the database.

The syntax for FIXFREQ is:

FIXFREQ DBNAME PUBCODE nOLDFREQ nNEWFREQ <UP|NEAREST>

To change the frequency for pub MYPUB from 13 issues to 17 issues and round the term and issues remaining to the nearest whole number, you would type:

FIXFREQ QFWDB MYPUB 13 17 NEAREST

or to round up the term and issues remaining to the next highest whole number you would type:

FIXFREQ QFWDB MYPUB 13 17 UP

The algorithm used by the program is to calculate the factor by which the frequency is changing. (In the example above, the factor would be 17/13 = 1.31)

For every active order in the database the program then makes the following calculation:

New term = factor x old term

New issues remaining = factor x old issues remaining

In both cases the results are either rounded up to the next whole number or rounded to the nearest whole number based on the whether you entered 'UP' or 'NEAREST' on the command line..

Once the new term and new issues remaining have been calculated, the program calculates the new value for the number of issues served as follows:

New issues served = New term + Free + Extension - New issues remaining

The program adds a comment to the subscription history indicating that the term and served have been adjusted. It also recalculates the deferred income and posts any necessary adjustments (this usually affects earned income). It creates a miscellaneous batch to hold a record of all of the changes made.

The effect of this calculation is to ensure that the new issues remaining are the proper multiple of the old issues remaining. Once that has been established, we adjust the term so that it looks as though the entire subscription had been at the new frequency. We do this so as to minimize the change to deferred income. (If for example, we increased the term by the number of issues added to issues remaining, the deferred income might change substantially.)

Consider the case where you double the frequency for a subscription with a term of 12, issues remaining of 8, and a price of $120. The two cases work out as follows:

 

 

Extend term
by full factor

Extend term
by increase in
issues remaining

Old term

12

12

Old issues remaining

8

8

Old deferred income

$80

$80

New term

24

20

New issues remaining

16

16

New deferred income

$80

$96

 

Once you have run the program, you must use the issue definitions menu item to change the issue dates on all issues from the current issue forward. Depending on the nature of the change, it may be easier to delete all future issues and recreate them. You must also change your publication definition to reflect the new number of times per year that your publication will be published.