problem in data import

vikas
Member Posts: 46
hi...
i am trying to import some data like "document type","sell to customer","no." from a text file through dataport into sales header table. but the problem is that only these three fields get updated. But, i want to update all the fields as it happens in sales order form.
I have also tried the option, callfieldvalidate available in the dataport
i am trying to import some data like "document type","sell to customer","no." from a text file through dataport into sales header table. but the problem is that only these three fields get updated. But, i want to update all the fields as it happens in sales order form.
I have also tried the option, callfieldvalidate available in the dataport
0
Comments
-
I guess that within the OnAfterGetImport trigger, you may wish to call the validate function for the fields you are importing
validate("sell-to customer no.")
This would thenhave the effect of populating the associated fields.
Does this help?0 -
Calling Validate of the field in OnAfterGetImport trigger has the same effect as setting CallFieldValidate=Yes.
BUT,
When using property the fields are imported and validated in the same order as they appear in the Field Designer.
If using Validate in OnAfterGetImport trigger you can set your own order of validate calls.®obi
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯0 -
Which other fields do you expect to be filled ?
There can be other trggers that can fill your fields that are not run. These are for sure triggers on forms, that are run when manualy keying in your document.
You should check this triggers...®obi
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯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