Hi, I am trying to create a report that captures b...
# general
r
Hi, I am trying to create a report that captures both the vendor's email address and the Original Job ID in fulfillment. However, I encountered some difficulties: • The Sales Order Report allows me to capture the vendor email address, but not the Original Job ID. • The Item Fulfillment Report captures the Original Job ID, but it doesn't include the vendor email address. Could you assist me in finding a way to generate a report that includes both the vendor's email address and the Original Job ID? I appreciate your support in resolving this issue.
Can anyone assist on this matter?
m
@Riina what record is this?
r
@MGBC Screenshot is showing a Sale order page if that is your question.
m
You would need to use a script, sourcing or workflow to add the vendor email as a custom field on either the sales order or fulfillment record then pull that custom field into either report
r
@MGBC Is a script something we can ask you guys to get a support?
m
Yes we can support that
r
@MGBC Thank you will the support be free of charge?
m
We wouldn’t be able to write a script via slack but we could help support you with the workflow or sourcing which should solve the issue. We would need more information about your account and records to be sure so maybe we should start a DM
r
Thank you @MGBC let's start a DM. Slack DM or Email (r.takada@koala.com) should be good.