PracticalTek is a leading independent professional services provider of Epicor® support and consulting solutions.

CASE STUDY: Using Conversions To Calculate Indirect Activity

Using Conversions To Calculate Indirect Activity
Using Conversions To Calculate Indirect Activity
Multiplied by 60 to get hours because the time displays in minutes by default.
Using Conversions To Calculate Indirect Activity-2
This was used to fix the date calculation for when someone worked passed midnight. Originally Epicor® wouldn’t add a day to the ClockOutDate.

These next 2 fields are to make the option field that normally only shows the Date & Time, show just the Date instead. All that changes is the Data Type from (datetime) to date (compare to above screenshots) the “ClockInDate” & “ClockOutDate” will show the Date & Time.

Using Conversions To Calculate Indirect Activity-3
Using Conversions To Calculate Indirect Activity-4
Same calculations as before but different datatype
Using Conversions To Calculate Indirect Activity
Using Conversions To Calculate Indirect Activity
Using Conversions To Calculate Indirect Activity
I used this Expression for the SSRS report: Got the GrandTotal time to calculate and display properly. There are 3600 seconds in 1 hour. TotalTime added the “Grand Total” of Seconds together. Then the Grand Total expression took that number and divided by 3600 to get the number of hours to display.

Sage® X3 Benefits

Sage® X3 is Agile

Switch To Sage® X3

Get A Free Demo

Sage® X3 is Intuitive

Switch To Sage® X3

Get A Free Demo

Sage® X3 is Accessible

Switch To Sage® X3

Get A Free Demo

Sage® X3 offers the functionality and technology you need to achieve your goals:

  • Streamline Your Operations
  • Enhance Business Insights
  • Workflow
  • Enhanced Collaboration
  • Grow Your Business
  • Reduce Cost
  • Technology

PracticalTek Offers The Following Epicor® Services

PracticalTek (an Epicor® erp consulting independent professional services provider) provides innovative, award-winning business and information systems consulting solutions with a focus on Epicor®
When you need fast results from your Epicor® ERP system, there’s no better solution than an experienced Epicor® erp consultant. Working with a professional Epicor® application consulting firm, you can streamline your system to better suit your business with the help of a dedicated specialist.
At PracticalTek, we know how to make the Epicor® installation business transition seamless because we’ve helped so many people with it. We’ve learned some of the best practices of ERP implementation and want to help you succeed, too.
With years of experience, PracticalTek provides the best independent Epicor® upgrade consulting on the market. Our technicians come with years of training and the best certifications available, so we know what to do to make Epicor® work best for you and your business.

PracticalTek is an independent software services provider with a combined 400+ years of Epicor® implementation & training experience among our team members. Our knowledgeable staff offers novice to advanced level training on all Epicor® software training modules.

As an independent software services provider with a combined 400+ years of Epicor® customization consultant implementation experience among our team members, PracticalTek can accommodate all of your Epicor® programming support development needs.

Hover Over Any Of The Icons Above For More Information On Epicor® Services

Reasons To Switch To Sage® X3

Finances

Sage® X3 will help control your bottom line with the real-time visibility and accuracy you need.

Switch To Sage® X3

Get A Free Demo

Suppliers

Sage® X3 helps to ensure optimal efficiency through real-time inventory status monitoring.

Switch To Sage® X3

Get A Free Demo

Production

Sage® X3 will help you keep up with demand and efficiently manage your manufacturing process.

Switch To Sage® X3

Get A Free Demo

Clients

Sage® X3 will help you manage your clients and well managed clients are happy clients.

Switch To Sage® X3

Get A Free Demo
  • Functionality, Not Complexity
  • Integration, Not Interface
  • Scalability, Not Add-Ons
  • Browser Based, Not Web-Enabled
  • Multi-Country by Design
  • Low Cost of Ownership
  • Commitment to Success, Not Loyalty Programs

Changing to a new management system is an important decision. To make sure the new system will meet your expectations, you’ll need to go through a rigorous selection process and see what vendors can offer to best meet your requirements.


PracticalTek is an authorized Sage® X3 partner