Record value are not inserting in Reference field through integration EMERGENCY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2024 01:36 AM
@Ankur Bawiskar @Community Alums @Sohail Khilji @Maik Skoddow
Please help me I have reference field in PO Table which is configured with CORE__COMPANY TAble
In general if I type vendor code in reference field it is reading the value and setting in the field
The same if i pass the vendor code through integration via flow the record is inserting as a blank I can see the same vendor code is available in corr_company table why it is not inserting with the existing name value of company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2024 01:54 AM
The [i] icon next to the Vendor field suggests that the field is not empty, but rather contains a value that is not a valid sys_id and a sys_id that does not exist in the table, which the reference field is pointing to. Check the XML view of the record to see what value is actually stored in the Vendor field at the database level.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2024 02:25 AM
In XML it has the vendor code value why it is not displaying the correct name why it is blank
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2024 02:37 AM
SEE MY XML It is passing empty value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2024 03:15 AM
It is because Vendor is a reference, a not a string field. You need to look up the sys_id of the appropriate Company record and put that sys_id into your Vendor field instead of the vendor code.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/