Dataports - Importing customer table

viriatoviriato Member Posts: 105
I noticed that when importing data from the customer table there's many fields that are related tables that also might need to be populated, what would be the best recommended way to do this during the data import process using a data port.

Thanks in advance.

Comments

  • SavatageSavatage Member Posts: 7,142
    You need to validate the fields.

    Unless you're talking about populating the :
    salesperson\purchaser table using the salesperson code from the imported customer text file?
    and/or

    Payment terms
    Gen Bus Posting Group
    Customer Posting Group
    etc.

    What would you also like to populate.
    Note: I find it best to import all the data into Variables and map them back to the matching Nav fields in the orderyou want.
    example..
    Customer.VALIDATE("No.",vCustNo);
  • viriatoviriato Member Posts: 105
    Big Thanks for this Harry.
Sign In or Register to comment.