web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to update Item Sal...
Microsoft Dynamics AX (Archived)

How to update Item Sale Tax Group for Released products.

(0) ShareShare
ReportReport
Posted on by faiz7049 2,430

Hi Experts,

I tried to update Item Sale Tax Group for Released products but I lost some data .

I have 5400 Items .First I used excel to update . I selected InventTableModule table (Field TaxItemGroupId).

After updated I found all items without data than I restored database.

Second try by Data Import/Export Framework . It updated all items according to source mapping.

Problem is each items have different dimension . It is very tough to retrieve dimension for each item than map to source mapping.

Does there is any way to do easily means just Item Id with 

InventTableModulePurch_TaxItemGroupId InventTableModuleSales_TaxItemGroupId

 

4087.Untitled.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at

    You should be able to use DIXF to update the item sales tax group, as long as you have item id, module type, item sales tax group in your source data.

  • faiz7049 Profile Picture
    faiz7049 2,430 on at

    Thanks,

    What I am missing in below code after executed nothing happened.

    static void Jobs10(Args _args)

    {

       InventTableModule     tm;

       ttsBegin;

       update_recordSet tm setting TaxItemGroupId = “VAT” where (tm.ModuleType == ModuleInventPurchSales::Purch && tm.ModuleType == ModuleInventPurchSales::Sales);

       ttsCommit;

       info(“Items Sales Tax goup have been updated”);

    }

  • Verified answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    Please update your code as shown below and it updates sales tax group on all the items to VAT where moduleType is Purchase order or sales order.

    static void Jobs10(Args _args)
{
   InventTableModule     tm;

   ttsBegin;
   update_recordSet tm setting TaxItemGroupId = “VAT” 
   where (tm.ModuleType == ModuleInventPurchSales::Purch || tm.ModuleType == ModuleInventPurchSales::Sales);
   ttsCommit;

   info("Items Sales Tax goup have been updated");
}


     

  • faiz7049 Profile Picture
    faiz7049 2,430 on at

    Thanks Golla,

    Now how to update only those items which have item group =102

  • Verified answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    Please use the following code to update for the items with itemgroupId as 102.

    static void Jobs10(Args _args)
{
    InventTableModule     tm;
    InventItemGroupItem itemGroupItem;
    InventTable         inventTable;
    
    ttsBegin;
    update_recordSet tm setting TaxItemGroupId = "VAT" 
    where (tm.ModuleType == ModuleInventPurchSales::Purch || tm.ModuleType == ModuleInventPurchSales::Sales)
    join inventTable
    where inventTable.ItemId == tm.ItemId
    join itemGroupItem
    where itemGroupItem.ItemDataAreaId == inventTable.dataAreaId
    && itemGroupItem.ItemId == inventTable.ItemId
    && itemGroupItem.ItemGroupId == "102";
    ttsCommit;

   info("Items Sales Tax goup have been updated");
}


  • Mohammad Hussain Profile Picture
    Mohammad Hussain 85 on at

    Thanks Golla.

    will you please upload the code to upgrade the Customer and vendor tax group.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans