[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

  • 19 April 2023
  • 21 replies
  • 1176 views

Userlevel 7
Badge +2

In continuation with the below article, the current article explains how the same can be done in 23R1 and the difference between 22R2 and 23R1.

 

  • Like in 22R2, in 23R1 there are out of box import scenarios for Template Item(Import Template Items), Matrix Item (Import Matrix Items).
  • The Edit Template ID checkbox in the Item Class form which enabled the Template Item ID field in the Stock/Non-stock form is removed. 
  • The Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check 

     

All the above is done out of the box. 

  • Now to make the Template ID field editable in the Matrix item screen, the user has to publish the attached customization(“ImportMatrixItems2023R100.zip”) to this article. This customization package must be used only with 2023R1 and above. 
  • There is a customization package for users who do not have commerce module as well. Check the attachment: “ERPImportMatrixItems2023R1002.zip”
  • For 22R2, check 

     

  • If the selected Template ID in the Matrix Item does not match with default fields with each other, then a popup warning is provided to the user.  The fields that are checked are matching are the below. 
  • Type
    Valuation Method
    Tax Category
    Base Unit
    Sales Unit
    Purchase Unit
Popup warning when default fields does not match

Customization for 2023R1 with Commerce Module: “ImportMatrixItems2023R100.zip”

Customization for 2023R1 without Commerce Module: “ERPImportMatrixItems2023R1002.zip”

 


21 replies

Userlevel 7
Badge +6

@KarthikGajendran , thanks for sharing!

Userlevel 1

@KarthikGajendran, really appreciate you putting this together.

Userlevel 7
Badge +2

Update: If you do not have the Commerce Retail Edition enabled, then you can use the attached customization (ERPImportMatrixItems2023R1002.zip) package to enable the Template Item ID field for 23R1. 

 

Userlevel 3
Badge +1

HI, would this be required to import into the Sales Order Lines as well?  No ecommerce

are API imports available?

Userlevel 4
Badge +1

@KarthikGajendran  could you please update the links to the packages? All the links seem to be broken.

Userlevel 7
Badge

Hi @Samvel Petrosov the file links above and file downloads seem to work for me…

 

Userlevel 3
Badge +1

HI, the links are not working.  If you save link as,  it puts it as a XML.  Customization packages need to be zip.  Please update

 

Userlevel 3
Badge +1

working now, thank you.

 

Userlevel 3
Badge

@KarthikGajendran  or anyone - have you had experience with making these Template/Matrix changes when working with a Shopify Integration? How does that update the product in Shopify? Does it cause errors or duplicates?

Userlevel 3
Badge

Hello @KarthikGajendran 

Is the customization compatible with 23R2 Commerce Edition?  If not, is there an ETA for this to be updated?

Thank you

Nathan

Userlevel 7
Badge +2

@nathankeating  The customization is compatible for 23R2 as well. You can try it and if you encounter any issues please let us know we can fix it. 

Userlevel 1
Badge

@KarthikGajendran we encountered an error when attempting to publish the customization package for 23R2 - however, there appears to be a standard import scenario that works without the package. 

It appears that we can no longer manually link a stock item to a template - it must be done using an import scenario. Can you confirm that this is intended functionality? 

Userlevel 5
Badge +1

@KarthikGajendran 

Above there was conflicting information on which zip package to use with Commerce Edition.

Customization for 2023R1 with Commerce Module: “ImportMatrixItems2023R100.zip”

Customization for 2023R1 without Commerce Module: “ERPImportMatrixItems2023R1002.zip”

Update: If you do not have the Commerce Retail Edition enabled, then you can use the attached customization (ImportMatrixItems2023r1002.zip) package to enable the Template Item ID field for 23R1. 

 

So - do we use “ImportMatrixItems2023R100.zip” or “ERPImportMatrixItems2023R1002.zip” for Commerce edition? We are using the Shopify B2B connector.

 

Userlevel 7
Badge +2

@nathantrauscht  Sorry, yes it is a typo. Since you have commerce module enabled please use ImportMatrixItems2023R100.zip. 

Userlevel 5
Badge +1

@KarthikGajendran we will give it a try on 23R2, thank you!

Userlevel 1

Super rad thanks for helping to put this together. Where do I go to install this zip? I’ve got a snapshot already of the sandbox site I want to test this on.

Is there any documentation for how specific field data is handled in the Commerce version? We’re needing to clean up InventoryItem table a bit before exporting data to Shopify.

My hope is this tool supports grouping items that share the same product description and photo and are sourced from different vendors. 

 

Userlevel 1

Following up on my question above.
These modifications are installed as Customization Projects.
 

Userlevel 5
Badge +1

@KarthikGajendran 

 

Customization for 2023R1 with Commerce Module: “ImportMatrixItems2023R100.zip”

 

Tested 23R2 and is working flawlessly. This has solved a huge issue post migration and preparing for integration with Shopify Plus, thank you!

Userlevel 4
Badge

@KarthikGajendran - Is this feature now part of 2023 R2? Do we still need to enable the template Id checkbox in item class? If its not needed then when does the template ID gets enabled in Stock item screen? Could you please share the link to that article or documentation that wld help us to test 23R2 and ecommerce with apparel type of products. 

Userlevel 7
Badge +2

@hsarjapur The checkbox in the Item Class has been removed. To enable the Template ID you have to use the attached customization (ImportMatrixItems2023R100.zip) in this article description. Though this article is for 23R1, the same customization can be used for 23R2 as well. It is tested by various customers already. 

Userlevel 4
Badge

@hsarjapur The checkbox in the Item Class has been removed. To enable the Template ID you have to use the attached customization (ImportMatrixItems2023R100.zip) in this article description. Though this article is for 23R1, the same customization can be used for 23R2 as well. It is tested by various customers already. 

Ok, so we still using the same package to import the matrix items via scenario, gotcha. 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved