In the Acumatica Funds Transfers window, you can transfer funds from one cash account to another and include related service charges. Additionally, you can view the details of the recorded funds transfers. Funds can be transferred between accounts denominated to different foreign currencies. The system performs currency conversion by using the base currency and the … Read more
Category: Acumatica
Creating Work Calendars in Acumatica
There are many instances when you need different calendars for various uses. For example: A calendar assigned to contract templates Work calendars for 3rd party add-ons for JAMS (Manufacturing) & Payroll Here’s how: Go to: Organization > Organization Structure > Configure > Work Calendar Once here, this form has common buttons in the toolbar are … Read more
Adding a Header Record to an ACH File in Acumatica
Some banks require additional information in the header section of your ACH file in Acumatica. Here’s how: Your bank has requested you to add the following to the header of your ACH file: The $$ADD record needs to be added to the Header Record Section of the file. RID: ABCDEFG1 BIN: HIJKLM12345678 Below is an … Read more
Creating a Company Tree
When setting up your Acumatica system, you need to make sure you set up a Company Tree. Why? Acumatica uses a hierarchy system for escalating items that need approval; such as: Time cards Requests Requisitions Sales orders Purchase orders This hierarchy system in Acumatica is based on the order of groups specified by the tree … Read more
Closing Financial Periods in Acumatica
To prevent transactions from being posted to the wrong period, it is important to remember to close financial periods during your month-end process in Acumatica. If transactions gets posted to the wrong period, it can affect your financial reports, and that can be disastrous. We’ve created a step-by-step guide, with screen shots, to walk you through … Read more
Acumatica Version 6.0 AR Parent/Child Enhancements
If you already have Acumatica, you need to check these out! If not, send us an email at Marketing@Crestwood.com and see Acumatica for yourself – it’s an amazing system. In the latest release, Acumatica Version 6.0 there are three enhancements I am excited about. These all relate to the Parent/Child relationships. Sharing Credit Verification Rules … Read more
Crestwood Associates Wins Acumatica US Partner of the Year
Recognized for Outstanding Leadership, Growth, and Expertise with Acumatica Acumatica announced at their 2017 annual conference, Crestwood Associates has been named Partner of the Year for 2016 in North America. “This year, we are honored to recognize the expertise and commitment from Crestwood Associates and name them as our top partner in the US,” Jon … Read more
Using Pivot Tables in Acumatica 6
Take your reporting capabilities to the next level with the introduction of Excel pivot tables in Acumatica 6. Pivot tables are one of the key business intelligence tools in Excel, and now you can create and share them within Acumatica without the extra steps of exporting or importing your data. 3 Main Parts of a … Read more
Date Format Formulas ARM
Some of the most common reporting questions I receive are around formatting dates. All date formats are controlled by formulas entered in the Column Set. You just need to enter them as their own line in the Header Section. Here are some tips to get you started. Acumatica Date Formats This formula gives you the Fiscal Period: … Read more
Cash Management in Acumatica – Part 2
Creating and Making a New Payment Method Available on a Cash Account In Acumatica, there may be times when you need to create a new Payment Method to be used with your Cash Accounts. For example, you may have a new payment method if you started using credit cards or accepting credit cards for payment, … Read more
Managing Your Favorites Menu in Acumatica
Do you use Favorites in Acumatica? If not, you’re missing a great organization tool. In Acumatica, you can tag your most frequently used items as Favorites. That way you have quick access to them every day. Here’s some tips on how to manage your Favorites list: To add a new item to your Favorites list, … Read more
Creating a Security Role in Acumatica with Limited Access to Forms
In Acumatica ERP, access to information is controlled by the Security Role assigned to each user account. A role is a set of access rights that allows the security administrator to define access to the system resources down to the level of each form field. Example: We have an Accounting Clerk, in charge of entering … Read more
Cash Management in Acumatica – Part 1
Creating an Entry Type and Making the Entry Type Available on a Cash Account In Acumatica, there may be times when you need to create a new Entry Type to be used with your Cash Accounts. For example: Credit Card Fees Interest Expense Interest Income Misc. Receipt Band Service Charges In order to use your … Read more
Handling Vendor Payments Made by Corporate Credit Cards in Acumatica
Did you know Acumatica has built-in functionality to handle vendor payments made by credit cards? In many other ERP systems, add-on software is required to keep track of vendor payments that are paid by credit cards. Reconciling credit card statement can become a time consuming task if the transaction volume is large. Typically, transactions processed … Read more
Configuring Acumatica to Handle Incoming Credit Card Payments
Most people, now days use credit cards for purchases. One of the things Acumatica handles smoothly is the ability to process credit cards. I’m going to show you how to set up the processing and payment methods for processing credit cards in Acumatica. If you’re using the Acumatica plug-ins for processing credit card payments, there are a … Read more