Archives

4 Easy Steps to Speed Up Epicor 10

September 15, 2015 2:11 pm | Published by | Leave your thoughts

Do you have Epicor 10 installed and configured, but are experiencing slow speeds? Follow these four easy steps to help Epicor 10 run faster in any environment. 1. Optimize for Ad Hoc Workloads – This option is used to improve the efficiency of the plan cache for workloads that contain many single use ad hoc batches. Setting this to 1 will improve performance. To set these in SQL, follow these steps: Launch SQL Management Studio Right click on the DB you want to optimize and select ‘New Query’ Type the following and execute:   2. Parameterization Forced – Setting this... View Article

Comprehensive Buying Report

September 12, 2015 7:53 pm | Published by | Leave your thoughts

Bird Rock Solutions has developed a Buying Report that can help your purchasing department tremendously. This powerful report will allow you to type in a manufactured part number(s) and the output will display the raw material for that part. The information that displays along with the raw material is as follows: Part, Description, On Hand Qty, Demand Qty, Qty Available, Open PO’s, Minimum Order Qty, Lead Time, Minimum On Hand Qty, Last Cost, Average Month Usage, Peak Usage Qty, and Inventory Turns. This is not information that is easily pulled from Epicor, but we have developed calculations and SQL views that... View Article