Scruffy
04/01/2025, 4:27 PMCeligo AI
04/01/2025, 4:28 PMAI generated answer (using internal Slack threads):To have the Item Fulfillment ADV PDF show back ordered quantities of a sales order, you can use a custom transaction line field with a formula as a default value. The formula would be
{quantityordered}-nvl({quantity},0)
. This formula calculates the backordered quantity by subtracting the fulfilled quantity ({quantity}
) from the ordered quantity ({quantityordered}
).
In the context of an Advanced PDF/HTML Template, you can reference this custom field to display the backordered quantity.
Please note that the {quantity}
field represents the quantity that has been fulfilled/received. If you do partial fulfillments, you might need to adjust the formula accordingly.
******
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
04/01/2025, 4:28 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821464181
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.810407221
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.809811413
Celigo AI
04/01/2025, 4:28 PM