Is it possible to do Dataport indention ?

vid_rut
Member Posts: 14
With the dataport fileformat as fixed or variable ,is it possible to do dataport indention ?
I want to export the data from both tables sales invoice header and sales invoice line so that , It export firstline from sales invoice header and in the next line deyails from the sales invoice line.
If it is possible ,pls suggest me your idea.
No CustomerName Amount
1 XYZ 1000 -->from sales invoice header
lineamount 800 -->from sales invoice line
sales tax 100 -->from sales invoice line
excise 100 -->from sales invoice line
2 ABC Ltd 1500
lineamount 1000
sales tax 200
excise 300
I want to export the data from both tables sales invoice header and sales invoice line so that , It export firstline from sales invoice header and in the next line deyails from the sales invoice line.
If it is possible ,pls suggest me your idea.
No CustomerName Amount
1 XYZ 1000 -->from sales invoice header
lineamount 800 -->from sales invoice line
sales tax 100 -->from sales invoice line
excise 100 -->from sales invoice line
2 ABC Ltd 1500
lineamount 1000
sales tax 200
excise 300
0
Comments
-
Define table "Integer" for export and in Dataport Field list define you global variables which will have your needed values. Let say define two global variables one for sales header (SH) and one for sales lines (SL). Then in Dataport Fileds list write SH."Document No."; SL."No." and so on.0
-
Indent in dataport is only for using with UPXML format (user portal).0
-
yes...but in navision attain.LR0
-
Well, I'm also interested in doing the same thing as vid_rut wants to do.
I know that indent is only for UPXML format.
The way to do this seems to use Table Integer as DataItem, but I don't understand how to do ???
Could anyone give me more details about this?0 -
Instead of a dataport, you could use a report, and handle the output of the data by hand.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