RE: Sourcing line amount on Item Fulfilment from linked transaction Sales Order
Hi
Does anyone know how to source the item line amount from a sales order onto an Item fulfilment line?
I am trying to source item rate and amount on IF’s to create a printed document from the IF to comply with new EU regs after Brexit
We have instances where item rate is not used, when line qty is 1 only the amount field is used.
I sourced the item rate (when used on SO) by using (itemunitprice}does anybody know the id for the line amount?
Tried;
{itemunitamount}
{Createdfrom.line.amount}
Thanks
Someone else may have a solution, but I don’t think you can do this because, as your {createdfrom.line.amount} highlights, this needs a “double join” which isn’t possible.
You’d need a custom transaction line field on item fulfilments, and a user event script to copy data from the sales order to the custom field when fulfilments are created.
Thanks for your reply, thought this would be the case, i’ll get in touch with our developers fro a script