Inventtramsferline table and hsncodetable_in

(0) Share

Report

Posted on by PrachiGupta97

150

Hi,

I want to find the hsn code for line record for a transfer order.

I can't find any relation between the tables inventtransferline and hsncodetable_in. I even tried searching for inventjournalline and didn't find any.

I tried the code

Hsncodetable = hsncodetable_in::find(inventtransferline.HSNCodeTable_In)

But it is not getting hit and in SQL inventtransferline.HSNCodeTable_In does not exist

All responses (4)

Answers (1)

PrachiGupta97 150 on at

Like (0)

Report

RE: Inventtramsferline table and hsncodetable_in

Thank you
André Arnaud de Cal... 294,208 Super User 2025 Season 1 on at

Like (0)

Report

RE: Inventtramsferline table and hsncodetable_in

Hi PrachiGupta97,

The table is related to the Indian tax localization. However, I don't have experience with it and don't know about the purpose or where it should be used or linked.
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Inventtramsferline table and hsncodetable_in

Hi Prachi,

There is a field for HSN codes on the transfer order lines but it doesn't look like it is being used on any form.

What is your exact requirement here? In case you need to show the HSN code on a report, have you tried to use the HSN code set for the item? You could also create an extension of the transfer orders form and make this field available for the user to fill it in.
Suggested answer

Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: Inventtramsferline table and hsncodetable_in

Hi PrachiGupta97,

Do you see HSNCodeTable_In field in transfer order form? If yes, you check in the personalization source for that field.

For me, it looks like customization, so it's hard to say where this field is located, maybe it's in InventTransferLine_in table?