Solved

DateDiff Crashing Generic Inquiries

  • 29 January 2024
  • 4 replies
  • 48 views
A
Rank
Userlevel 3
Badge

Hello everybody,

Myself and a couple of colleagues have been facing an issue where the use of DateDiff in a GI causes the server to crash.

This occurs when attempting to save, the save just goes on and on and on.

 

Thanks,

 

Aleks

 

icon

Best answer by aiwan 29 January 2024, 13:07

View original

4 replies

dcomerford
Rank
Userlevel 7
Badge +12

Can you share the GI so we can look

Dermot Comerford
A
Rank
Userlevel 3
Badge

Hi @dcomerford,

XML attached below. The DateDiff is also missing the interval of days, because it keeps crashing when i attempt to save it. 

1 Attachment
A
Rank
Userlevel 3
Badge

I got it to work.

 

Seemingly, it was the fact that the two fields, [SOOrder.CreatedDateTime] & [SOInvoice.DocDate] also being in the results grid which made it crash.

Chris Hackett
Rank
Userlevel 7
Badge

Thank you for sharing your solution with the community @aiwan!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
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