{"id":29436,"date":"2024-06-28T11:39:12","date_gmt":"2024-06-28T11:39:12","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=29436"},"modified":"2024-11-25T06:12:55","modified_gmt":"2024-11-25T06:12:55","slug":"license-plate-numbers-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/06\/28\/license-plate-numbers-in-sage-x3\/","title":{"rendered":"License Plate Numbers in Sage X3"},"content":{"rendered":"\n<p><strong>Step1. How to create and set up the various license plate numbers?<\/strong><\/p>\n\n\n\n<p><strong>Sequence number creation<\/strong><\/p>\n\n\n\n<p>Open: Setup &gt; General parameters &gt; Sequence number definition &gt; Structures<\/p>\n\n\n\n<p>Before creating the license plate number, you must create a sequence number.<\/p>\n\n\n\n<p>This sequence number can include up to 18 characters.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"537\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-STRUCT-1024x537.png\" alt=\"\" class=\"wp-image-29438\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-STRUCT-1024x537.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-STRUCT-300x157.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-STRUCT-768x403.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-STRUCT-660x346.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-STRUCT.png 1222w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\">Fig 1.  Sequence Number<\/p>\n\n\n\n<p><strong>Link the Sequence code to the respective container on<\/strong><\/p>\n\n\n\n<p>Common data >> logistic table >> container<\/p>\n\n\n\n<p><strong>Step 2. Creating an Internal type container<\/strong><\/p>\n\n\n\n<p>There are two container types: Internal containers are used for logistics operations within the warehouse, and Freight containers are used for shipments and transportation (Purchasing logistics).<strong>It must be set to the Internal type<\/strong>.<\/p>\n\n\n\n<p>The license plate numbers are generated from a container, based on the sequence number assigned to it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"529\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-CONTAINER-SCREEN-1024x529.png\" alt=\"\" class=\"wp-image-29439\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-CONTAINER-SCREEN-1024x529.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-CONTAINER-SCREEN-300x155.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-CONTAINER-SCREEN-768x397.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-CONTAINER-SCREEN-660x341.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-CONTAINER-SCREEN.png 1367w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong>Fig 2.<\/strong> <strong>Create an internal container <\/strong><\/p>\n\n\n\n<p><strong>To create an internal container:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the Create action.<\/li>\n\n\n\n<li>Set the container code.<\/li>\n\n\n\n<li>Select the container type: pallet, pack, barrel, big bag, (etc.). These values are contained in a dedicated local menu available for setup.<\/li>\n\n\n\n<li>Enter the sequence number. If the sequence number is not entered, this implies that you want to enter the number of the container when you create it.<\/li>\n\n\n\n<li>Specify whether this is a single-product or single-lot container. You can modify these characteristics if needed during the license plate number generation stage.<\/li>\n\n\n\n<li>Enter the report code for the bar code labels to be printed. A standard report code is delivered by default: ETIQLPN (LPN for License plate number and ETIQ for label (\u2018Etiquette\u2019 in French)).<\/li>\n\n\n\n<li>Enter the physical characteristics of the container: Size and capacity. This data is for information only.<\/li>\n\n\n\n<li>You can also add a picture and a description.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step. 3 How to set up products to be managed in stock on logistics units?<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong><u>Product categories<\/u><\/strong><\/p>\n\n\n\n<p>Open: Common Data &gt; Products &gt; Product categories<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click New.<\/li>\n\n\n\n<li>Enter the information required to create the product category, in particular, in the Management section.<\/li>\n\n\n\n<li>The product must be managed in stock.<\/li>\n\n\n\n<li>Enable the Location management.<\/li>\n\n\n\n<li>Enable the License plate number management (LPNMGTCOD field in the ITMCATEG table). The License plate number management can only be accessed when the Location management is enabled.<\/li>\n\n\n\n<li>Click Create.<\/li>\n<\/ul>\n\n\n\n<p><strong><u>Products<\/u><\/strong><\/p>\n\n\n\n<p>Open: Common Data &gt; Products &gt; Products<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click New.<\/li>\n\n\n\n<li>Select a product category that authorizes the management of license plates.<\/li>\n\n\n\n<li>Enter the information required to create the related product record.<\/li>\n\n\n\n<li>Click Create.<\/li>\n<\/ul>\n\n\n\n<p><strong><u>Product-sites<\/u><\/strong><\/p>\n\n\n\n<p>Open: Common Data &gt; Products &gt; Product-sites<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click New.<\/li>\n\n\n\n<li>Enter the information required to create the related product record for a given site.<\/li>\n\n\n\n<li>The product setup and product category are recovered on the product-site.<\/li>\n\n\n\n<li>Check that the license plate number management is enabled. It can be enabled or disabled at the level of the product-site record. It can only be enabled if the Location management is enabled.<\/li>\n\n\n\n<li>Enter the Default container (TCTRDEF field). This information is optional, but this value will be initialized on the document line when a product is received into stock.<\/li>\n\n\n\n<li>Enter the container capacity table, as shown below:<\/li>\n<\/ul>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Container&nbsp;&nbsp; Unit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No. of units per container<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selection of internal containers: only Internal type containers can be selected.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><\/strong><strong>Selection of the existing unit for the product: stock or packaging unit<\/strong><\/li>\n\n\n\n<li><strong>Entry of a number of units for the container<\/strong><\/li>\n<\/ol>\n\n\n\n<p><strong>Step.4 How to define a stock receipt with or without a license plate number?<\/strong><\/p>\n\n\n\n<p><strong><u>Stock management rules<\/u><\/strong><\/p>\n\n\n\n<p>Open: Setup &gt; Stock &gt; Stock management rules<\/p>\n\n\n\n<p>The stock management rules are used to indicate if the license plate number is mandatory or optional, for each receipt movement.<\/p>\n\n\n\n<p><strong>This applies to the following receipt movement types:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Miscellaneous receipt<\/li>\n\n\n\n<li>Supplier receipt<\/li>\n\n\n\n<li>Receipt for subcontract<\/li>\n\n\n\n<li>Delivery return<\/li>\n\n\n\n<li>Loan delivery return<\/li>\n\n\n\n<li>Delivery return for subcontract<\/li>\n<\/ul>\n\n\n\n<p><strong>Only Internal and Dock locations use license plate numbers.<\/strong><\/p>\n\n\n\n<p>Customer and Subcontractor locations cannot track license plate numbers. If the stock movement is for a \u2018Customer\u2019 or \u2018Subcontractor\u2019 location, the license plate number is lost. This is the case when validating a loan delivery for example.<\/p>\n\n\n\n<p><strong>Product categories<\/strong><\/p>\n\n\n\n<p>Open: Common Data &gt; Products &gt; Product categories<\/p>\n\n\n\n<p>The setup of Stock management rules is used on the Product category. It can be modified for each category.<\/p>\n\n\n\n<p>The product category can also be set by site. In this case, the setup can even be adjusted to each product-site category.<\/p>\n\n\n\n<p>In the Receipts section, indicate if the license plate number is mandatory or optional for each stock receipt movement of the product:<\/p>\n\n\n\n<p>If the license plate number is mandatory, then it must be entered on the document line or line details.<\/p>\n\n\n\n<p>If the license plate number is Optional, then it is optional on the document line or line details. The document is generated with no license plate number.<\/p>\n\n\n\n<p><strong>Step. 5 How to create license plate numbers?<\/strong><\/p>\n\n\n\n<p><strong><u>Mass creation<\/u><\/strong><\/p>\n\n\n\n<p>Open: Stock &gt; License plate numbers &gt; License plate number creation<\/p>\n\n\n\n<p>From the menu dedicated to the management of license plate numbers, you can launch a utility for mass creating license plate numbers.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter the relevant storage site<\/li>\n\n\n\n<li>The container from which the numbers will increment. Only Internal containers can be selected.<\/li>\n\n\n\n<li>Specify if the license plate numbers need to be active or not.<\/li>\n\n\n\n<li>Active license plate numbers can be viewed and used. Inactive license plate numbers are not displayed for selection.<\/li>\n\n\n\n<li>Specify if the generated license plate numbers must be for single-products and\/or single-lots.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"453\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-MASS-CREATION-1024x453.png\" alt=\"\" class=\"wp-image-29440\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-MASS-CREATION-1024x453.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-MASS-CREATION-300x133.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-MASS-CREATION-768x340.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-MASS-CREATION-660x292.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/LPN-MASS-CREATION.png 1152w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong>Fig 3. Mass License Plate Number Creation <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Specify the location if you need to locate the license plate number as soon as it is created. You can only enter a location of the Internal or Dock type.<\/li>\n\n\n\n<li>Enter the number of license plate numbers to be created.<\/li>\n\n\n\n<li>To print the bar code labels:<\/li>\n\n\n\n<li>Select the Printing check box.<\/li>\n\n\n\n<li>Specify the format of the labels to be printed and the destination printer. This information is preloaded based on the presetting.<\/li>\n\n\n\n<li>Click OK.<\/li>\n\n\n\n<li>A log file is displayed. It lists all the license plate numbers that were created.<\/li>\n\n\n\n<li>These records are loaded in the LPN table.<\/li>\n<\/ul>\n\n\n\n<p><strong><u>Unit creation<\/u><\/strong><\/p>\n\n\n\n<p>You can create license plate numbers per unit.<\/p>\n\n\n\n<p>Open: Stock &gt; License plate numbers &gt; License plate numbers<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click New.<\/li>\n\n\n\n<li>Enter the license plate number, or leave blank to apply the sequence number<\/li>\n\n\n\n<li>The relevant storage site<\/li>\n\n\n\n<li>The internal container used<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"642\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/4-1024x642.png\" alt=\"\" class=\"wp-image-29445\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/4-1024x642.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/4-300x188.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/4-768x481.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/4-660x414.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/4.png 1107w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong>Fig 4. License Plate Number Unit Creation<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The location, if you need to locate the license plate number as soon as it is created<\/li>\n\n\n\n<li>Specify if the license plate number must be set to single-product or multi-product. For single-product, specify if the license plate number must be single-lot or multi-lot.<\/li>\n\n\n\n<li>Click Create:<\/li>\n\n\n\n<li>The container license plate number is incremented based on the container sequence number. The record data is loaded in the LPN table.<\/li>\n\n\n\n<li>The LPN status is Free, which means it is not linked to any product.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Step1. How to create and set up the various license plate numbers? Sequence number creation Open: Setup &gt; General parameters &gt; Sequence number definition &gt; Structures Before creating the license plate number, you must create a sequence number. This sequence number can include up to 18 characters. Fig 1. Sequence Number Link the Sequence code\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/06\/28\/license-plate-numbers-in-sage-x3\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2,5,3162,13,7,8,3642,9,10,2796,11],"tags":[4239,4238,4205,1822,2871,1945,4240],"class_list":["post-29436","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-configuration","category-features","category-greytrix","category-integration","category-miscellaneous-tables","category-sage-erp-x3","category-sage-x3","category-sage-x3-consulting","category-standard","category-technical","category-tips","tag-license-plate-numbers","tag-license-plate-numbers-in-sage-x3","tag-lpn","tag-sage-x3","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blogs","tag-set-up-the-various-license-plate-numbers"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=29436"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29436\/revisions"}],"predecessor-version":[{"id":29447,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29436\/revisions\/29447"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=29436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=29436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=29436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}