I have recently changed this page so as to give details original procedures that I have developed, rather than give actual code samples. My reason for this is that this web is targeted to the consumer, rather than the developer. There are many procedures available in code libraries etc, and anyone who is seriously interested in development will be able to read as much basic code as they want in any of the publications listed in the "Books" page. All procedures have been developed by me. (Roy Fellows)

Procedure: Return of APR (Annual Percentage Rate) relative to credit instalment agreements.

Uses algorithm of successive comparisons. The code has nested looping procedures with values contained in array variables. 

Procedure: Calculation of Default Interest in Credit Installment agreement:. 

Payment entry event driven procedure assesses APR based default interest and creates date stamped entry in account related recordset. A manual update is used for anyone who stops paying intalments. 

Procedure: Simple "Final doc fee rebate formula", basically, a mathematical formula rather than a code procedure

Simple mathematical formula for calculation of Rule of 78 rebate on agreements where a documentation fee is charged on the final installment. 

(This has now been made obsolete by new regulations)

Procedure: Automated packing list creation for export cartons: 

Automatically assigns products from a sale order/invoice to standard cartons entered into the system. Any "overflow" of items can be manually designated on a "had hoc" basis. A full packing list with cartons listed in successive order is then generated. e.g. Carton numbers 1-4 each contain x parts, part no yyyy, Nett xy kilo, Gross yx kilo Carton number 5 contains y parts, part number xyyx, Nett xx kilo, Gross yy kilo"  Carton number 6 contains xy parts, part number yyx; yyx parts, part number xxy, Nett x kilo, Gross y kilo.

TOTAL NETT WEIGHT XXX

TOTAL GROSS WEIGHT XXX

Developed for Howell Tomkins Ltd

Procedure: Return of current "Book Value" of fixed assets after depreciation.

Automatically calculates present book value of fixed assets on either the Reducing Balance or Straight Line method on a monthly basis . Intended to mirror writing down allowances. Purchase costs are posted to the Asset Register instead of the Nominal Ledger if a Nominal Code is defined by the user as relating to an asset rather than an overhead. After that, values are maintained automatically by the system and will be included in Trading Profit and Loss Accounts.

Procedure: Return of accumulated compound interest, charged either monthly, weekly, or daily relative to revolving credit type account.

Account 'On Open' event driven procedure. Uses looping procedures to calculate interest from last update. Interest rate can be varied during life of agreement as can the charge period. Procedure will not only record the interest but the interest rate and charge period. e.g. dd/mm/yy £32.62 Interest charged monthly at 14%

Procedure: Automated creation of 6 figure Nominal Codes used for accounting purposes or automated part numbering system.

These are numbers, usually four digit, whereby the first pair of digits represents a main category, the second a sub category. Originally, they were used in the old DOS programs, the user manually entering a nominal code with each transaction. The program could then group, sort and total information for accounting purposes. Windows based programs does this just as well on a text value, more easily understood by the user, however many programs with accounting features still use a nominal system. Problems can arise whereby a user does not enter a number correctly due to lack of understanding, and thereafter accounting features produce garbage. I have developed an automated process whereby the numbers are produced automatically and a user simply enters a description. The software will then use the nominal codes so produced as indexes, rather than the usual 'RecordID' produced by Microsoft Access auto numbering system.

The main reason I developed this was for the automated numbering of parts. Illustrating by example, suppose a company produces tableware. There will be a range of different designs, round base, octagonal base, or whatever. A range of models, small plate, saucer etc. And a range of colors, plain white, gold inlay, willow pattern etc. Well if a new colour is added, the user simply enters a new record ' Nominal Colours', clicks "Update Records", and a whole range of new part numbers will be instantly created by the system. The above example would use a six figure number. First pair for design, second for model, third for colour. Each pair would start at 10, (computer wont allow a leading zero) and go up to 99. So each pair of digits could cover up to 89 variations. The total number of part numbers possible would be 89 to the power of 3, or 704,969 different parts.  The really good thing is that the logic of this is so good employees would quickly lean part numbers of top of their heads. The system could establish grouping levels for reports and stock lists and automatically created web pages etc.

Procedure: Calculation of early settlement discount on credit installment agreements according to the new 2004 regulations

Uses the Microsoft Data Access Object (DAO) to parse an open recordset of the debtors repayments in order to calculate the interest element , this is then used to return a settlement figure according to the new government regulations.