Dear Clients,
We’ve heard from numerous clients lately who have analyzed their sales with The 2nd Most Important Report: AR Profit Margin and now need to adjust pricing to maintain margins in the face of increased labor and raw material costs. So this month we would like to provide an overview of the built-in AccountMate pricing logic functionality—along with some common enhancements you might find useful.
Also, don’t forget a few months ago we discussed Landed Cost functionality to include increasing shipping cost in your item cost—which would directly impact your sales/profit analysis on a per-item basis. Possibly an important consideration for your business!
The good news is AccountMate provides flexible pricing functionality—allowing you to define pricing on a granular level to satisfy your customers’ demands and maintain the margins necessary. In order of priority, meaning the first one encountered will be selected, the pricing levels include:
- Customer-Specific Pricing: I often refer to this as brother-in-law pricing as it’s usually the lowest pricing and only applies to a small number of customers. This is used sparingly as it can be tedious to maintain specific pricing for every customer for every item.
- Group/Quantity Pricing: Item pricing can be defined for “Customer Groups” (such as bronze, silver, gold) or can be defined for quantities (1-9 are $1.00 each, 10-19 are $0.95 each, 20+ are $0.92 each). If you close one eye and stick your tongue out of the corner of your mouth, these can even be combined to quantity price breaks within customer price groups.
- Unit of Measure Pricing: Analogous to quantity price breaks, you can define pricing for the same item being sold in different units of measure such as $1.00 “EACH”, or $5.50 “6PACK” or $20.00 “CASE24”.
- Special Pricing: This is best characterized as “Limited Time Sale Pricing,” allowing you to define pricing only available for a specific time period—yes, with a start date and end date.
- Unit Price: Also called “List Price” or MSRP, this is the default price if no other condition applies.
Need More? While the built-in pricing methods cover most scenarios, we have the flexibility to get even more complex with customization. The two most common modifications are to combine different items in the quantity price breaks (e.g., if you order six regular and six diet, you get the quantity pricing for twelve on both items), or to define different price groups for different inventory classes, groups or product lines for the same customer (e.g., customer is “gold” for two classes, “silver” for another class, and has no price group defined for the remaining item classes so they would receive unit/list price for them).
Finally, besides ensuring consistency in the pricing your customers receive, having pricing defined in the system also accelerates the order entry process—particularly with newer employees who otherwise might have to manually look up pricing from outside sources. Thus, in addition to improving your margin, your overworked sales staff will thank you making their job easier. Win! Win!
Regards,
Kevin E. Stroud
kestrou@nexlan.com
NexLAN, LLC
https://nexlan.com
New Class April 21-22 for the AccountMate SQL Manufacturing Module
We’re pleased to make you aware of AccountMate’s new online class for the Manufacturing module, to be held April 21-22, 2022.
This course is recommended for new AccountMate Manufacturing users to ensure the correct setup and effective implementation of the AccountMate Manufacturing module. It’s also recommended for existing AccountMate Manufacturing users to review their current setup, brush up on the latest features and reports, and learn how to effectively maintain their AccountMate Manufacturing solution.
You can register for one or both classes; each is $400. This special class doesn’t qualify for free seats with Lifecycle maintenance.
➤ April 21, 2022, Session 1 (3 hours) Module Setup and Master Records
➤ April 22, 2022, Session 2 (3 hours) Transactions, Reports, and GL Integration
See more info on AccountMate’s website:
Send any questions our way and we’ll get you answers!
P.S. While we’re talking about training, the next AccountMate SQL/Express online Core Product Training will be held from June 2 – July 7, 2022, with two sessions per week and registration will open in April. Check out full details in last month’s NewsLine.
And, mark your calendars for a Payroll Module training class, newly scheduled for September 12-16, 2022. More details to follow and registration will open in June.
March 9 Webinar: REPAY Realtime Electronic Payments for AccountMate
Would you like to increase the payment options that you offer your customers? They’ll appreciate you making it easier and more convenient to work with you, and you’ll appreciate collecting payments faster and with a lot less work on your part.
While you’ve heard NexLAN extoll the virtues of REPAY’s Level 3 credit card processing (which reduces your credit card transaction fees), this AccountMate add-on does much more, too.
From one central place you can manage all things AP and AR:
- Reduce processing times by eliminating manual entry
- Streamline operations and lower admin costs
- Increase data security and simplify PCI compliance
- Improve visibility and reporting
- Save on B2B transaction fees with Level 3 Processing
And on the AP side, all paper and manual processes can be eliminated to automate your vendor and supplier payments and simplify your reconciliation. There’s real-time reporting, instant funding disbursements, and payment and messaging management. REPAY is your one-stop-shop for incoming and outgoing payments.
We’ve seen that REPAY does a terrific job with their webinars and one-on-one demos, so do consider registering for their March 9 webinar with AccountMate to learn more about enhancing your payment processes. Or reach out to NexLAN to schedule an online demo specific to your payment processing questions.
Register for the webinar to see how REPAY works with AccountMate.
March 9th (Wed), Noon – 1:00pm CST
AccountMate Tech Note: Understanding the Transaction Type Codes in the General Ledger Listing
The General Ledger Listing (GL Listing) report is a useful tool to verify each GL Account ID’s debit and credit transactions, which are either posted from the General Ledger module or transferred from the subsidiary modules. You can generate the GL Listing in the General Ledger module.
Article #1192: Understanding the Transaction Type Codes in the General Ledger Listing identifies the different transaction type codes used in the GL Listing, the function that was used to create the journal entries, and a short explanation about the transaction.
AccountMate Tech Note: Understanding the Inventory Transaction Log
You can generate the Inventory Transaction Log in the Inventory Control module to monitor inventory item transactions.
Article #1159: Understanding the Inventory Transaction Log provides information about the Inventory Transaction Log criteria on the report interface and the report columns available in the report preview. It also enumerates the transaction type codes, discusses the transactions to which the codes correspond, and explains the effects that these transactions have on inventory cost and quantity.
AccountMate Tech Note: Reconciling the Inventory Transaction Log with the Inventory General Ledger Account Balance
Inventory is a valuable asset for manufacturing or merchandising companies. Businesses place high importance on properly valuing inventory because it has a major impact on financial statements and tax reporting. The Inventory Transaction Log is a helpful tool to ascertain the accuracy of your inventory value and to effectively reconcile it with the Inventory GL Account ID balance.
Article #1193: Reconciling the Inventory Transaction Log with the Inventory General Ledger Account Balance discusses the factors to consider when reconciling the Inventory Transaction Log total cost with the Inventory GL Account ID balance. This document also provides tips for reconciling inventory balances.
AccountMate Technical Tips
Versions: AM12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL, Express, and LAN
AM9 for SQL, Express, and LAN
Module: GL
Q: How do I amend or void a recurring JE template?
A: To amend or void a recurring JE template, perform the following:
1. Verify the recurring JE Batch #. Run the Recurring JE Template report to verify the batch #.
2. Access the Journal Entry Transactions function.
3. Select the Amend Batch option.
4. Enter the batch # verified in step 1.
5. Enter your changes and click Save to amend the recurring JE template. Or click Void to void the recurring JE template.
■ ■ ■
Versions: AM12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL, Express, and LAN
AM9 for SQL, Express, and LAN
Module: GL
Q: I encountered the message, “Unposted Batch for prior year exists.” How do I proceed?
A: The message appears because there are unposted journal entries for the prior fiscal year. To proceed, generate the Unposted Journal Entries Report and review the unposted journal entries. Using the Post JE Batch to GL function, post all the valid, unposted journal entry batches. Void any unposted journal entry batches dated in the prior fiscal year that must not be posted.
■ ■ ■
Versions: AM12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL, Express, and LAN
AM9 for SQL, Express, and LAN
Module: All Modules
TIP: Entering a purge date when you close fiscal periods in the subsidiary modules or a purge year when you close the fiscal year in the General Ledger module is not a requirement. If a date or year is entered in the Purge fields, completed transactions that are dated on or before the purge date/year will be deleted from AccountMate during the closing process. These deleted records cannot be restored; thus, before you perform the closing, review the date/year entered in Purge fields. If you do not want to delete records in AccountMate, leave the Purge fields blank.
■ ■ ■
Versions: AM12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL, Express, and LAN
AM9 for SQL, Express, and LAN
Modules: IC, KT, SO
TIP: When you customize a kit item in the sales order, the booked quantity of the pre-built kit item is not updated. Since the kit formula changed, it is only fitting that the booked quantity is not updated since the pre-built kit item will not be used in the sales order. When the customized kit is built, the on-hand quantities of the components are directly reduced based on the customized kit formula.
Subscription Information
If you or someone else in your office would like to automatically receive our NewsLine in your inbox each month, please email newsletter@nexlan.com.
