- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2014 07:54 AM
Hi Everyone,
I am trying to import Expense lines but I keep getting an error. The error is on the Source ID field. I can't figure out how to import to that, does anyone know how to do this
Thanks
Solved! Go to Solution.
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2014 11:07 AM
Hi Lepipasc
I should have updated this!
Using the transform mapping function doesn't work to insert values in to the source id field, you have to use a transform script for it to work (don't ask me why).
This is what I used and it worked
target.source_id=source.u_source_id;
target.source_table=source.u_source_table;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2014 10:42 AM
Hi David,
You need to fill your cost source (CI or Task). Source ID field will be filled automatically!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2014 11:07 AM
Hi Lepipasc
I should have updated this!
Using the transform mapping function doesn't work to insert values in to the source id field, you have to use a transform script for it to work (don't ask me why).
This is what I used and it worked
target.source_id=source.u_source_id;
target.source_table=source.u_source_table;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2014 01:53 PM
Hi David,
I added the below two lines in the Transform Script with an onBefore trigger:
target.source_id=source.u_source_id;
target.source_table=source.u_source_table;
But I am still getting the following error:
Operation against file 'fm_expense_line' was aborted by Business Rule 'Source ID check^b3b30dd96ff6e100ddcb1bd27b3ee48c'. Business Rule Stack:Source ID check
What do you think is going wrong on this one?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2014 01:12 PM
I added the below two lines in the Transform Script with an onBefore trigger:
target.source_id=source.u_source_id;
target.source_table=source.u_source_table;
But I am still getting the following error:
Operation against file 'fm_expense_line' was aborted by Business Rule 'Source ID check^b3b30dd96ff6e100ddcb1bd27b3ee48c'. Business Rule Stack:Source ID check
What do you think is going wrong on this one?