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
  • 54 views

Userlevel 3
Badge

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?

icon

Best answer by Andy Smith 14 April 2023, 17:18

View original

2 replies

Userlevel 3
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


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved