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

Rookie Asked on January 25, 2021 in How To's.
Add Comment
1 Answer(s)

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.

Beginner Answered on January 25, 2021.

Thanks for your reply, thought this would be the case, i’ll get in touch with our developers fro a script

on January 25, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor