Solved

Validation of Import of Customer Data in Import Scenario

  • 8 February 2022
  • 3 replies
  • 119 views

Userlevel 3
Badge +1

We have a requirement where customer data from a third party is sent over to Acumatica by dropping an encrypted zipped file containing the excel or CSV file of the customer data to a FTP server. We are planning to configure file synchronization to get this file to Acumatica and mapping the import scenario and then using the process import scenario screen to automate import of these records to the customer screen. How can we validate these import of records or get better error feedback?

icon

Best answer by Yuri Karpenko 8 February 2022, 18:19

View original

3 replies

Userlevel 7
Badge +6

@TharidhiP , this is a very very good question! I would suggest to build a generic inquiry on the SYData and SYMapping tables, that would show errors in the specific import scenario. Then, you can either set up a Business Event to notify somebody to take care of the errors. Let me know if you would like more details around the GI. Thanks!

Userlevel 3
Badge +1

@yurik05 Thank you for the suggestion! It would be great if you could elaborate on the GI creation.

Userlevel 7
Badge +6

@TharidhiP , something as simple as the attached XML will do a trick for you. Just don’t forget to change the name of the import scenario to your scenario’s value:

 

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