Import/Export for opening new company

circlefaicirclefai Member Posts: 16
Is there anyway that NAV import data with only the neccessary fields and the
other fields can be auto-inserted as the same behaviour as user manual
input?

For example, when a user creates a sales header, first of all, s/he selects
a customer. When a "customer no." is selected, there are number of fields,
such as address, currency code, are auto-inserted by the system.
When s/he select an "item no" from the sales line, the description will be
auto-inserted. And once the quanity and Unit price are inserted, the line
amount will be auto-calculated.
So on and so forth...

When using data mirgration or dataport to import the data, NAV only directly
copy and paste the fields without any logic. And this would cause problem
for some fields. For example, Line amount should be the fields that is come
out from calculation. It is non-sense that I have to import/export this kind
of field.

So, is there anyway that I can import data as user input, So that I do not
have to import and export all the fields?

If no, is there a guide that user can follow so that s/he only import/export
the neccessary fields?

Comments

  • Mukesh_VermaMukesh_Verma Member Posts: 14
    Hi

    Create a dataport with the necessary fields only and in Dataport > Dataport Fields > Select the Field > Go to properties > Set the CallFieldValidate to Yes for the fields

    This will execute the code written in OnValidate trigger of these fields and will populate the other fields value.

    Regards,
    Mukesh
Sign In or Register to comment.