Announcements
5
I have done this many times before; but, it has been a couple years.
what is the file format?
I have a .csv with account #, descrip, Category, Type, Typical
eX: 110000100,Petty Cash,1,0,0
*This post is locked for comments
Thanks for the response! The input string that ended up working for my example above was:
110000100,Petty Cash,Cash,Balance Sheet,Debit
There error I was receiving ended up being an issue on how I launched the applications.
I was opening GP as my window log-in user; but, launching Integration Manager as 'run as administrator'
Once I launched GP as Admin the import was successful!
Thanks again,
Julie
Say for example you account format is "1100-0001-00" in GP, you will need to create a field script for the Account Number field as follows:
Share
Report
All responses (
Answers (
AccountNumber = SourceFields("<your_source_query>.<your_acct_field>")
CurrentField.Value = Mid(AccountNumber, 1, 4) & "-" & Mid(AccountNumber, 5, 4) & "-" & Mid(AccountNumber, 9, 2)
In the above, <your_source_query> represents the name of the Source Query containing the account number, and, of course, <your_acct_field> is the actual name of the Account Number field in the file.
#1
Almas Mahfooz
3
User Group Leader
