When you create your own invoices, you can add bar codes to the invoices that include the customer account number and the total amount due. The Checkdigit function calculates an IBM Modulus 10 checksum for a string of numbers. The following steps describe how you can incorporate bar codes into your billing reports and invoices.
-
Load a bar code font. (for example, RiversEdge which has both micr and bar code font software available.)
-
Back up your current reports.mdb database.
-
On your invoice report (in Microsoft Access), set up a new field that will contain the data that is to have the CheckDigit and font applied.
-
Using the properties function on the new field, add the function call: =AppendCheckDigit_IBM_Mod10(AppendCheckDigit_IBM_Mod10([CustomerAcctNumber])&""& AppendCheckDigit_IBM_Mod10([TotalAmountDue])), with the appropriate data fields to the Control Source.
-
Select the bar code or micr font from the FontName drop-down list box.
-
Save the modified report and import it into the Bill Printing and Reporting module.