D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  AX 2012R2 exporting the External Item Description

    Posted Feb 17, 2023 12:52 PM

    Hi all,

    We currently use AX 2012R2 and we would like to export all the External Item Descriptions of all Products we have in our environment. The External Item Description can be found when going to Released products > menu Purchase > External Item Description. When clicking on External Item Description, one or multiple records will be shown in the view presented on the screen showing the following columns with data:

    ·        ABC code.

    ·        Packaging.

    ·        Account code.

    ·        Vendor relation.

    ·        External item number.

    I checked the Data Import Export Framework in AX in the space Target Entities, but in the list of all extractable entities the External Item Description was not mentioned as an extractable entity. I also went to the space System Administration > Definition Group > created a new one > Select tables and I get a huge list of possible tables to export. I have no clue whether the table I want is also in this list and if it is possible to export it by using this method.

    Is there perhaps anyone who can share his experience/expertise about this and share with me a step by step guide how to get this information exported?

    Thanks,

    Richard



    ------------------------------
    Richard Davis
    Kay Industries
    ------------------------------


  • 2.  RE: AX 2012R2 exporting the External Item Description

    Posted Feb 20, 2023 01:12 AM

    When using DIXF, the Target entity is "DMFcustvendExternalItemTargetEntity" under the System Admin application module.

    The target actually holds both vendor and customer external item descriptions. You will need to use ModuleType (3=Vendor, 4=Customer) to make sure you are getting the correct time of reference.

     

    If you query from SQL instead of DIXF, you would use the CustVendExternalItem.

     

    Data Fields on the table:

    • ItemID
    • ModuleType
    • CustVendRelation – the account number (customer or vendor, depending on ModuleType)
    • ExternalItemTxt – optional
    • ExternalItemID
    • ABCCategory
    • Description

     

    There is no field for "Packaging" on that table.

     

    Dawna Cape | Sr Programmer Analyst

    Dexter (legacy Redneck) - Springfield, MO

    [email protected]

     

    2100 N West Bypass, Springfield, MO 65803, USA

    fax: 417-864-7764 | main tel: (417) 864-5210

    a DexKo Global Company  ■  Together is Better

    NOTICE: This e-mail message and any attachment(s) are being sent solely for use by the intended recipient(s) and may contain privileged or confidential information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by phone or reply by e-mail, immediately delete the original message and attachment(s) and destroy all copies of this message and attachment(s).  Thank you.

     


    NOTICE: This e-mail message and any attachment(s) are being sent solely for use by the intended recipient(s) and may contain privileged or confidential information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is prohibited and please immediately contact the sender by phone or reply by e-mail, delete the original message and attachment(s) and destroy all copies of this message and attachment(s). Thank you.






  • 3.  RE: AX 2012R2 exporting the External Item Description

    Posted Feb 21, 2023 01:50 AM

    Hi Dawna,

    Thanks a lot for your input. So according to your instruction I need to do the following:

    1. Go to the System Administration section.
    2. Click Definition groups.
    3. Click New and give the group a name.
    4. Click on Select tables.
    5. Search for the table CustVendExternnalItem and from this point onwards I don't know in detail which detailed steps to execute to add this entity/table to the newly created Definition group in order to use the button Export to to start the export. Are you perhaps able to help me out about the last few steps?


    ------------------------------
    Richard Davis
    Kay Industries
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role