License Plate Numbers in Sage X3

By | June 28, 2024

Step1. How to create and set up the various license plate numbers?

Sequence number creation

Open: Setup > General parameters > Sequence number definition > 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 to the respective container on

Common data >> logistic table >> container

Step 2. Creating an Internal type container

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).It must be set to the Internal type.

The license plate numbers are generated from a container, based on the sequence number assigned to it.

Fig 2. Create an internal container

To create an internal container:

  • Click the Create action.
  • Set the container code.
  • Select the container type: pallet, pack, barrel, big bag, (etc.). These values are contained in a dedicated local menu available for setup.
  • 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.
  • 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.
  • 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 (‘Etiquette’ in French)).
  • Enter the physical characteristics of the container: Size and capacity. This data is for information only.
  • You can also add a picture and a description.

Step. 3 How to set up products to be managed in stock on logistics units?

Product categories

Open: Common Data > Products > Product categories

  • Click New.
  • Enter the information required to create the product category, in particular, in the Management section.
  • The product must be managed in stock.
  • Enable the Location management.
  • 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.
  • Click Create.

Products

Open: Common Data > Products > Products

  • Click New.
  • Select a product category that authorizes the management of license plates.
  • Enter the information required to create the related product record.
  • Click Create.

Product-sites

Open: Common Data > Products > Product-sites

  • Click New.
  • Enter the information required to create the related product record for a given site.
  • The product setup and product category are recovered on the product-site.
  • 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.
  • 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.
  • Enter the container capacity table, as shown below:

          Container   Unit           No. of units per container

          Selection of internal containers: only Internal type containers can be selected.

  1. Selection of the existing unit for the product: stock or packaging unit
  2. Entry of a number of units for the container

Step.4 How to define a stock receipt with or without a license plate number?

Stock management rules

Open: Setup > Stock > Stock management rules

The stock management rules are used to indicate if the license plate number is mandatory or optional, for each receipt movement.

This applies to the following receipt movement types:

  • Miscellaneous receipt
  • Supplier receipt
  • Receipt for subcontract
  • Delivery return
  • Loan delivery return
  • Delivery return for subcontract

Only Internal and Dock locations use license plate numbers.

Customer and Subcontractor locations cannot track license plate numbers. If the stock movement is for a ‘Customer’ or ‘Subcontractor’ location, the license plate number is lost. This is the case when validating a loan delivery for example.

Product categories

Open: Common Data > Products > Product categories

The setup of Stock management rules is used on the Product category. It can be modified for each category.

The product category can also be set by site. In this case, the setup can even be adjusted to each product-site category.

In the Receipts section, indicate if the license plate number is mandatory or optional for each stock receipt movement of the product:

If the license plate number is mandatory, then it must be entered on the document line or line details.

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.

Step. 5 How to create license plate numbers?

Mass creation

Open: Stock > License plate numbers > License plate number creation

From the menu dedicated to the management of license plate numbers, you can launch a utility for mass creating license plate numbers.

  • Enter the relevant storage site
  • The container from which the numbers will increment. Only Internal containers can be selected.
  • Specify if the license plate numbers need to be active or not.
  • Active license plate numbers can be viewed and used. Inactive license plate numbers are not displayed for selection.
  • Specify if the generated license plate numbers must be for single-products and/or single-lots.

Fig 3. Mass License Plate Number Creation

  • 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.
  • Enter the number of license plate numbers to be created.
  • To print the bar code labels:
  • Select the Printing check box.
  • Specify the format of the labels to be printed and the destination printer. This information is preloaded based on the presetting.
  • Click OK.
  • A log file is displayed. It lists all the license plate numbers that were created.
  • These records are loaded in the LPN table.

Unit creation

You can create license plate numbers per unit.

Open: Stock > License plate numbers > License plate numbers

  • Click New.
  • Enter the license plate number, or leave blank to apply the sequence number
  • The relevant storage site
  • The internal container used

Fig 4. License Plate Number Unit Creation

  • The location, if you need to locate the license plate number as soon as it is created
  • 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.
  • Click Create:
  • The container license plate number is incremented based on the container sequence number. The record data is loaded in the LPN table.
  • The LPN status is Free, which means it is not linked to any product.