Skip to main content
Solved

How are VARs who deploy the service module adding service history from the customer's previous software in Acumatica?

  • 14 April 2023
  • 2 replies
  • 60 views

We have a customer using the service package in Acumatica. They want to bring in service history to allow users to view what service has previously been performed for a customer or piece of equipment, even if the service happened prior to starting in Acumatica.

What process would you recommend to add the service history in Acumatica?

2 replies

Userlevel 4
Badge

We haven’t had this specific scenario yet, but generally when a customer wants to see history from a legacy system, we do one of these:

  1. Create custom Acumatica tables to hold the historical data, and link it as an inquiry on the customer screen.
  2. Export the history to a single file (Excel, PDF, etc) separated by customer and attach to the customer record.
  3. If the history is in a SQL database, load that into an Azure instance and build PowerBI views to it.

Each has its pros and cons.  Interested to hear other solutions for this.

Userlevel 3
Badge +1

We had a client provide us very good historical data and we created a ‘Historical’ Service Order type with ‘Quote’ behavior (can’t be billed) and imported into service with non-stock and service items detail. The client was super-creative and came up with a required attribute that users don’t have access to via security - to prevent anyone from canceling (reverts values to zero) or converting these ‘quotes’ to active orders.
 

Reply