Skip to main content
Answer

Using a GI as a Data Source, that is essentially a duplicate GI

  • May 13, 2025
  • 2 replies
  • 104 views
B
Semi-Pro II
Forum|alt.badge.img+1

I am having a tough time relating my GI that I am using another GI as a data source.

 

I have a GI that is pulling All Move Transactions, I also have formulas that tell me if the transaction occurred on Day or Night shift, and if it was on Overtime or not.

 

I wanted to duplicate this GI and then pull the duplicate in as a data source, to minimize the amount of formula I need to use. Because instead of writing the formula again, I can pick [overtime] from the data source and continue with the rest of my expression.

 

It should be simple to relate, because it is literally the exact same information. I figured it should be related by batch number and maybe doc type, but no matter how I relate it, I get “cannot be bound”

 

Can anyone help me relate these tables.

 

 

Another thought I had, my main GI has a bunch of conditions to limit which transactions to pull into it. But the data source GI, I removed the conditions so that I could hopefully use it for other screens as well. Could this be an issue?

 

I have attached my GI, and would love any help on this.

Best answer by bodiec

Hey, ​@Tony Lanzer  Thank you so much for replying to this, 

I actually haven’t looked back at this custom screen since I posted, and now after your reply, you mentioned the errors are for custom fields in the results grid.

 

Which when I looked at the full error message, none of those fields were actual fields in my results grid, all of those were fake fields that seemed to have the system confused because I pulled some data Sources in just to steal the formatting from them.  

 

I deleted those data sources from the secondary GI and that seemed to do the trick! 

 

I guess I just needed my data source GI to have normal formatting in order for this to work.

 

Thanks so much!

1 Attachments

2 replies

Tony Lanzer
Pro III
Forum|alt.badge.img+2
  • Tony Lanzer
  • Pro III
  • May 20, 2025

​@bodiec, I took a quick look, and see the “cannot be bound” errors on custom fields in the results grid. Are these the errors that you’re referring to?  Do you have DAC extensions for these custom fields?

Chris Hackett
B
Semi-Pro II
Forum|alt.badge.img+1
  • bodiec
  • Author
  • Semi-Pro II
  • Answer
  • May 20, 2025

Hey, ​@Tony Lanzer  Thank you so much for replying to this, 

I actually haven’t looked back at this custom screen since I posted, and now after your reply, you mentioned the errors are for custom fields in the results grid.

 

Which when I looked at the full error message, none of those fields were actual fields in my results grid, all of those were fake fields that seemed to have the system confused because I pulled some data Sources in just to steal the formatting from them.  

 

I deleted those data sources from the secondary GI and that seemed to do the trick! 

 

I guess I just needed my data source GI to have normal formatting in order for this to work.

 

Thanks so much!

Chris Hackett
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