Create an SQL to link Production Orders from Sales Order Line Items

TI Hybel

Hi!

How I can link an Production Order that has been created from a Sales Order Line?

On BEAS_FTHAUPT table, I can get the Sale Order Docnum, but I am haveing some issues when my Sales Order have many rows with the same Item Code.

SAP B1 9.3

Thanks in advance1

 

Comentarios

4 comentarios

Fecha Votos
  • Comment author
    Martin Heigl

    Hi, do you work with reservation?

    0
  • Comment author
    TI Hybel

    Not yet, but we are planning to

    0
  • Comment author
    Martin Heigl

    Hi,

    if you create a work order from sales order, the work order is linked automatically. Why do you need to link again?


    BEAS_FTPOS
    basetype = 17 (sales order)
    auftragint = ORDR.DocEntry
    basedocnum = ORDR.DocNum
    auftragpos (rdr1.linenum)
    baseline (rdr1.linenum)
    auftragherkunft "K"

    0
  • Comment author
    TI Hybel

    Hi Martin!

    My report didn't like with linenum of Sales Order... Your asnwer solve my question!

    these two columns are the conection that I was looking for!

    auftragpos (rdr1.linenum)
    baseline (rdr1.linenum)

    Thank you so much!

     

     

    0

Iniciar sesión para dejar un comentario.