'Due Date' required to post created P.Inv dataport
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
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
0
Comments
-
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.
Don't forget to fill in the "Document Date" then the system will calculate the due date using the vendors terms.Vesna wrote:I guess Due Date must be generated automatically grabing the data from Posting Date, but it does not happening.0 -
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 direction0 -
Solved.
Now I understand why to discussion about it.
Too simple.
0 -
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.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 327 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions