07-23-2012 02:19 PM
Upgraded ACT database to Act 2011 and Word 2000 to Word 2010- all Word mail merge documents didn't translate properly so learned to manually rebuilt fields but formula calculations won't work- working in a table, need to use fields to bring $$$ value of (ACT field-cost )minus (ACTfield -agency fee) to get subtotal then calculate 13% of subtotal for GST and add Subtotal and GST for total. HELP!!!
07-24-2012 07:16 AM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
07-24-2012 02:40 PM
The formulas were created in a Word 2000 table. B6 is Act field- Ad Cost and the next one below B7 is Act field-Agency Fee. both are dollar amounts B8 should be a subtotal of B6 minus B7 (B7 will often be $0.00) and then B9 (taxes) should be 13% of subtotal to get B10 Total. Above these are B1 -B5- insertion dates, ad type etc all ACT fields.