OK, is anyone else constantly thinking about reporting? Just me? Well in case there are more of you out there – let’s talk reporting in Acumatica. Acumatica’s out-of-the-box reporting tool is called ARM, or Analytical Report Manager, if you want to use its full name. This native reporting tool is one of the many reasons … Read more
Posts by Tiffany
Adding a New Report to Any Screen in Acumatica
Today we get a little technical! This blog will walk you through how to add a new report to any form in Acumatica. We will use the Sales Order form as an example. Note on using the Workflow Engine: The steps below are applicable for forms supporting a new workflow engine. Since the Sales Orders form supports the … Read more
Setting Up Control Accounts to Keep Subledgers in Balance with the GL
Acumatica has added a new feature called “Control Accounts” in the 2019 R2 release. This functionality prevents users from making manual entries to any GL account marked as a control account. As a result, it helps to keep the subledgers in balance with the General Ledger. It’s a very helpful feature. Here is a list … Read more
Adding a Prepayment to a Purchase Order in Acumatica
There are times when you need to pay your vendor a deposit on a purchase order (or in full), before receiving actual items. The vendor may require that deposit before shipping you the goods. Acumatica allows for prepayments to be applied to a Purchase Order, paid to the vendor, and then deduct from the balance … Read more
Setting up Control Accounts to keep Subledgers in Balance with the GL in Acumatica
Acumatica has added a new feature called Control Accounts in the 2019 R2 release. This functionality prevents users from making manual entries to any GL Account marked as a control account. As a result, it helps to keep the subledgers in balance with the General Ledger. It’s a very helpful feature. Here is a list … Read more
Removing Duplicates from GIs in Acumatica
Sometimes you need to add an additional table to a simple Generic Inquiry in Acumatica in order to get data that is not in the original table. If the new table has a many-to-one relationship with the original table, you can see duplicates, (or worse: entries as many times as there are records in the … Read more
Using Business Events with Report Attachments in Acumatica
Business Events are a great way to send notifications to users in Acumatica, when data changes, or events occur. You can now also attach a report to the email notification. The example below is to notify the purchasing manager when a PO is received. It sends an email to this user, and it also attaches … Read more
Month-End Procedures for Acumatica
While all companies have their own internal accounting month-end procedures to follow (and still should), here are some month-end processes that are important to complete each month in Acumatica. Batches from all modules should be reviewed and released/posted that are still unreleased. Recurring entries for that period should be generated and released/posted. All journal entries … Read more
How to Cancel a Drop-Ship PO for Stock Items in Acumatica
A purchase order system from Acumatica helps you reduce costs and improve vendor relationships by automating and centrally managing your global purchasing processes. Acumatica’s online sourcing automates the entire procurement process from vendor quotes to paying invoices. Sometimes we need to reverse a received and invoiced Drop Ship Purchase Order for Stock Items. Here is … Read more
Modifying Acumatica ACH Export Scenarios
A customer’s bank may require modifications to the ACH file that you send them from the Payables module during payment processing. Here are some steps to show how to modify or add additional fields and lines in that file. First, get the bank specifications from your customer or bank. In this scenario, Chase Bank required … Read more
Shipping Made Better with ShipEngine and Acumatica 2019 R2
Shipping options in Acumatica have been limited in the past, but now with Acumatica 2019 R2 and the integration with ShipEngine, you have your choice of over 20 different carriers. Think of ShipEngine as a carrier aggregator; whereas, in the past, you had your choice of FedEx, UPS (no ground options), and Stamps.com with limited … Read more
Backup and Disaster Recovery Plans for Microsoft Dynamics SL, FRx, & Management Reporter (MR)
How would you answer these 3 questions? What would you do if you lost all your customer data? How would you recover from that? Do you have a plan in case of a disaster? Like it or not, data loss does happen. Systems fail, servers die, and power surges. If you don’t have a disaster … Read more
Importing Budgets to Dynamics SL from Excel
Entering budgets directly into Dynamics SL can be a tedious task. No one wants to enter budgets one account or subaccount at a time. To save time and reduce mistakes, it is easier to enter the budget information into Microsoft Excel first, in the proper Dynamics SL format, and then import it. Steps to import … Read more
Missing AR Documents in the Dynamics SL AR Payment Application Window
Recently, we received a call from a client explaining how they were missing AR documents in the Detail area of the AR Payment Application screen in Microsoft Dynamics SL. However, the missing documents did show up on the Aging Report and also showed as “open” in the Customer Maintenance Activity. What’s going on? Where are … Read more
Setting Up QTD Reports in ARM for Acumatica
Acumatica comes with over 250 standard reports; however, one of the most common requests we get is how to set up a Quarter-to-Date (QTD) financial report. Using Acumatica ARM, there’s no hidden columns needed – you just run the financial reports for a Quarter-end period. Here’s How: Here’s an example of a column output for … Read more
Understanding Multi-Currency vs. Financial Statement Translation
Acumatica offers both Multi-Currency Accounting as well as Financial Statement Translation. Many users confuse the two, but they have completely separate functionality. In general, think of it this way. Multi-Currency Accounting is more “converting” a single transaction to a base currency and Financial Statement Translation is more “translating” an entire ledger to any other currency. … Read more
An Alternative Financial Reporting Tool for Acumatica
ARM is a great tool for our customers with typical financial reporting needs. Use FYIsoft when you have the need for more complex financial reporting. FYIsoft is a web-based reporting tool that works easily with Acumatica. Learn how to migrate reports from a legacy ERP system and use FRx or Management Reporter. This saves many … Read more
Top Tips for 1099 Reporting in Acumatica
It’s that time of the year, and we’ve been getting a lot of inquiries on 1099 reporting. Here are a few of the top tips to share with you: If you are getting a blank 1099 MISC report, it’s probably due to the Branch not having the 1099 reporting box checked. Even after documents have … Read more
Dimension Not Found Error in Management Reporter MR
If you use Management Reporter (MR) with multiple companies, you might get an error while generating reports if your companies have different: Subaccount segment descriptions in Dynamics SL Account Formats Segment Names in Dynamics GP Unlike FRx, MR uses the account segment names in the Row and Tree Definition Financial Dimension mapping fields. Let’s take … Read more
Understanding Security Hierarchies in Management Reporter MR
Management Reporter (MR) has many different levels of security, to restrict users to specific companies and reports. Understanding how they work will make it easier for setting up users and distributing reports. User Security – To get started, set up users and assign them company access under the Security menu item in the bottom left corner … Read more
Quick Query Export to Excel Returns Fewer Rows than QQ Results
Have you ever found when you export a Dynamics SL Quick Query to Excel, you don’t get all the rows of data? Here’s some general information and options to fix that problem. Overview In Dynamics SL, you can turn on paging for your Quick Query screen, as well as limiting the number of records returned. … Read more
Divide by 0 Error in FRx
Have you ever gotten the “Divide by 0 Error” when you go to run a report in FRx Report Designer? And to top if off, then the report does not print. Other users can print FRx reports just fine, but for you, it happens on all reports. This error appears if you print to the … Read more
Multi Company Formatting Tips in Dynamics SL
Many of our customers have multiple companies in Dynamics SL. Some are in separate application databases, and some are all in one single database. Either way, below are some tips when managing multiple companies. Companies can be color-coded. This allows users to quickly see which company they are logged into for various SL screens: To … Read more
Keeping Windows 10 Workstation Drives Mapped
Windows 10 can be tricky when installing Dynamics on workstations. We have run into an annoying issue where the drive won’t stay mapped to a network. Whether you map the drive using the Net Use command or in File Explorer, as soon as you open File Explorer to verify, the drive is no longer showing … Read more