Skip to main content
Answer

Error with integration and import TICKS

  • August 5, 2022
  • 3 replies
  • 319 views
D
Freshman I

Hey Looking for any insight on this, I am currently trying to Prepare the Data for integration on the Import by Scenario screen of about 40,000 entries, but whenever I prepare the data before import I receive an error as it is processing. The Error is “Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks. Parameter name: ticks”

 

Thanks! 

Best answer by DConcannon

@dlhr3birth73 I’ve seen this error with date/time conversion. Are you preparing to load date/time fields? If so, check the data for bad format or empty.

E

3 replies

DConcannon
Varsity II
Forum|alt.badge.img+2
  • DConcannon
  • Varsity II
  • Answer
  • August 5, 2022

@dlhr3birth73 I’ve seen this error with date/time conversion. Are you preparing to load date/time fields? If so, check the data for bad format or empty.

Chris Hackett
E
E
Freshman II
  • emilythaw16
  • Freshman II
  • July 2, 2025

@dlhr3birth73I’ve seen this error with date/time conversion. Are you preparing to load date/time fields? If so, check the data for bad format or empty.

I’m facing the same issues. I’m trying to import over 1,000 entries for AP invoices. I’ve checked through all the date/time formats and they are all in appropriate formats without empty values. Is there any reason why this error message still showing? 

A
Jr Varsity II
Forum|alt.badge.img
  • apallawala21
  • Jr Varsity II
  • November 13, 2025

Hello!

I faced the same issue and identified the error comes as I have given a date format to an excel field which is actually a number field. So, I changed that field format back to number and it worked. 

Thank You

Chris Hackett
N
Terms & ConditionsCookie settingsAccessibility statement
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