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

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Everything Else
Import Scenario to ...
 
Notifications
Clear all

Questions Import Scenario to Add a New Line to existing Sales Order

 
Everything Else
Last Post by Kurt Keating 4 years ago
2 Posts
1 Users
2 Reactions
2,120 Views
RSS
Kurt Keating
Posts: 27
 Kurt Keating
Topic starter
July 12, 2022 4:44 pm
(@kkeating)
Trusted Member
Joined: 4 years ago

Hello,

We have a scenario where we want to automate adding a line to a Sales Order (basically to handle Colorado's new Retail Tax Delivery Fee).   I created a NON STOCK item that I want to insert on a new Line.  Non Stock Item - "COLOFEE"

I created an import scenario trying to do this, leveraging a Generic Inquiry which first isolates the Records. 

Generic Inquiry:

image

My provider uses the GI to formulate the basis of the Import scenario:

image
image

Import Scenario: 

image

I tried to use an existing SO Import scenario to figure out what was required, but it fails:

image

I know that import scenarios have some non-intuitive logic for the line order....any help is appreciated!

Cheers,

K2

 


1 Reply
Kurt Keating
Posts: 27
 Kurt Keating
Topic starter
July 12, 2022 5:07 pm
(@kkeating)
Trusted Member
Joined: 4 years ago

Scratch this...I didn't see that open status will not allow adding of a line.  adding logic to put on hold then release from hold worked!


Reply
Tim Rodman and Dianne A reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 63 Online
  • 2,439 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×