AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Automatically chang...
 
Notifications
Clear all

Questions Automatically changing the status of a case

 
Everything Else
Last Post by Tim Rodman 7 years ago
4 Posts
2 Users
0 Reactions
2,182 Views
RSS
Posts: 6
 Mike Ott
Topic starter
September 17, 2018 11:33 am
(@mike-ott)
Member
Joined: 7 years ago

I look forward to R18 when I can get my hands on Business Events. Unfortunately, at the moment we are on R17.

Does anyone know how or even where I would start looking to be able to update case status when the following actions happen:
1) a case is assigned to a rep and the status changes from new to open
2) an email comes in for a closed case to reopen it.

hoping there is an answer aside from either a customization or business events. I agree business events would be best but as it is we had some struggles updating to R17 and likely aren't looking to do any more upgrades until at least next year, but I am looking for a solution I can implement now.

 

Thanks in advance!


3 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
September 24, 2018 8:02 am
(@timrodman)
Famed Member
Joined: 10 years ago

Unfortunately I think you would need a customization for #2.

Not completely sure though on #1. Sounds like you want to update the Status when the Status changes?


Reply
 Mike Ott
(@mike-ott)
Joined: 7 years ago

Member
Posts: 6
October 1, 2018 12:15 pm
Reply toTim RodmanTim Rodman

Sorry about that, for clarification on #1 we want to update the status when an rep accepts the case, so if the owner field changes and the status is new that the status would then change to open.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
October 8, 2018 12:29 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Ah, I see. The only way I can think of without doing a customization would be to use a technique that I learned recently.

Basically, setup an Import Scenario with a SQL View as the Data Provider. Then in the WHERE clause of the SQL View, put your logic so that it shows you all Cases with an Owner but that have a Status of New. Then setup the Import Scenario to change the Status to Open for everything returned by the SQL View.

The only downside is that it won't run instantaneously like Business Events. But you could run it on a schedule (daily, hourly, every 15 minutes, etc.).


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 8 Online
  • 2,405 Members
Our newest member: Brittany Bartman
Latest Post: Importing Acumatica User Roles / User Security Permissions from Excel
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×