Addsum Avanced Accounting

Adv main

Adv icon

Addsum utilities for Advanced Accounting 7i (and 6.1)
The popular Addsum utilities is a separate low cost add-on that integrates with standard Advanced Accounting and provides special options such as the ability to unpost a sales invoice and options that help with identifying or fixing out of balance situations. Because they evolved as a separate set of utilities for prior versions of Advanced Accounting (dating as far back as 1994), users have become used to finding them in this self-contained module.
Once installed, the Addsum utilities option under module UT (option G) becomes immediately operational and when selected, a menu will appear in place of the normal menu caption as shown above. Options can then be selected from this menu.
New to this version: The latest utilities include an option to unpost an accounts receivable payment on account and restore amounts remaining (including any applied payments) to their pre-payment status. Other new utilities include the change salesperson and change terms options, GL (general ledger) balance by day report and our DataScanIntegrity utility. And, the utilities now also include our OpLock Set Utility at no additional cost. All utilities have been completely updated to be compatible with the latest version of Advanced Accounting and to take advantage of its new features (such as the transactionalized general ledger).
The unpost invoice and unpost customer payment options alone are for most users easily worth the small cost of these utilities.
Requirements: Advanced Accounting 7i (or 6.1 rel. 12 for the 6.1 version) or higher must first be installed.
Cost/order: The cost of the utilities is $99 ($49 if upgrading from prior version of Advanced Accounting). To order either call us at 800-648-6258 or order from our Store page.
Program options:
Sales Invoice utilities
Unpost Sales Invoice
Delete range of S/Os
Change salesperson
General ledger utilities
Mark cleared deposits
Balance AP and AR with GL
Balance detail by GL account
Find GL out of balances
One-sided G/L entry
Balance inventory with GL
Clear Budget
GL Balance by Day report
Accounts Receivable utilities
Merge AR Customers
Check for Duplicate AR Inv
Fix AR statement
Unpost AR payment
Inventory utilities
Synchronize IC units
Pending S/O line items
Zap binary zeroes
Check for Bad GL Account
Merge Inventory Codes
Check for Negative Units
Check for duplicate locations
Purchase Orders utilities
Delete range of P/Os
Accounts Payable utilities
Merge A/P Vendors
General utilities
Fix blank records
Check for open files
Change terms
Set oplocks
Check file integrity
Brief description of above options:
Unpost a sales invoice: Reverses the posting process of a previously posted sales invoice. (Audit trail remains.)
Delete range of sales orders: Allows a user to delete a range of sales orders.
Change salesperson: Allows you to change or transfer the salesperson number assigned to customers, pending sales orders, recurring sales orders, and optionally AR aging and sales invoice history from a prior salesperson number to a new one.
Mark cleared deposits: Facilitates the marking of deposited checks as an aid to bank reconciliation.
Balance AP and AR with GL: Assists in verifying AP and AR balances.
Balance detail by GL account: Assists in reconciling chart of account balances to GL detail.
Find GL out of balances: Tracks down any/all out of balance entries in your GL detailed trial balance file for a given date range.
One-sided G/L entry: For use in exceptional situations.
Balance inventory with GL: Reconcile inventory value with GL inventory balances.
Clear Budget: Easy way to clear budget values.
GL balance by day report: Quickly and easily see which days in any desired date range had posting activity and verify that they were in balance.
Merge AR customer: Combine two different A/R customers into one.
Check for duplicate inv nos: Check for any duplicate assigned invoice numbers with user ability to delete.
Fix AR statement: Remove offsetting entries from customer statements. Often used when unposting sales invoices.
Unpost AR payment: Allows a user to undo a customer AR payment. (Audit trail remains.)
Synchronize IC units: Does on a global basis or for a certain range of products what a user could otherwise only do on a one-by-one basis under option G under I/C.
Pending S/O line items: Performs an integrity check to ensure that there is a matching sales order "header" record for each pending sales order line item. Removes stranded line items.
Zap binary zeroes: Binary zeroes are unseen characters that in certain alphanumeric fields can create GL posting and other problems. This utility removes them.
Check for Bad G/L Account: Checks inventory files for GL codes that either do not exist in the chart of accounts or that are in the wrong category.
Merge Inventory Codes: Combines two product/part codes into one.
Check For Negative Units: Identifies inventory units that are negative.
Check For duplicate locations: Identifies any duplicate (or multiple) product code-location records and allows for user controlled deletion.
Delete range of purchase orders: Similar to the sales order utility but for P/O's.
Merge A/P Vendors: Combine two vendor codes into one.
Fix blank records: Scans through certain files and removes any invalid blank or empty records.
Check for open data files: Checks to see what Advanced Accounting files are currently open.
Change terms: Globally change a terms number to another terms number throughout the system.
Set oplocks: See Addsum OpLockSet Utility.
Check file integrity: Scan data to determine physical integrity of any or all files within a given dataset.

Copyright © 2005-2013 ADDSUM BUSINESS SOFTWARE, INC.
All Rights Reserved

portions of Advanced Accounting are:
Copyright © 1985-2003 MGM Holdings
All Rights Reserved