Product Lines

In AccountMate LAN, Infor F9, MKT Level 3 Credit Card Processing by Kevin Stroud

Dear AccountMate Clients,

I often talk about the AccountMate “product lines,” which can be confusing if you don’t sling the lingo on a daily basis, so wanted to take this opportunity to describe them – especially since there’s an important addition happening.

The three product lines are defined by the technology used to implement them and are LAN, SQL and Enterprise.  A good analogy is that Chevrolet makes the Equinox, Tahoe and Suburban models – all made by the same company, but different in look, feel and functional specifications.

AccountMate LAN is the OG of the AccountMate financial and accounting software suites.  With direct roots that go back to the early 90s, it’s a mature platform (translation: well-tested and very solid) but since it uses a file-based database system only scales well to about 10 concurrent users – and at 20 concurrent users is really starting to sweat.  Also, being a file-based database system, this platform is more susceptible to spurious network issues and data corruption.

AccountMate SQL has been the flagship product since its release in the late 90s as one of the first mid-tier accounting systems using client/server architecture – which allows it to scale to 100+ concurrent users and operations as large as 1,000,000+ customer invoices and 40,000 warehouses (nope, not kidding on that part!).  As the most popular AccountMate product, there’s a healthy variety of 3rd party plug-ins to enhance your operation in areas like EDI, e-commerce, reporting, wireless bar coding, integration to UPS/FedEx, and many others.

