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 of Inventory...
 
Notifications
Clear all

Questions Import of Inventory Template Items

 
Everything Else
Last Post by Moroni.Pimenta 5 years ago
5 Posts
4 Users
1 Reactions
3,526 Views
RSS
Leanne Manley
Posts: 30
 Leanne Manley
Topic starter
August 19, 2020 1:59 am
(@myobadvanced)
Trusted Member
Joined: 6 years ago

Hi

Hoping someone can help with an import scenario that works with being able to select the "Create Matrix Items" tab, and then tick the appropriate attribute column for the matching row from Import data.  Managed to import the templates, but now need to do the Matrix selection area.

We have items that have a size and then colors for that size.  The row attribute is the size and the column is the color. 

Data for import has

ITEMCODE     Small    Black

ITEMCODE     Small    White

Now we wish to import this to save time as client is going to have 3000+ templates. 

And some items wont have the color in the size so we cannot just do all.

However not sure what to choose in the import scenario so hoping someone out there is kind enough to share one they have done that will be great.

 

Thanks in Advance


Topic Tags
Item Matrix
4 Replies
Royce Lithgo
Posts: 557
 Royce Lithgo
August 20, 2020 11:17 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

What are you trying to import? I am not familiar with the "Create Matrix Items" process.


Reply
Leanne Manley
Posts: 30
 Leanne Manley
Topic starter
August 21, 2020 1:27 am
(@myobadvanced)
Trusted Member
Joined: 6 years ago

Hi its this feature here:

About 6 mins into the video u will see the "Create Matrix Items" and this has a method of ticking what you want to make, and then you press the button to create the new stock items based on the template.  Those ticks are the issue.  I have tried on the template form, and also the form for Create Matrix Items, both import scenarios are failing to do what I need it to do, even though it seems to have the ability.


Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3204
September 30, 2020 4:53 pm
Reply toLeanne ManleyLeanne Manley

Hi @myobadvanced,

You might want to repost this Discussion Topic in the Import and Export Scenarios forum on the new official Acumatica Community website:
https://community.acumatica.com/import-and-export-scenarios-117

Here on AUGForums.com, most of the content will now focus on reporting, with the exception of general topics in the Everything Else (click here) forum and the AUGForums.com Real Talk Podcast (click here) where we'll continue to focus on real Acumatica customer stories (click here if you'd like to participate).

For more info about how AUGForums.com compares to the new official Acumatica Community, checkout this post:
https://www.augforums.com/augforums-com-vs-the-official-acumatica-community


Reply
Moroni.Pimenta
 Moroni.Pimenta
(@moroni-pimenta)
Joined: 5 years ago

New Member
Posts: 1
June 30, 2021 10:40 pm
Reply toLeanne ManleyLeanne Manley

Hey Leanne,

I have had the same issue and want to know if you have found out how to do this task.

if so can you share ?

 

 


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  Item Matrix (1) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 26 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
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

  • Johnny Tang
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.

‹›×

    ‹›×