General Ledger in Acumatica
Tiffany Bennett

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

Read More…

Month End for Acumatica
Tiffany Bennett

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

Read More…

Cancel Drop Ship order in Acumatica
Tiffany Bennett

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

Read More…

Documents
Tiffany Bennett

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

Read More…

International Currency
Tiffany Bennett

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

Read More…

FYI Soft logo
Tiffany Bennett

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

Read More…

Tiffany Bennett

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

Read More…

Tiffany Bennett

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

Read More…

Tiffany Bennett

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

Read More…

Tiffany Bennett

How to Get a New Dynamics GP Budget ID to Show Up in Management Reporter MR

It’s very common for our customers to add new budgets to Microsoft Dynamics GP.  With the Legacy Provider in Management Reporter (MR), the new Budget ID would show in the Column Definition “Book Code/Attribute Category” field automatically.  With the MR Data Mart, there are a couple of steps below that need to be followed first. … Read more

Read More…