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) / SalesCategory in not i...
Microsoft Dynamics AX (Archived)

SalesCategory in not importing with sales order lines DIXF?

(0) ShareShare
ReportReport
Posted on by Rana Anees 1,813

Hii, 

I am importing Sales order lines by using DIXF in AX 2012 R2.

1. All fields are coming except SalesCategory value. In CSV file I have provided SalesCategory name but not showing after the items are created?
2. I have to upload more than 200 sales orders. right now i am creating sales header manually. How I can upload Sales Header and Sales Lines all together in a single CSV or best practice? 

Thanks, 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rana Anees Profile Picture
    Rana Anees 1,813 on at

    I noticed that there is something wring with following method is not returning category RecId so I commented the line in following method..and now getting the SalesCategory name... 

    DMFSalesLineEntityClass -> GenerateSalesCategory 

    public container GenerateSalesCategory(boolean _stagingToTarget = true)
{
    container           res;
    EcoResCategory      ecoResCategory = null;

    if (_stagingToTarget)
    {
        if(entity.SalesCategory)
        {
            select firstOnly RecId from ecoResCategory
                where ecoResCategory.Name == entity.SalesCategory;

            res = [ecoResCategory.RecId];
        }
       // res = conNull();  ===> commented this line
    }
    else
    {
        res = [EcoResCategory::find(target.SalesCategory).Name];
    }
    return res;
}


  • Sangram Shinde Profile Picture
    Sangram Shinde 2,114 on at

    Hi Rana,

    You can use SO header data entity to upload header first and then can import lines against them using line entity.

    I don't think you can able to upload SO header and lines with single data entity with CSV, you have to use separate data entities.

    Thanks,

    Sangram

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    Hii Sangram,

    Yes I can create SO headers then I update SalesId in Sales order lines CSV file.

    If I have 200 sales orders I have to do it 200 times all this uploading process?

    Thanks,

  • Verified answer
    Sangram Shinde Profile Picture
    Sangram Shinde 2,114 on at

    In AX 2012 we have data entity with name 'Sales order header' to upload SO header data,

    in your source file you can put all these 200 records and upload them in single run.

    Now while uploading the Sales lines data you must have some legacy 'SalesId' provided with data, you need to replace that with the AX generated sales order Ids and import, so the lines will get imported against created sales order headers.

    Thanks,

    Sangram

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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