Skip to main content
Solved

Update all records using import scenario


Forum|alt.badge.img

Hi

My customer has many cash accounts (50+), when they add an new Entry Type I would like a business event to run an import scenario that will link the cash accounts to the new entry type. 

I have the business event triggered that when a new entry type is created it populates a generic inquiry and triggers the business event. The generic inquiry results are the Entry Type ID and Description.  That is working, the business event runs, and if I hard code a cash account ID in the import scenario the import updates that cash account.

Where I am stuck is how do I update all the cash accounts with the new entry type?  I tried =Every in the source field (that works with export scenarios) but no luck.

Thanks,

 

 

Best answer by lauraj46

Hi @coleenmcnally22 ,

In your Generic Inquiry you should be able to do a Cross join with the CashAccount table to return a row for each cash account.

Hope this helps!

Laura

View original
Did this topic help you find an answer to your question?

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 591 replies
  • Answer
  • March 27, 2024

Hi @coleenmcnally22 ,

In your Generic Inquiry you should be able to do a Cross join with the CashAccount table to return a row for each cash account.

Hope this helps!

Laura


Forum|alt.badge.img

@lauraj46  -  thanks that worked!


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