Headers and Lines Using Dataport

gulamdastagir
Member Posts: 411
Hi navies,
I have created a dataport to import the lines from csv file.
But the Requierment is toalso cretate the header when a filter is selected on the dataport and then create the lines for the dataport.
Purchase header does not have any dataport fields only purchsae line has dataport fields
My dataport looks like this(wihout indentation)
Purchase Header
Purchase Line
I wrote the code on the Predataport
when i run the code unit the dialog box appears but nothing is accomplished.....thaks for any help
I have created a dataport to import the lines from csv file.
But the Requierment is toalso cretate the header when a filter is selected on the dataport and then create the lines for the dataport.
Purchase header does not have any dataport fields only purchsae line has dataport fields
My dataport looks like this(wihout indentation)
Purchase Header
Purchase Line
I wrote the code on the Predataport
"Purchase Header"."Document Type":="Purchase Header"."Document Type"::Order; NS.RESET; IF NS.GET('INV-NUM',10000) THEN LN:=INCSTR(NS."Last No. Used"); "Purchase Header"."No.":=LN; "Purchase Header"."Buy-from Vendor No.":="Purchase Header".GETFILTER("Purchase Header"."Buy-from Vendor No."); "Purchase Header".INSERT(TRUE);
when i run the code unit the dialog box appears but nothing is accomplished.....thaks for any help
Regards,
GD
GD
0
Comments
-
Insert a integer table in your data item. And filter it into 1 record only. On its dataport fields place the record fieldcaption. Ex. Record.FIELDCAPTION("Field name"). If you want this data item to be shown only if there is a filtering selected, then use the GETFILTER/GETFILTERS and SKIP function in the OnBeforeExportRecord trigger of the Integer data item.Navision noob....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