Mass Data Upload HSN Code on Material Master

[sathyanarayanan_s]

Hello Experts,

i am trying to upload HSN codes on may of material via Mass Data Maintenance import function.

system shows my import was valid & successfull but materil now showing HSN code when checked manually.

showing import template & success log for your check.

I hope product "Mass Data Maintenance" product manager in this issue

someone please pin this to @michael roth

Regards

Vishal Kambare

[sathyanarayanan_s]

Dear Vishal,

Can you let us know which exact field of Material Master did you use to maintain the HSN code?

Thanks.

[Former Member]

HSN Code for India

[manasa_a · Accepted solution]

Dear Vishal,

There is no mass upload functionality related to HSN codes as of now in Business by Design.

You have to manually maintain it in Business Configuration activity "

HSN/Service Tax Accounting Codes"

[Former Member · Accepted solution]

My query was to upload HSN codes on Materials (not to HSN/Service Tax .....)

anyways, my query is resolved.

We can do it through Material Migration Utility.

Thanks.

[former_member134754]

Hi Bro,

We have options for HSN code mass upload options.

we have tried few years before.

HSN/SAC Code Template

Download the template for HSN/SAC code mass upload. Fill in the data in the template and save the Microsoft Excel file as a CSV file.

Once you update the fields then go to

Step 1: Go to “Application and User management” select “File Input”.

Step 2: Select “Unprocessed Files” from the show list. Click on “Add”.

Step 3: A new popup screen will opens. Select “HSN SAC File upload – Simulate” as service interface. Then browse the template from your desktop. Click “Ok”.

Step 4: Again Click on “Add” and select “HSN SAC File Upload – Save” as service interface and browse the file. Click “Ok”.

Step 5: Now the file that has been uploaded will be listed.

II process:

Step 1: Select “Active Runs” from the show list and Click “New”.

Step 2: Create file Input run for “HSN SAC File upload – Simulate”. Enter the run ID and description.

Step 3: Click on “Active” and select “Set to Active”.

Step 4: Click “Save and close”.

Step 5: The created run will be listed. Select the line item and Click “Schedule”.

Step 6: Select “Start Immediately” and “Save and Close”.

Step 7: The run has been executed and click on the application log Id to view the details.

Note: The HSN SAC File Upload – Simulate run has to be successful before HSN SAC File Upload - Save run is executed.

Step 8: Click on “New” to create file Input run for “HSN SAC File upload – Save”. Enter the run ID and description.

Step 9: Click on “Action” and select “Set to Active”.

Step 10: Click “Save and Close”.

Step 11: The newly created file will be displayed. Select the line item and click on “Schedule”.

Step 12: Select “Start Immediately” and “Save and Close”.

Step 13: The run has been executed and click on the application log Id to view the details.

You can verify the HSN code that has been uploaded. Business configuration > Implementation projects > HSN/Service Tax Accounting Codes – India > Product Tax Standard Classification Code India SERV.

Thanks & Regards

M.Kannan

[namratasingh]

Hello m_kannan46

Where can we get Application and User management option. Could you provide us the path.

[wanpen_anuthat]

Hello M.Kannan

Would you mind providing further guidance on the Material/Service Name? I currently have only the Material ID and Material Description available in the system. I’ve tried both, but neither worked. Your advice would be much appreciated.

Thank you.

Pui

[guptraj]

Hello,

Can anyone guide me to upload the HSN codes for material in mass?

Thanks

Rajeev

[former_member134754]

Hi Bro,

Material migration template once done. We can't have any options for mass upload HSN code against material.

Note:

Leave the General sheet empty, except for the exceptions described above.

Enhancement of the Detailed Descriptions sheet and Attachments sheet is not supported.

Materials — Enhance Records in a Change Project

In a change project, you can enhance material master data using the following sheets of the migration template:

• Other Languages

  Use this sheet only to insert a new, language-dependent description.

• Quantity Conversions

• UoM Characteristics

• GTIN

  Use this sheet only in combination with the UoM Characteristics sheet.

  You must specify at least one entry, for example, gross weight and unit.

• Financial Organizations

• Taxes

• Withholding Tax

• Purchasing

  If the Purchasing UoM of the new records differs from the Base UoM, make sure that a quantity conversion is available.

  To execute logistic processes, enter the Material ID and Inventory Valuation UoM on the General sheet.

  Internal comments can only be migrated for new records and not for existing records.

• Purchasing Notes

  Purchasing notes can only be migrated if the Purchasing sheet is filled.

• Supplier Part Numbers

• Logistics

  To execute logistic processes, enter the Material ID and Inventory Valuation UoM on the General sheet.

• Planning

  If Planning UoM and Base UoM are the same, you need to fill the Planning sheet only (without the General sheet).

  If the Planning UoM differs from the Base UoM, make sure that a quantity conversion is available. Also, you must enter the Material ID and the Base UoM in the General sheet, and if identified stock types are used, enter this type in the Identified Stock Type column.

  To execute logistic processes, enter the Material ID, the Inventory Valuation UoM on the General sheet.

• The Availability Confirmations sheet is only processed in combination with Planning sheet.

• Sales

  If the Sales UoM of the new records differs from the Base UoM, make sure that a quantity conversion is available.

  To execute logistic processes, enter the Material ID, the Inventory Valuation UoM on the General sheet.

  Internal comments can only be migrated for new records and not for existing records.

• Sales Notes

  Sales notes can only be migrated if the Sales sheet is filled.

• The Warranties sheet can only be processed in combination with the Sales sheet.

• Customer Part Numbers

Regards

M.Kannan