Saturday, December 21, 2013

Crystal: making sense of the AUDTDATE and AUDTTIME fields

Each Sage 300 ERP table has an AUDTDATE and AUDTTIME field, these store the date and time a record was last modified in the database. The date and time is stored in UTC time and needs to be converted to your local time zone to make sense.

Here is an example of a Crystal Reports formula to convert to your local time zone taken from your computer's OS settings:

ShiftDateTime (pwformatdate({GLPOST.AUDTDATE})+pwformattime({GLPOST.AUDTTIME}),"STD,0" ,"" )

AP: Printing MICR checks

The AP check report can be formatted to print MICR encoded checks from AP. You need a MICR font and the MICR line needs to be placed in the correct position on the printed check.
Read more about MICR here
The MICR font is installed when you install Aatrix and this is what the characters look like:



And this is the AP check: