Scruffy
04/01/2025, 4:37 PMCeligo AI
04/01/2025, 4:37 PMAI generated answer (using internal Slack threads):To have the partial Item Fulfillment ADV PDF show back ordered quantities of a sales order, you can use the
${item.quantitybackordered}
field in your Advanced PDF/HTML Templates. However, this might not work in all cases, such as with Cash Sales.
If ${item.quantitybackordered}
does not work, you can create a custom transaction line field with a formula as a default value: {quantityordered}-nvl({quantity},0)
. This formula calculates the backordered quantity by subtracting the fulfilled quantity ({quantity}
) from the ordered quantity ({quantityordered}
).
For picking tickets, you might need to use a similar approach. If ${item.quantitybackordered}
does not return any results, you can use the formula quantity - committed
to calculate the backordered quantity.
Please note that these solutions are based on the assumption that 'backordered' is the remaining quantity after subtracting the committed or fulfilled quantity from the ordered quantity.
******
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:37 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823826313
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814723969
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.81369108
Celigo AI
04/01/2025, 4:37 PM