Removing Duplicates in Acumatica
Tiffany

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

Read More…

Month End for Acumatica
Tiffany

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

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…

ACH payment in acumatica
Tiffany

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

Read More…

Hand on mouse
Tiffany

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

Read More…

International Currency
Tiffany

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…

Tiffany

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

Read More…

Tiffany

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

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

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

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

Read More…