We are working on an RF-SMART Shipping integration with our NetSuite instance.
RF-SMART is currently pulling quantity values to the packing slip using the item's base unit of measure rather than the converted unit of measure displayed on the Sales Order. As a result, the quantity printed on the packing slip is inaccurate.
RF-SMART support suggested creating a custom transaction line field that sources the Sales Order Quantity and makes that value available on the Item Fulfillment record. We created a custom transaction line field (custcolso_qty) and configured it to source from:
- Source List: Sales Order
- Source From: Quantity
The field is displayed on both the Sales Order and Item Fulfillment line levels.
Current Results:
- If a value is manually entered into the custom field on the Sales Order, the value successfully carries over to the Item Fulfillment line.
- The custom field does not automatically populate with the Sales Order Quantity value.
- The field remains blank on both the Sales Order and Item Fulfillment unless populated manually.
- We also tested a default formula using
{quantity}, but the field still does not populate automatically.
Because the value transfers correctly from the Sales Order to the Item Fulfillment when entered manually, it appears the issue is specifically with sourcing or populating the custom field from the native Quantity field on the Sales Order line.
Has anyone successfully sourced a transaction line field from the standard Sales Order Quantity field, or is a workflow/script required to populate the custom field before it can be passed to the Item Fulfillment?
Thank you for any guidance.