Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Inventtramsferline table and hsncodetable_in

Posted on by 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 

  • PrachiGupta97 Profile Picture
    PrachiGupta97 150 on at
    RE: Inventtramsferline table and hsncodetable_in

    Thank you

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    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 Profile Picture
    Gunjan Bhattachayya 35,421 on at
    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 Profile Picture
    Sergei Minozhenko 23,089 on at
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans