Skip to main content
Solved

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


meagan59
Varsity I
Forum|alt.badge.img

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?

Best answer by Andy Smith

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.

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Varsity I
  • 39 replies
  • Answer
  • April 14, 2023

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.


sroberts29
Freshman II
Forum|alt.badge.img+1
  • Freshman II
  • 71 replies
  • May 24, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings