AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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
Import Scenarios: "...
 
Notifications
Clear all

Questions Import Scenarios: "Update Else Create" function?

 
Everything Else
Last Post by Tim Rodman 3 years ago
2 Posts
2 Users
2 Reactions
1,595 Views
RSS
Nicholas Scyoc
Posts: 3
 Nicholas Scyoc
Topic starter
November 21, 2022 4:54 pm
(@nscyoc)
Active Member
Joined: 3 years ago

In attempt to create an import scenario to update pricing for items in our "Price List", I have encountered an issue that has stood in my way in more than a couple different situations. I wanted to see if anyone on AUG happens to know a way around this issue, since I have a solid example to provide on hand. I am aware that a source field value of =-1 on a <Line Number> action will create a new line, and I am also aware that unchecking the "active" box on this same type of line will cause the function to lookup/update. My question here is, is there a way to cause an import scenario to do both (an update else create) type of function within the same scenario?   

As it currently stands I have two import scenarios built; One for creating new sales price records and One for updating existing sales price records. While this gets the job done, it does cause for a bit of extra work that I would like to cut out of our current workflow. If I could combine the two of these scenarios into one performing both functions without errors through a single import, it would save us a lot of time in the long run. My attempts to combine these scenarios have resulted in a "duplicate price value" error every time, as acumatica doesn't seem to want to overwrite records without being specifically instructed to do so. Any and all feedback/guidance on this would be greatly appreciated.

 

Thank you,

9681c7c8d635f7e9bed174b52ff4c905
f60b587e9a7180a822ac17d54d25c145

 


Dianne A and Denny Wiggins reacted
1 Reply
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
August 9, 2023 4:31 am
(@timrodman)
Famed Member
Joined: 10 years ago

I'm not sure if that's possible, but that's definitely an interesting idea.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 17 Online
  • 2,414 Members
Our newest member: Megan Pawlowski
Latest Post: Credit Reference Report Needed
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 © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×