BTerrell Group Blog

Kevin Yu

Recent Posts

How to Activate "Inception To" Reports in Intacct

Posted by Kevin Yu on Mon, Mar 30, 2015

Here is a quick tip: Intacct provides two System Reporting Periods that are inactive by default, Inception to Current Month and Inception to Date. Activating these allows you to run reports spanning multiple years.

To locate these reporting periods:
1. Navigate to the “Company” module
2. Click on “System Reporting Periods”

3-30image1

3. Click on "Include Inactive"

3-30image2

4. Locate “Inception-to-Date” and/or “Inception-to-Current Month”
5. Click on "Activate" for the periods you would like active

3-30image3

6. Select “OK”

Now when you run a report, the “Inception” options appear as a reporting period to select.

Tags: Intacct, reporting

Troubleshooting Sage 300 ERP Payroll

Posted by Kevin Yu on Wed, Jan 14, 2015

I ran across an interesting issue I had not seen before when working with a customer’s Sage 300 ERP payroll last week. We found one pay period where employee “Bob” had a check amount of $1,500 that did not match their payroll register details. Bob’s payroll details usually included five earning details, one for each day of the week, as well as deductions and tax details. In this case, the report was only showing one earning detail for $400 and no deductions or taxes. It was clear that details were missing from this report.

The first thing I tried was running a data integrity check with the fix minor errors box checked. When that finished running, I checked the check amounts and payroll register details again, and the numbers now matched, but it actually changed the historical check amount to $400 to match the inaccurate payroll register report.

Next, I decided to dive into the database. Running a few SQL queries revealed something interesting. When my query filtered the results on the period end date (PEREND = 20140901), the result was one detail line for $400, matching what showed up in the payroll register report. However, when I changed my filters to include a range of dates instead, my query returned the full list of transaction details that totaled the $1,500 original check amount.

I tried updating the data in the PEREND column, but got an error message…

1-14image1

This led me to believe there to be an issue with the indexing in this table. I then ran this query to reindex the table…

1-14image2

After that, I ran a query using the period end date equals filter again and all the details matching the $1,500 total are returned. I ran the data integrity check with fix minor errors again, and now both the transaction history report and the check amount have a total of $1,500.

I thought this would be worthwhile to share because I had not seen this issue before. I hope this will help if you run into a similar issue. 

Tags: payroll

Working with Intacct Price Lists

Posted by Kevin Yu on Tue, Nov 11, 2014

I had a chance to work with price lists in Intacct for the first time a few weeks ago. Overall, setting up price lists for items is pretty simple, but here are a few things I learned that might help you when setting up your price lists.

  • When setting up transaction definitions, the Special Price List will override the Initial Price List. If you are doing a markup or discount, the base price needs to be in the Initial Price List and the markup or discount needs to go in the Special Price List.
11-11image1
  • An item can have different prices on different days by setting start and end dates in the price list entry. The transaction date will be used to determine the price to use.
  • If markups or discounts can be applied to the item, the Fixed selection should be “N”.
  • Minimum/Maximum Quantity fields should also be populated.
11-11image2

 

If you have any questions on setting up your price lists in Intacct, please let me know.

Tags: Intacct

Easily Set Up User Based Permissions in Intacct

Posted by Kevin Yu on Thu, Oct 09, 2014

Setting up user permissions for the first time can be very time consuming. There are so many different activities/lists and reports that can be assigned permissions.

On the permission assignment window, the header section has an area that allows you to assign None, Read Only, or All for all the permission options in that section. Read Only will check all the List and View options while None and All should be self-explanatory. Please note that there is a Reports section in the permission selection window for some modules.

 10 9image1 resized 600

Another way to expedite this process is by utilizing a permissions template. By choosing one of these templates, it automatically selects a corresponding set of user permissions for all the modules. This gives you a great starting point. Permissions can then be tweaked afterwards as needed.

10 9image2 resized 600

Tags: Intacct, Intacct setup, Intacct permissions

Resolving Windows Installer Coordinator on Terminal Server Issue

Posted by Kevin Yu on Thu, Sep 04, 2014

 

I installed Sage 300 ERP and Sage HRMS on a terminal server environment last week and was running into an issue with Windows Installer Coordinator. Often when I opened a UI, I would get a Windows Installer Coordinator popup that would run indefinitely. It actually prevented me from even running HRMS.

Windows installer coordinator

I found that there is a setting in Group Policy that disables Windows Installer Coordinator. I hope this helps if you run into this issue on a terminal server environment.

 

 

 

 

Windows Group lociy page

 

 

 

 

 

 

Windows Group Policy Editor

 

 

 

 



 

 

Edit compatiblity
Turn offWindows Installer

Tags: Sage 300 ERP, sage hrms, Windows