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.
Original Message:
Sent: 2/17/2023 12:52:00 PM
From: Richard Davis
Subject: AX 2012R2 exporting the External Item Description
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
------------------------------