Excel data import and Reference ID


I’m using AX 2009. The issue is the following: I want to import new planned production orders from Excel to the ReqPO table but there is a field called “RefID” which is mandatory and is the identification code of the planned order.

I would want to know how I can import the orders without creating these codes by myself. If I left this field empty AX 2009 doesn’t allow me to import the data because it understands that empty fields are the same and therefore there is a problem with coherence.

Thank you all,


As I told you in your previous thread (and you marked my reply as the verified answer), I believe the easiest solution is writing your own code for importing the data and there you can write any other additional you like. The data import functionality isn’t intended for this purpose.