Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Data Exchange Setup for EFT
CodeViper
Member Posts: 28
I am setting up an EFT for a Canadian bank that for the date, uses "MMDDYY".
Setting up the Data Exchange Def shouldnt be this complicated.
Using the current files and setup for RB, when the when it creates the mappings and such, makes the FILE CREATION DATE and converts it to a Julian date format.
There should be a place to either check if you want that date... or to keep is a standard date.
In the date exchange column definitions... should have a way to set the date back or something like that.
I have tried in the Data Format column '<Day,2><Month,2><Year>' but it balks at that.
I am trying to keep from having to use code... as this is "supposed to work from a user perspective with no changes to code as its all setup", or so I have been told.
Is there something I am missing in the creation of the Data Exchange Definition and setup?
All I want is my "2019010" Julian date to read what it originally was "01/09/2019"... and then converted to MMDDYY.
Suggestions?!?
Thanks In Advance.
A-A-Ron
Setting up the Data Exchange Def shouldnt be this complicated.
Using the current files and setup for RB, when the when it creates the mappings and such, makes the FILE CREATION DATE and converts it to a Julian date format.
There should be a place to either check if you want that date... or to keep is a standard date.
In the date exchange column definitions... should have a way to set the date back or something like that.
I have tried in the Data Format column '<Day,2><Month,2><Year>' but it balks at that.
I am trying to keep from having to use code... as this is "supposed to work from a user perspective with no changes to code as its all setup", or so I have been told.
Is there something I am missing in the creation of the Data Exchange Definition and setup?
All I want is my "2019010" Julian date to read what it originally was "01/09/2019"... and then converted to MMDDYY.
Suggestions?!?
Thanks In Advance.
A-A-Ron
0
Answers
Did you tried with this format MM/dd/yyyy? , try to change it with MM/dd/yy.the char M should be M and not m.
Regards.
I fixed my issue by adding another field to the export table and changing the code unit to store the date "as is"... so I can then pull it into the Data Definition for output to a EFT file. Don't like coding for what was told was "all user setup".