AccountMate Enterprise began its phased release in 2017 with the shipment of the General Ledger, Consolidated Ledger, Accounts Payable and Bank Reconciliation modules.  Also a client/server architecture using Microsoft SQL Server as the database, the “front end programming” is done in the very latest development tools (Microsoft C#.Net) so the user interface is cutting edge.  Numerous additional modules are scheduled to ship later this year and we/NexLAN are currently beta-testing them with good results.  Enterprise offers the functionality and flexibility (yes, source code available!) of the SQL product with improvements across the board – and you’ll be hearing a lot more about it in the coming years.  In fact, there’s an AccountMate Enterprise Sneak Peek Webinar on Tuesday, July 10th, at noon CDT – register here.

All product lines are viable for their niches and completely supported by AccountMate and NexLAN – and hopefully the explanation above helps clear up any confusion!

Finally, have received numerous calls and e-mails asking how recovery from my motorcycle crash is going – and am happy to report that I’m on my feet with limited motion in my left shoulder as I get through physical therapy.  Meanwhile, I’m grounded from riding…

Regards,

Kevin E. Stroud
NexLAN, LLC
https://nexlan.com

AccountMate/LAN V9.3 Released

AccountMate/LAN V9.3 has shipped, and we’ve put the update in the mail for our LAN clients with active Lifecycle Maintenance Plans, so run out and stand by the mailbox!

Some of the new features include:

  • Barcode support in the Purchase Order (PO) functions: Create PO by Vendor, by Item, by Sales Order, by Reorder Quantity, Receive Goods
  • Option to Automatically Apply Open Credits to Customers’ Outstanding Invoices after recording Sales Returns
  • GL, AR, AP, PO and SO Import functions Lookup show both TXT and CSV file types
  • Option to Print “Paid in FULL” on the Customer Invoice Document
  • Include the Computer and Handwritten Checks in the AP Check Register Report
  • Additional “Account ID” Filter criterion for the GL Transaction Search Report

If you missed the webinar last week, to see these and more in action check out the 30 minute new feature presentation available on-demand here.


NexLAN Webinar on Real-Time GL Reporting and Integrated Credit Card Processing

Two of the AccountMate plug-ins that always impress are F9 and the MKT Credit Card w/APS – so we’ll be doing a free webinar of them Tuesday, July 24th, at noon CDT – sign up here.

F9 is a real-time interface so you’re “sitting” in Excel and pulling your AccountMate GL data in real-time.  If you build custom financial reports in Excel, then this is THE tool for you.  More info here.

MKT Credit Card is a modification to your Accounts Receivable and Sales Order modules which allows you to preauthorize customer credit cards, charge them automatically upon sales order shipment, or pay their invoices on demand.  When using American Payment Systems, you’re completely PCI compliant (as only credit card “tokens” are stored locally) and enjoy the lowest possible processing rates for customer payments on Sales Orders or Invoices as “Level 3” detail is passed for business class cards.  More info here.


Tech Note: How to Mass Copy your Chart of Accounts

When creating a new company, the Copy Chart of Accounts feature in AccountMate expedites General Ledger account setup and helps achieve consistency in GL Account ID settings across companies, reporting units, divisions or subsidiaries.

This month we publish Article # 1149: Mass Copy of the Chart of Accounts to discuss the procedures and provides tips to effectively use the Copy Chart of Accounts feature.


Technical Tips

Versions: AM10 for SQL and Express
AM9 for SQL, Express, and LAN
AM8 for SQL, Express, and LAN
AM7 for LAN

Module: PR

Q: After printing payroll checks, I noticed that the check amount for one employee is wrong. In order to avoid delay in giving the check to the employee, I issued a handwritten check with the correct amount. How do I correct the payroll record in AccountMate?  

A: To correct the payroll record in AccountMate, perform the following:

  1. Void the check with the erroneous amount using the Void Payroll Check function.
  2. Amend the employee’s payroll using the Amend Applied Payroll function to correct the amount. If the employee’s pay type is Time Card and the amount that must be corrected is the earnings amount, then void the applied payroll. Amend the employee’s time card using the Amend Time Card option of the Time Card/Piece Work function. Apply payroll again for the time card employee.
  3. Post Handwritten Check for the applied payroll. Be sure to enter the correct check number in the Check # field.

■ ■ ■

Versions: AM10 for SQL and Express
AM9 for SQL, Express, and LAN
AM8 for SQL, Express, and LAN
AM7 for LAN

Modules: SO, MI

Q: I attempted to create a work order from a sales order by entering the SO # in the Create Work Order > Information SO # field; however, the sales order line items were not copied into the work order. What should I do to copy the sales order line items into the work order? 

A: Perform the following:

  1. Access the Create Work Order function; then, click the Copy button in the toolbar.
  2. Select the Sales Order option in the Copy Work Order Record window; then, enter the SO # in the SO # field.
  3. Click Copy.

■ ■ ■

Versions: AM10 for SQL and Express
AM9 for SQL and Express

Module: AR

Q: I drill down on the Total Paid amount value in the Print Invoice report. The Payment Distribution Report displayed by AccountMate does not include the applied credit from sales returns. What am I missing? 

A: The Payment Distribution Report transaction report macro was not set up to include applied credit from sales returns. To include those, perform the following:

  1. Click the Report Setup Options button from the System toolbar and select Report Setup.
  2. Go to the Report Macro tab.
  3. In the Review Macro for Transactions area, select [AR] Payment Distribution Report from the drop-down list.
  4. Click the Review Macro Settings button beside the drop-down arrow.
  5. In the Payment Distribution Report interface, mark the checkbox for Include App Credits from Sales Returns.
  6. Click the Save button in the Macro field.
  7. Click Yes when asked whether you want to overwrite the macro.
  8. Close the report interface.
  9. Click the OK button on the Report Setup window.

■ ■ ■

Versions: AM10 for SQL and Express
AM9 for SQL, Express, and LAN
AM8 for SQL, Express, and LAN
AM7 for LAN

Module: AR

TIP: Voided payments (negative amount) will only appear in the Record Bank Deposit function if you answered “Yes” when you were asked the question, “Did you actually deposit this in the bank? [Y/N]”, during the voiding process. 

Notes: 

  • If the payment is voided before you record the bank deposit for the payment receipt, then the Record Bank Deposit function will show two records: 1) It will show the payment receipt (positive amount) 2) It will show the voided payment (negative amount).
  • If the payment is voided after you have recorded the bank deposit for the payment receipt, then the Record Bank Deposit function will only show one record and it is the voided payment (negative amount). 
  • If you select “No” to answer the question whether the payment was deposited to the bank and the payment was actually part of a bank deposit, then AccountMate will display a message informing you that the payment is included in Deposit # [XXX] and you have to use the Amend Bank Deposit function to remove it from the deposit before you can void the payment. 

Subscription Information

If you or someone else in your office would like to receive NewsLine in your inbox each month for the latest AccountMate news and tips, please email newsletter@nexlan.com.