What table does Sage Pro 7.4 use to format ACH

The table name is "sydfrmd". This is used for both AP and PR (I think). You can modify this to suit the customer's bank's format.

Power tools for XP

http://www.microsoft.com/windowsxp/downloads/powertoys/xppowertoys.mspx

The above link allows you to get nice tools if you are using Windows XP.
The tools I like are:
1. Resizing Pictures (you can select multiple pictures in Windows Explorer,
Right Click, Choose "Resize Pictures", then choose what size you want and
they are resized (to new files, you can have them replace the original too).

2. Command Here: Allows you to load the command prompt from the folder you
are viewing in Windows Explorer.

Sage Pro 7.4 import enhancements

Just wanted to list all the Sage Pro ERP 7.4 (Pro 7.4) enhancements regarding importing (butverify since I am not sure what made the cut) :

  1. Pro 7.4 supports importing of Sales orders
  2. Pro 7.4 supports importing of Purchase orders
  3. All the standard imports now support allowing to map for all types(including Excel).
  4. You can save the mapping for re-use (will be useful if you importedfrom PeachTree once and mapped the fields, you can keep re-using thisagain)
  5. Pro 7.4 supports Excel importing of item pricing (and price groups).
  6. Other miscellaneous ones (check what's new for details)

P.S.: I have posted this as an answer in the loop

Message Master auto set print fax for statements

If you are using Sage Pro ERP message master and want statements to be either emailed or faxed based on which customer it is being sent to, you can do that. The "code" field in customer maintenance can be set to FAX, EMAIL. See code from that section below

DO CASE
CASE (lc_Work = "FAX" OR lc_Work = "FX" OR lc_Work == "F") AND .sl_Fax
lc_Return = "Fax "
CASE (lc_Work = "EMAIL" OR lc_Work = "EM" OR lc_Work == "E") AND .sl_Email

lc_Return = "Email"

Here, lc_Work can be code field in AR. In message master setup, you can even change the field