Changes

Auto Loader

56 bytes added, 19:13, 10 February 2018
Updating Account Parent
: [[Image:Auto10b.png]]
: ''For example, if the imported account file contains a parent ID field, then this can be matched to the account table – providing each company with a parent company.''
: '''Updating Account Parent AutoLoader Configuration Example:'''
: [[File:Update_Account_Parent_Example.JPG]]
: '''The Account field AutoLoader Parent ID field is a empty an Account field that will get populated with the second value in (Parent ID) from the CSV record below.''': '''AutoLoader Source File Example:'''
: [[File:Update_Account_Parent_Example_-_Source_File.JPG]]
: '''Action: A two column report with the Company ID and the Parent ID needs to be created, exported to a CSV file and uploaded to the associated AutoLoader SmartFolder. '''
: Result: The Account records with a Company ID IN (278520,297733,316703) will have their Parent ID changed to 349238.