I’ve got an Excel Migration Job that’s giving me fits. The solution may lie in Excel itself but so far nothing I’ve tried works. Perhaps it’s not Excel and there is an issue with my migration job.I’m migrating Fixed Assets depreciation distribution detail. Note that the migration job for the distribution header worked without problems. The source Excel file has a column that requires formatting. Specifically, I’ve used Excel to format leading zeros to 3 positions: ‘1’ becomes ‘001’, ‘50’ becomes ‘050’, etc.However when I Validate a few lines as a test, IFS migration seems to “see” the values in that formatted column without the formatting: ‘001’ is seen as ‘1’, ‘050’ is seen as ‘50’. I’ve tried every approach and finagle I can think of so I’m here asking for insight.Lucy
We are getting ready for an IFS 10 go-live in October of 2020. I’m interested in learning what others have done to facilitate Postal Code and Address validation in IFS. It looks as if IFS requires that States, Counties, Cities, and Countries be set up before Postal Codes can be created. Is this data entry typically done manually? Is there an import capability for this relatively static data? Does IFS have any APIs that facilitate address validation? Are there recommended 3rd party serices from which to obtain US and international state/county/city/country/zipcode data to import? Thank you for any insight you can provide in how best to approach this task.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.