UDF Header to Invoice Detail

SOLVED

We have certain UDF fields in our Sales Order Header along with standard fields in the header.  Is it possible to link these fields to the show up on the invoice lines for the corresponding sales order.  Not so much a problem when we invoice one sale order, all the header information comes over in the header.  When we batch invoice we need all that data to show what lines go to which sales order.

Parents Reply Children
  • +1 in reply to jland47
    verified answer

    Indeed.  The AppliedSalesOrderNo is in the invoice detail table, so you should be able to script a lookup to the correct SO header and get what you want from there.

    The way Sage described the multi-SO invoice process, each invoice has a "main" SO, with lines for other SO being added, and for what you're asking I expect a script is the most practical option.