Pro Forma Invoice GI - Activities tie in

  • 4 April 2022
  • 2 replies

Userlevel 4


I am creating GI for Pro Forma invoices, the main goal of the GI is to mass send out Pro Forma Invoices to customers. 

I am having trouble connecting the Activities information for the Pro Forma invoices (PM307000), see attached picture for reference.  I would like the GI’ to populate in a column if the Pro Forma has been emailed before or not. Below is a screenshot of the current results grid (last line): 


When I run the GI, I receive the below error:



any suggestions on how to resolve this error?


Thank you,



Best answer by hkabiri 4 April 2022, 16:57

View original

2 replies

Userlevel 6
Badge +5

@ketiller The problem is the formula you have for CRActivity.ClassID which is stored in Database with Integer values. what you need to do is find the actual class id for Activity Type Email and use it in your formula.

I would suggest create a GI, if you do not have access to DB, on EPActivityType Table and use formula as below screenshot which should give you the actual ClassID. In my case it was 4

And then replace into your formula for the GI .


Userlevel 4

@hkabiri Thank you for the quick response and detailed tutorial. The formula worked great with the integer.


Thank you,



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