Skip to main content
Solved

Can't use aggregated field from GI in Import Scenario 'Source Restrictions'

  • Jun 7, 2023 5:04 PM UTC
  • 5 replies
  • 161 views
  • Translate All

darylbowman
Captain II
Forum|alt.badge.img+17

I have an import scenario based on a GI. The GI is grouped by several key fields, and one of the resulting fields is called ‘State’, which is a count of the number of States that are represented in the data.

The GI returns the correct result:

 

But when I attempt to use the resulting value in the Import Scenario

the result is empty.

I’ve tried so many work-arounds, but nothing with aggregate fields seems to compute.

Is this a bug or a known limitation?

Best answer by darylbowman

If I'm thinking right, I wouldn't be able to use a value calculated in the import on the source restrictions tab.

I ended up building a processing screen instead.

View original

5 replies

  • Freshman I
  • Jun 27, 2023 12:45 AM UTC

Also having this issue. I have found that it won’t work if the import scenario is triggered by a business event, however if it uses a data provider and manually run the import scenario, it has no issues.

Translate

darylbowman
Captain II
Forum|alt.badge.img+17
  • Author
  • Jun 27, 2023 11:53 AM UTC

I was attempting to run it manually.

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Jul 10, 2023 9:50 PM UTC

Hi @darylbowman were you able to find a solution? Thank you!

Translate

WillieGrothman61
Jr Varsity III
Forum|alt.badge.img

Have you tried performing the calculation in the import scenario instead of the GI?

Translate

darylbowman
Captain II
Forum|alt.badge.img+17
  • Author
  • Answer
  • Sep 20, 2023 9:53 PM UTC

If I'm thinking right, I wouldn't be able to use a value calculated in the import on the source restrictions tab.

I ended up building a processing screen instead.

Translate