Print data from different tables in the rows of a ZPL label

(1) Share

Report

Posted on by CU04111246-0

This is part of my code for printing a product receipt journal. Everything is printed correctly, except for (attention information ($PurchLine_1.ReqAttention$ ) and the Requester ($HcmWorker_1.PersonnelNumber$). These are fields in the purchase order lines details (address tab). When printing the label the information and requester of the first line are printed for every line. How do I need to change my code? Do I need to make different joints?

^FX Content lines

{{Row Table=VendPackingSlipTrans_1 StartY=450 IncY=112 RowsPerLabel=6
^FT20,$position.YPos$^A0N,22,23^FH\^CI28^FD$VendPackingSlipTrans_1.PurchaseLineLineNumber$^FS^CI27
^FT70,$position.YPos$^FB415,4,,^A0N,22,23^FH\^CI28^FD$EcoResCategory_1.Name$ $PurchLine_1.ReqAttention$^FS^CI27
^FT490,$position.YPos$^A0N,22,23^FH\^CI28^FD$VendPackingSlipTrans_1.Qty$ $VendPackingSlipTrans_1.PurchUnit$^FS^CI27
^FT580,$position.YPos$^A0N,22,23^FH\^CI28^FD$HcmWorker_1.PersonnelNumber$^FS^CI27
}}

Categories:

Dynamics 365 Supply Chain Management

All responses (3)

Answers (0)

CU04111246-0 6 on at

Like (0)

Report

Print data from different tables in the rows of a ZPL label

@lvdtang I make use of Custom labels
CU04111246-0 6 on at

Like (0)

Report

Print data from different tables in the rows of a ZPL label

This is the code.

{{LabelStart
^XA
^FWN
^CI28

^FX Squares

^FO10,20^GB380,210,1,B,0^FS

^FO420,20^GB380,210,1,B,0^FS

^FO8,260^GB47,100,2,B,0^FS
^FO55,260^GB425,100,2,B,0^FS
^FO480,260^GB90,100,2,B,0^FS
^FO570,260^GB230,100,2,B,0^FS

^FO8,360^GB47,110,1,B,0^FS
^FO55,360^GB425,110,1,B,0^FS
^FO480,360^GB90,110,1,B,0^FS
^FO570,360^GB230,110,1,B,0^FS

^FO8,470^GB47,110,1,B,0^FS
^FO55,470^GB425,110,1,B,0^FS
^FO480,470^GB90,110,1,B,0^FS
^FO570,470^GB230,110,1,B,0^FS

^FO8,580^GB47,110,1,B,0^FS
^FO55,580^GB425,110,1,B,0^FS
^FO480,580^GB90,110,1,B,0^FS
^FO570,580^GB230,110,1,B,0^FS

^FO8,690^GB47,110,1,B,0^FS
^FO55,690^GB425,110,1,B,0^FS
^FO480,690^GB90,110,1,B,0^FS
^FO570,690^GB230,110,1,B,0^FS

^FO8,800^GB47,110,1,B,0^FS
^FO55,800^GB425,110,1,B,0^FS
^FO480,800^GB90,110,1,B,0^FS
^FO570,800^GB230,110,1,B,0^FS

^FO8,910^GB47,110,1,B,0^FS
^FO55,910^GB425,110,1,B,0^FS
^FO480,910^GB90,110,1,B,0^FS
^FO570,910^GB230,110,1,B,0^FS

^FX Labels

^CF0,25
^FO20,30^FDLieferanten Nr.:^FS
^FO425,30^FDDatum:^FS
^FO425,75^FDLS Nummer:^FS
^FO425,120^FDSachbearbeiter:^FS
^FO425,165^FDBestellung Nr.:^FS
^FO12,300^FDPos.^FS
^FO140,300^FDBezeichnung^FS
^FO600,300^FDWarenempfänger^FS
^CF0,20
^FO485,280^FDgebuchte^FS
^FO490,320^FDMenge^FS

^FX Content header

^CF0,25

^FO180,30^FD$VendPackingSlipJour_1.OrderAccount$^FS
^FO20,75^FD$PurchTable_1.PurchName$^FS
^FB350,3,,^FO20,110^FD$VendPackingSlipJour_1.vendAddress()$ ^FS

^FO505,30^FD$VendPackingSlipJour_1.DeliveryDate$^FS
^FO555,75^FD$VendPackingSlipJour_1.PackingSlipId$^FS
^FO585,120^FD^FS
^FO585,165^FD$VendPackingSlipJour_1.PurchId$^FS

}}

^FX Content lines

{{Row Table=VendPackingSlipTrans_1 StartY=450 IncY=112 RowsPerLabel=6
^FT20,$position.YPos$^A0N,22,23^FH\^CI28^FD$VendPackingSlipTrans_1.PurchaseLineLineNumber$^FS^CI27
^FT70,$position.YPos$^FB415,4,,^A0N,22,23^FH\^CI28^FD$EcoResCategory_1.Name$ $PurchLine_1.ReqAttention$^FS^CI27
^FT490,$position.YPos$^A0N,22,23^FH\^CI28^FD$VendPackingSlipTrans_1.Qty$ $VendPackingSlipTrans_1.PurchUnit$^FS^CI27
^FT580,$position.YPos$^A0N,22,23^FH\^CI28^FD$HcmWorker_1.PersonnelNumber$^FS^CI27
}}

{{LabelEnd
^PQ$dsparams.MengederEtiketten$.,0,1,Y
^XZ
}}
lvdtang 1,917 on at

Like (0)

Report

Print data from different tables in the rows of a ZPL label

Good day,

Do you use the feature 'Custom labels'?

Best regards,

Laurens van der Tang