[22R2]-Import Matrix Items, Template Items using Import Scenario, Convert Stock/Non-Stock item to Matrix Item and vice versa..

Thank you for this @KarthikGajendran, these are super helpful features!

Thank so much, @KarthikGajendran!

This import scenario is helpful if you haven’t already defined the template items in the system.  In our case we have all the template items defined and each matrix item will include all options of the template item.  We have about 250 template items with three variants.  To create one matrix item I have to populate 56 lines of the excel sheet.  When I look at the create matrix item screen it appears that the screen needs three pieces of information, the column attribute, the row attribute and the additional attribute.  In my case we have one.  

I was opening that we could setup an import to pass this limited information and have the screen generate all the combinations.  

The import does not appear to support passing that type of information.  I don’t see a select all column option and I can’t define the additional attribute.

Is this possible?

@GJensen From 21R2, you are not required to have both Column and Row Attribute. You can create with just a single attribute. Example: If you have a Tshirt that you sell with just Size then in the Configuration tab make sure you select just one Attribute. Please see below screenshots. You have to have just that one attribute in Item Class otherwise the system will ask you to select all the Attribute in Template Item prior to 23R1. 

From 23R1, you can make Attributes inactive in Template Item that you dont wanna use. 

Thanks for that input and this is useful feature.  What I am trying to accomplish is to have an import scenario automatically trigger the “Create Matrix Item” action without having to pass all the combinations of child items.   When you launch the screen IN203500 manually you pass in two values the Template ID, and the “AdditionalAttibute” if required. You also need an action to flag all options.  

  The import should pass values for three fields

Based on the examples I have seen, it is not possible to pass this required data. So we have to build out large excel sheets to meet this need.  This introduces the chance of many errors. Am I missing something?

Thanks

Gary

@GJensen  Could you please check this article and let us know if it helps you.  

We recently upgraded from 2021 R1 to 2022 R1 and had to unpublish a previous version of this customization.  Is there a version of the customization available for 2022 R1?

Thanks,

John

@KarthikGajendran thanks! this is very helpful!

@KarthikGajendran I have published the customisation but the Template ID field on Stock Item screen is not editable. I have selected various Item Classes but the field remains greyed out. We are using MYOB Advanced 2022.205, which is the equivalent of Acumatica 22R2 Build 5. Any ideas please?

Greetings,

Does this customization exist for  23.106.0050?

@kkomlodi82 Please check the below article

• [23R1]-Import Matrix Items, Template Items using Import Scenario, Convert Stock/Non-Stock item to Matrix Item and vice versa and making the Matrix Item as Kit

schalksw wrote:

@KarthikGajendranI have published the customisation but the Template ID field on Stock Item screen is not editable. I have selected various Item Classes but the field remains greyed out. We are using MYOB Advanced 2022.205, which is the equivalent of Acumatica 22R2 Build 5. Any ideas please?

 

The same happens here. We have another custo on the same screen. We didn’t manage to get this working. It was working when it was the only custo on the tenant. Even with removing all other custos it is not going back in to operational state.

Just fixed it myself. The clue was to enable the field in RowSelected.

Sorry, i now realised that the activity of this custo was bound to feature “Commerce”. I changed it to feature “MatrixItem” now.