Question

Generic Inquiry - Can do the calculation?

  • 22 June 2021
  • 7 replies
  • 60 views

Userlevel 1
Badge
  • Jr Varsity II
  • 84 replies

Hi Everyone

Currently , we have create a generic inquiry to combine table invoice and memo  and table payment and check  in order to get the column for “ due date “ and “ payment date”  

 

If we would like to get system to calculate the day of over due , which mean “due date” minus “ payment date” in order to get the day of over due.  May i know how to do this in generic inquiry? 

 

Hope to hear from you soon.
 


7 replies

Userlevel 6
Badge +8

Hi @erin  You can use the DateDiff function to get the differences between the 2 dates. Please find the screenshots for references. (screenshots from other forum)

 

Hope this helps!!

 

 

 

Userlevel 1
Badge

Hi Naveen

Thank you very much!!!

By the way, not sure if we can copy the existing generic inquiry into another one and named in different title?

Userlevel 6
Badge +8

Yes… we can do copy and paste it with different title..

  • Copy the existing GI
  • Click on new GI (+) button
  • Provide new GI Title
  • Click on the Paste button

Userlevel 1
Badge

Hi @erin  You can use the DateDiff function to get the differences between the 2 dates. Please find the screenshots for references. (screenshots from other forum)

 

Hope this helps!!

 

 

 

Hi Naveen

If we want calculate the invoice due date and today date so that we know the day of over due, what is the formula that we need enter in generic inquiry-result grid? DateDiff(‘d”[?????],[????])

Userlevel 6
Badge +8

Hi @erin  Please try with the below formula.

=  DateDiff( 'd', [ARInvoice.DocDate], Today() )

 

 

Userlevel 1
Badge

HI Naveen

 

Got it ! thank you very much

Userlevel 6
Badge +8

@erin Glad to know that you can able to do the calculation in GI. :)

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 — 2020  Acumatica, Inc. All rights reserved