'Due Date' required to post created P.Inv dataport

Vesna
Vesna Member Posts: 24
I created dataport to import Purchase invoices. Everything works fine.
Data are imported but when I want to post them the system ask for 'Due Date'.
I guess Due Date must be generated automatically grabing the data from Posting Date, but it does not happening.
Can anyone advise me what to do? #-o
I am browsing the forum for 2 hours and can not find an answer.
Thanks

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Sounds like another Dataport / Validate post.

    Like your last one
    http://www.mibuso.com/forum/viewtopic.php?t=23707

    Import the data into vaiables then assign & validate them in the same order as you would if you manually entered the info.
    Vesna wrote:
    I guess Due Date must be generated automatically grabing the data from Posting Date, but it does not happening.
    Don't forget to fill in the "Document Date" then the system will calculate the due date using the vendors terms.
  • Vesna
    Vesna Member Posts: 24
    Thank you Savatage,
    Actually with previous dataport due to lack of information I invented my own bicycle.
    I did it differently from your advice and most ones on the forum. [-( O:)

    Now I am not going to import Posting date. It would be given by the system but as I see Due Date depends of Document Date. Thus, it is not very clear for me what code I have to use here.
    Thank you for advice I will work in this direction
  • Vesna
    Vesna Member Posts: 24
    Solved.
    Now I understand why to discussion about it.
    Too simple. :lol:
  • Savatage
    Savatage Member Posts: 7,142
    you can do something like
    OnAfterImportRecord()
    "Document Date" := WORKDATE;

    if you don't mind it being the day you run it.

    Or use the textfile to import the date you want.