Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Unanswered

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

Posted on by 6
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
}}
 
 
  • CU04111246-0 Profile Picture
    CU04111246-0 6 on at
    Print data from different tables in the rows of a ZPL label
    @lvdtang I make use of Custom labels
  • CU04111246-0 Profile Picture
    CU04111246-0 6 on at
    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 Profile Picture
    lvdtang 1,887 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans