Thank you for using the English version of the JTL-Guide!
We are currently still building up the English documentation; not all sections have been translated yet. Please note that there may still be German screenshots or links to German pages even on pages that have already been translated. This guide mostly addresses English speaking users in Germany.
We are currently still building up the English documentation; not all sections have been translated yet. Please note that there may still be German screenshots or links to German pages even on pages that have already been translated. This guide mostly addresses English speaking users in Germany.
Note: On 1 September 2024, JTL introduced new editions that bundle most of the previous individual services into different packages. In order for you to continue working as smoothly as possible, existing customers were automatically switched to the package configuration that best matched their existing contract. The individual packages differ in terms of limitations and/or range of functions. Therefore, some of the features described in the JTL-Guide may not be available to you as part of your booked JTL edition. You can change your package configuration in your JTL customer account. Find out more about the new editions and packages here. Check our FAQ for frequently asked questions about the product editions.
Example of custom overviews in the sales management
On this page you will find a sample SQL for custom overviews in the sales management of JTL-Wawi. Read the Creating custom overviews page to learn how to create custom overviews.
Shipping information
Create a custom overview in which you can see all shipping information for a selected sales order. The following information is dispalyed:
SQL for shipping information
SELECT tLieferschein.cLieferscheinNr AS Lieferscheinnummer
, CONVERT(VARCHAR, tVersand.dVersendet, 104) AS 'Versendet am'
, tVersandart.cAmazonCarrierCode AS 'Logistiker'
, tVersandart.cName AS 'Versandart'
, tVersand.cIdentCode AS 'Tracking ID'
, REPLACE(tVersandart.cTrackingUrlTemplate, '#IdentCode#', tVersand.cIdentCode) AS 'Trackinglink'
, tVersand.cHinweis AS 'Hinweis'
, eazybusiness.dbo.tbenutzer.cName AS Benutzer
FROM tbestellung
JOIN tLieferschein ON tLieferschein.kBestellung = tBestellung.kBestellung
LEFT JOIN tVersand ON tVersand.kLieferschein = tLieferschein.kLieferschein
LEFT JOIN tVersandart ON tVersandart.kVersandart = tVersand.kVersandArt
JOIN eazybusiness.dbo.tbenutzer ON eazybusiness.dbo.tbenutzer.kBenutzer = tVersand.kBenutzer
WHERE tBestellung.kBestellung = @Key
Related topics