Microsoft Dynamics AX (Archived)

Min/Max Import through DMF

(0) Share

Report

Posted on by AX 2012 r3

2,426

Good Morning,

There are like 500 items.and want to provide Min/Max Quantity for every item in item coverage group.

So,it will take a lot of time to enter manually.

I am completely new to Import/Export.

i have seen basic.

Please tell me how can i import Min/Max for items.

Is there any default entity or should i create new

if new please tell me some steps .

Please help me.

Any help would be greatly Appreciated.

Regards.

Have a great day.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (0)

Report

Hi AX2012r3,

There is a standard entity in Dynamics AX 2012 R3 for the Item coverage support.

For help on use the import features, you can have a look at the documentation: ax.help.dynamics.com/.../data-importexport-framework-user-guide-dixf-dmf

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Good Morning Andre,

First of all thanks for your reply.

Can you please name the entity for item coverage.

Regards.

Have a great day.

Was this reply helpful? Yes No
Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

Hi,

in response to your personal message in inbox, I am going to paste following screenshot for you. Hopefully this may help you to get on and explore this.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Good Morning Sohaib,

Thanks for your reply.

Yes i have created same way.

But it is already saying record is inserted.

but when i go to that form

the quantity like max and min are not correct.

but in table they are correct.

can you please tell me why it is like that.

Regards.

Was this reply helpful? Yes No
Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

I just tried it, now on my demo system and it worked straight away. no issues at all. would you like to delete and rebuild your entity in list of entities? it may not ab an issue with your mapping. also what version of ax you are using?

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi sohaib,

I have checked in table just now.it is showing same.

Please find the below screenshots

Regards.

Will try another time.

Thank you

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi sohaib,

I am using ax2012 r3.

I will try the other time.

if it works. fine

i will provide the answer with screen shots.

Regards.

Was this reply helpful? Yes No
Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

screenshot shows your objects in USR layer which means it is customized entity as per your environment and it is very much possible you are missing the code in entity class or you might have forget to add field under DMF field group of table. you can take working entity of SYS layer from any 2012R3CU9 or higher version of ax and that should be working perfectly.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi sohaib,

Please find the below screenshots

but in form

Class is

I did not modify any method in this class.

What should i modify.

Please correct me.

Regards.

Have a great day Sohaib.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report
your class is missing code to generate inventdim.

this mean when records go into your destination table, they don't have a corresponding record of inventdim and inner join fails to return record. Thus you don't see anything on form.

replace above code of getReturnFields with following code

public static container getReturnFields(Name _entity, MethodName _name) { DataSourceName dataSourceName = queryDataSourceStr(DMFReqItemTableTargetEntity, ReqItemTable); Container con = [dataSourceName]; Name fieldstrToTargetXML(FieldName _fieldName) { return DMFTargetXML::findEntityTargetField(_entity ,dataSourceName, _fieldName).XMLField; } switch (_name) { case methodStr(DMFReqItemTableEntityClass, GenerateInventDim) : con += [fieldstrToTargetXML(fieldStr(ReqItemTable, CovInventDimId))]; break; default : con = conNull(); } return con; }

and then add a new method in your class as following

[DMFTargetTransformationAttribute(true),DMFTargetTransformationDescAttribute("@DMF349"), DMFTargetTransformationSequenceAttribute(5) ,DMFTargetTransFieldListAttribute([fieldStr(DMFReqItemTableEntity,configId),fieldStr(DMFReqItemTableEntity,InventSizeId),fieldStr(DMFReqItemTableEntity,InventSiteId),fieldStr(DMFReqItemTableEntity,inventSerialId),fieldStr(DMFReqItemTableEntity,InventLocationId),fieldStr(DMFReqItemTableEntity,InventColorId),fieldStr(DMFReqItemTableEntity,inventBatchId),fieldStr(DMFReqItemTableEntity,InventStyleId),fieldStr(DMFReqItemTableEntity,wMSLocationId),fieldStr(DMFReqItemTableEntity,wMSPalletId)]) ] public Container GenerateInventDim(boolean _stagingToTarget = true) { container res; if (_stagingToTarget) { inventDim = DMFDimensionHelper::generateInventDimID(entity); res = [inventDim.inventDimId]; } else { inventDim = inventDim::find(target.CovInventDimId); res = [ inventDim.configId, inventDim.InventSizeId, inventDim.InventSiteId, inventDim.inventSerialId, inventDim.InventLocationId, inventDim.InventColorId, inventDim.inventBatchId, inventDim.InventStyleId, inventDim.wMSLocationId, inventDim.wMSPalletId]; } return res; }

Finally rebuild your entity and regenerate mapping

Was this reply helpful? Yes No