Dear AccountMate Clients,
The release of AccountMate Version 7, for both LAN and SQL platforms, included something unusual in the mid-tier accounting software world: an Upsell Management module. Since that’s not a “common accounting module” like Payables or Receivables, it took a little while to catch on. But numerous clients are now realizing the increased per order sales it delivers.
Simply put, the Upsell Management module allows you to maintain a list of accessory or upsell items that are available for sale with other inventory items, then view and select these upsell items when entering customer orders or invoices. It also allows you to create a script or provide special instructions that your sales team can use as a guide when selling these upsell items and it then separately tracks them for commission purposes.
Integrated to AccountMate’s Sales Order, Accounts Receivable and Inventory Control modules, besides increasing sales it also ensures the correct accessories (example: applicable car charger for a specific cell phone) are the ones suggested – increasing order accuracy and decreasing customer returns.
The Upsell Management module is priced the same as other AccountMate modules and for more information please click here for LAN, or here for SQL or SQL/Express.
On the running front, just finished my 4th consecutive Boston Marathon two weeks ago and had an excellent race. As the oldest annual marathon in the world and one of only two marathons in the U.S. to require qualifying times (the other being the Olympic Trials), few races compare in prestige – so I’ve made it my goal to continue my streak of running it for as long as I can. Ran a time of 3:13:28, finishing in the top 15% of this elite field and beating my qualifying time for next years Boston by more than 17 minutes. Have been weighing my options for my upcoming goal races and, while I plan to focus on improving at marathon distance, am already planning to run a complete Trans-Illinois in late June. The challenge won’t be cold and rain as it was last time (http://kestrou.com/transillinois), it will be heat…
Regards,
Kevin E. Stroud
NexLAN, LLC
https://nexlan.com
Tech Note: 1099-Miscellaneous Reporting in AccountMate
Trading or business organizations must prepare and file 1099-MISC forms to report miscellaneous income for individuals and companies that are identified in AccountMate as independent contractors and 1099 vendors. Even non-profit organizations are required to report the payments made on transactions that qualify for 1099 tax reporting.
AccountMate allows you to record 1099 transactions, generate 1099 reports for internal purposes, and print the 1099 forms for tax reporting purposes. This article discusses how to set up the 1099 requirements and how to create 1099 transactions in both the Payroll (PR) and Accounts Payable (AP) modules. It also provides information on the PR and AP 1099 reports.
Article 1171: 1099-Miscellaneous Reporting in AccountMate
Tech Note: Maximizing the Use of the Table Browser and Exporter
Browsing AccountMate tables is useful for verifying information or evaluating data to fix data corruption. The ability to export data to formats including Excel, VFP tables, Lotus, and Text extends the scope of AccountMate’s powerful reporting tools. The Table Browser & Exporter function lists all tables of the company database that is currently open and lets authorized users browse and export them.
This TechNote provides information that facilitates a better understanding of the Table Browser and Exporter function to maximize its use. Click on the article’s title below, to access the document.
Article 1146: Maximizing the use of the Table Browser and Exporter
Tech Note: Understanding How AccountMate Handles Special Characters in Key Fields
Understanding the capabilities of your system enables you to fully maximize its usage. It is also important that you are aware of its limitations. Knowing these limitations helps you plan how to more efficiently manage your system. One of the most common limitations in accounting software is that of handling special characters. In AccountMate, we refer to these characters as “illegal characters.” This TechNote provides you with a list of characters that are illegal in AccountMate and examples of possible problems that you may encounter when illegal characters are used. Click on the article’s title below, to access the document.
Article 1194: Understanding How AccountMate Handles Special Characters in Key Fields
Tech Note: Maximizing the Customer and Vendor Activity Analysis Feature
Nurturing your business relationships with your customers and vendors is very critical. It is one sure way to gain profit, to enjoy smoother business operations, and to achieve long term success. One key step to building strong business relationships with your customers and vendors is to provide them excellent service. You need to keep in touch with them on a consistent basis, to better understand their needs, and to quickly and efficiently respond to these needs. AccountMate’s Customer and Vendor Activity Analysis feature helps you provide excellent service by facilitating the storage, maintenance, and tracking of your customers and vendors activities.
Article 1286: Maximizing the Customer and Vendor Activity Analysis Feature
Holiday Closing
NexLAN will be closed on Monday, May 31, 2010 for the Memorial Day Holiday. If you don’t have our latest emergency contact list, hit <reply> and we’ll gladly send you a copy.
Technical Tips
Versions: AM7 for SQL and Express
AM6.5 for SQL and MSDE
Modules: SO, AR, CI
Q. How can I view customer inventory item historical prices?
A: Perform any of the following to view these inventory item historical prices:
- Click the Show Price History button in Customer Inventory Maintenance to display the Price History List area. You can view the history prices only if you have previously run a price update using the Customer Inventory Price Update function.
- Run Customer Inventory Listing, and mark the Include Price History checkbox.
■ ■ ■
Versions: AM7 for SQL, Express and LAN
AM6.5 for SQL, MSDE and LAN
Modules: GL, IC, PO, AP
Q: I generated the General Ledger Listing report for an inventory GL Account ID and noticed that there were CADJ (cost adjustments) entries coming from the Accounts Payable (AP) module. Why are the CADJ entries shown as coming from AP when the AP module does not have any function that generates these cost adjustments?
A: These CADJ entries are system-generated cost adjustments that result from Cancel Received Goods transactions performed in the Purchase Order (PO) module. Transactions from AP that are transferred to General Ledger during Transfer Data to GL or Period-End Closing include PO transactions (e.g. accrued received goods); thus, the CADJ entries that result from canceling received goods are shown as coming from AP on General Ledger Listing.
Note: Starting in AM7 for SQL, Express and LAN, AccountMate assigns the “CADJ” transaction code (instead of “IADJ” which is used in lower versions) to easily identify system-generated cost adjustments.
■ ■ ■
Versions: AM7 for SQL and Express (AM7.4 and higher)
AM7 for LAN
Module: PR
Q: Some of my employees are paid using direct deposit (electronic payment) and some are paid using checks. When I printed payroll checks, I noticed that dummy checks are also printed for those employees who are paid using direct deposit. These dummy checks are using valid check numbers; and are, therefore, wasting good checks. How do I save the valid checks for actual payroll check payments?
A: You can perform separate payroll check printing for employees not set up for electronic payment and employees set up for electronic payment. To do this, perform the following:
- Access the Print Payroll Check function; then, in the second Print Payroll Check window, unmark the Process Direct Deposit checkbox to exclude the electronic payment transactions from the printing of check process.
- Verify that the Starting Check # field shows the correct check number; then, proceed to print pay checks for employees not set up for electronic payment.
- Access the Print Payroll Check function again and this time, unmark the Process Printed Check checkbox in the second Print Payroll Check window.
- To ensure that valid check numbers will not be used during printing, enter in the Starting Check # field a number from a sequence different from the valid check number series; then, for employees set up for electronic payment print the non-negotiable (dummy) pay checks using ordinary paper. In the next payroll run for electronic payments, be sure to enter in the Starting Check # field a number that is contiguous to the last non-negotiable check number issued so that you will have a continuing check # series.
Subscription Information
If there is someone else in your office who would like to receive this NewsLine, please email newsletter@nexlan.com. In the meantime, browse through our archives.
If you would like to discontinue your subscription to this NewsLine, please click here.
