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
Mass change for Inv...
 
Notifications
Clear all

Questions Mass change for Invoice Template

 
Everything Else
Last Post by Tim Rodman 5 years ago
5 Posts
3 Users
0 Reactions
2,905 Views
RSS
Tami
Posts: 39
 Tami
Topic starter
August 27, 2019 11:04 am
(@tlynn)
Trusted Member
Joined: 6 years ago

I would like to do a mass change for a selection (about 900) customers to change the invoice template. See screen shot.

Any advice?


4 Replies
Royce Lithgo
Posts: 557
 Royce Lithgo
August 27, 2019 3:40 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

Build a GI to get the Customer IDs you want to change to a spreadsheet.

Build an Import Scenario to apply whatever changes you need (not quite sure what that is from your screenshot).


Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
September 28, 2019 2:35 pm
(@timrodman)
Famed Member
Joined: 11 years ago

Try doing this on the Import Scenarios (SM206025) screen:

My Excel file looks like this:

This is what the record looks like before running the Import Scenario:

This is what the record looks like after running the Import Scenario:


Reply
Tami
Posts: 39
 Tami
Topic starter
October 30, 2020 9:14 am
(@tlynn)
Trusted Member
Joined: 6 years ago

Hello Tim,

Circling back to this, I am getting the below error when I try to import by scenario. I copied everything exactly like you had it.

I've attached all the necessary screenshots. One thought, when I change it manually in the customer record, the button showing "OVERRIDDEN" gets checked. Do I need to address this in the import scenario?

Screen Shots Import Scenario.docx

 Thank you for your help.

 

image

Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
January 24, 2021 3:13 am
(@timrodman)
Famed Member
Joined: 11 years ago

This looks slightly different than my screenshot:

image

 

I also noticed that you're getting a warning on the Customer ID field:

image

 

If you hover over the warning, what does it say?


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 114 Online
  • 2,437 Members
Our newest member: Matt Butler
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.

‹›×

    ‹›×