Nada Ahmed
10/16/2024, 8:40 AMCeligo AI
10/16/2024, 8:40 AMAI generated answer (using internal Slack threads):To source the Purchase Order Number from the Sales Order to the Item Fulfillment, you can use a formula text field in your saved search. The field
{appliedtotransaction.otherrefnum}
should give you the Purchase Order Number. However, if this field is giving you the Sales Order Number instead, you can try selecting the PO/check# from the Applied to Transaction fields.
If you are trying to source the corresponding Item Fulfillment record from a Sales Order, you would need a field on the Sales Order called "Related IF" (list/record > Transaction. Filter: Type = Item Fulfillment), and a script on the Item Fulfilment when saved to set the Created From's "Related IF" to the current Item Fulfilment. This would then be available on your search as "createdfrom.custbody_relatedif".
If you are trying to display the Purchase Order Number (tranid) on a line item of a Vendor Bill, you can look for the createdFrom
field on the main level of the bill. If your bills are created from multiple PO's, you can try looking for the Applied To Transaction field in your search.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
10/16/2024, 8:40 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838071644
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834596
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.822201312
Celigo AI
10/16/2024, 8:40 AM