Skip to main content
Answer

Update all records using import scenario

  • March 22, 2024
  • 2 replies
  • 227 views

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

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 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!