Skip to main content
Solved

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


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

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
Did this topic help you find an answer to your question?

5 replies

  • Freshman I
  • 1 reply
  • June 27, 2023

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.


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

I was attempting to run it manually.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2810 replies
  • July 10, 2023

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


WillieGrothman61
Jr Varsity III
Forum|alt.badge.img

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


darylbowman
Captain II
Forum|alt.badge.img+13
  • Author
  • 1749 replies
  • Answer
  • September 20, 2023

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings