How to create dataport that take value from another table

yugi200186
yugi200186 Member Posts: 20
edited 2012-10-22 in NAV/Navision Classic Client
Hello everyone, can you help me please.
I have navision 4.0 and want to create dataport with data table Sales Cr.Memo Line.
Since this table didn't have Posting Date field unlike Sales Cr.Memo Header table, i can't fill posting date in the field box while running this dataport.
Is there anyway to do so that i can filter the result by posting date field in credit memo header ?

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    I see 2 possibilities:

    1) create a flowfield "Posting Date" in the lines that point to the header. Easy to do, but it might give performance problems (quite unlikely but possible)
    This way you don't need to put code in your dataport

    2) the coding-way:
    On the request form, put a field for the posting date. But in doing this, you also need to create a textfield for the filename (give it ID=1 and the lookup works out-of-the-box).
    In the "OnBeforeExportRecord()"-trigger, you can get the header record and test the posting date. If it is not in the filter, you can skip current record.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories