Searching in the GL Transaction View window can be limited to only certain types of transactions, by power searching for transaction key values beginning with certain letters:

A = Adjusting Entry

C = Check

I = Invoice

M = Inventory Maintenance

P = Purchase Order

R = Receipt

T = GL External Transaction

V = Voucher

W = Warehouse Transaction

Access to System Logs is found under the Administration module. By default the following actions are always recorded in System Logs:

• Check Runs Canceled: The user name, date, time, and check detail are recorded when a user cancels a check run.
• Data File Maintenance: The user name (Administrator), date, and time are recorded when the data maintenance procedure is performed.
• General Errors: This is recorded when the Company Name has been changed in System Setup.
• Log In/Out: The user name, date, and time are recorded for every log in or log out.
• Version Log: The user name and old and new version numbers are recorded when an upgrade is first launched.
• Log On Errors: The user name, date, and time are recorded when an error message is displayed to a user on login (for example, a message that the current date is not within an open fiscal period).
• Scheduled Script: Error details if an error occurs when a scheduled script is executed.

Optional logging

The following actions are recorded if elected via System Configuration:

• List View Query: The user name, date, time, and search criteria of every list view action. This includes Show All, Quick Search, Power Search, Cross-reference, and Filter.

Enable this option by going to Administration ➤ System Configuration ➤ List View and set the value for List View Query to True.

This article will address the proper procedure for opening text files when using Microsoft Excel®. These steps are especially important when creating and working with templates that will be used to import data into Acctvantage.

When opening and working with text files in Excel, the following formatting issues can arise: 

1. Leading zeroes are dropped.
2. Date formatting is lost.
3. General Ledger Account Codes revert to Scientific Notation (ex: 2.10E+10).
4. Quotes are added to text, unfortunately these quotes are only visible when opened with a text editor or after importing data.

To avoid these issues, open the documents using the following procedure and always review your data before importing using a text editor other than Excel.

The Imports and External Transactions area allows you to bring accounting information from legacy systems, production systems or third-party software into your AcctVantage system.

The External Transaction mechanism allows you to import post-able General Ledger, Accounts Receivable/Payable, and Inventory Sub-ledger transactions into AcctVantage from other software. Typically, this is used if you have specialized production software, unique sales orders, etc. While AcctVantage is fully customizable to accommodate your company’s unique needs, by using the External Transactions process, we are often able to provide unique functionality without affecting the core product. This makes system upgrades and maintenance much easier, not to mention cheaper!

Please see the Journal Entry Import article for more information.