Purchase invoice

Vazid_490
Member Posts: 52
I am creating a text file with data like
"Invoice","1026","8625-W","Mani","Naaz","Vijaywada"
"Invoice","1028","10000","Item","1000","GREEN","FINISHED","laptop"
by using data port I can import the above text file.When I am running a purchase invoice I want to get one line in purchase header and next line in purchase line.how it will possible and how data items should be added in data port please tell me.
"Invoice","1026","8625-W","Mani","Naaz","Vijaywada"
"Invoice","1028","10000","Item","1000","GREEN","FINISHED","laptop"
by using data port I can import the above text file.When I am running a purchase invoice I want to get one line in purchase header and next line in purchase line.how it will possible and how data items should be added in data port please tell me.
0
Answers
-
You need to add an identifier on your text file as header or line.
While inserting you cannot directly import this file as you need to identify what type of line it is. So you need to code for it based on identifier call the insert of that particular table.
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page0 -
for creating dataports follow https://msdn.microsoft.com/en-us/library/dd339001.aspx
create 2 data items:
1. line purchase header
2. line purchase line
use data item properties DataItemLinkReference and DataItemLink to link the data items.best regards
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 320 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