Field Service

Get Involved. Join the Conversation.

Topic

    Shankar Narayanan
    Adding CRM No / ApptNumber in Inventory Extract
    Topic posted October 10, 2017 by Shankar NarayananBronze Trophy: 5,000+ Points, tagged Inventory / Parts 
    57 Views, 2 Comments
    Title:
    Adding CRM No / ApptNumber in Inventory Extract
    Content:

    Hi All,

    Currently in the daily extract, we can configure to pull custom fields mapped against the inventory entity. Is there an option to capture apptnumber field in the inventory extract? Currently we have to read the inv_aid & query the activity no to get apptnumber. It would be of great help if anyone can suggest a simpler solution.

    Regards,

    Shankar

    Version:
    17.2

    Comment

     

    • Zsolt Tolgyesi

      Hi Shankar,

      I've also just found that activity related field. I believe you need to build separate tables based on the extracts and link them with AID together.

      Regards,
      Zsolt

    • Shankar Narayanan

      Thanks Zsolt. I was going the same as I dont have a database so I was reading the file & pulling the apptnumber from get activity. I was hoping there was a different way where we can get activity fields like inv_aid ( available out of the box)