Nada Ahmed
10/21/2024, 9:58 AMCeligo AI
10/21/2024, 9:58 AMAI generated answer (using internal Slack threads):To get the quantity for each line in an item fulfillment summary saved search, you can use the
{quantity}
field. However, if you are dealing with multiple item receipts or partial deliveries, you might encounter issues with multiple lines for the same item.
To maintain a single line for each item, you can use the "Quantity Fulfilled/Received" field, which sums up all item receipts. But this field is always in base units. If you want to get this in transaction units, you can use the following formula:
{quantityshiprecv} / ({quantity} / {quantityuom})
This formula divides the quantity shipped/received by the ratio of quantity to quantity in transaction units (UOM).
If you want to convert the quantity to the primary stock unit, you can use the {stockunit}
field. However, if your units naming pattern doesn't include the conversion rate, you might not be able to derive the stock unit's conversion rate from the saved search. Unfortunately, saved searches are unable to pull conversion rate.
******
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/21/2024, 9:59 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.843338549
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.843053758
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83814317
Celigo AI
10/21/2024, 9:59 AM