Dataport from few tables

grofsgrofs Member Posts: 53
Hy, I want make a dataport, what base on 2 table.
I have an Excel table with data
-customer name/no
-item no
-price
and I want it port to NAV.
customer no to Sales Header table
item no and price to Sales line
can I it do or not!?
:D

Comments

  • matttraxmatttrax Member Posts: 2,309
    You can, but not in an easy way.

    Use global variables to import your data into.
    You can use any table for your data item (I prefer Integer), and set AutoSave, AutoUpdate, and AutoInsert to No
    In OnAfterGetRecord use those global variables to populate records and insert them.

    Hope that makes sense.
Sign In or Register to comment.