Stock change

Use this transaction to perform the following actions:

  • Move stock from a stock line. It can be an internal location change and/or a stock status change and/or a unit change and/or an identifier change.

  • Generate stock movements and create a stock change document in Sage X3.

Prerequisites

In Sage X3, perform the following actions:

Functional prerequisites

  • Assignment (GESTCA)

    Open: Setup > General parameters > Sequence number definition > Assignment

    Check that a sequence number is defined and assigned to the Stock changes document.

  • Product (GESITM)

    Open: Common data > Products > Products

    Use this function to enter the product GTIN (Global Trade Item Number). This information is part of the GS1 composite barcode which can be used to identify the product. The GS1 composite barcode can also be used to identify other key information called Application Identifiers (AIs). In the Stock change transaction, when you scan a GS1 composite barcode, the following AIs are read and entered automatically: the GTIN, the Lot, and the Serial number. Other AIs can be part of the GS1 composite barcode but they are not managed in this transaction.

    To be used in this transaction, the GS1 composite barcode needs to include at least the 2 following AIs:
    • The GTIN. It is used to apply controls on the product.
    • At least another AI, not necessarily managed in this transaction.
  • Mobile Automation setup (FUNADCSEARCH)

    Open: Setup > Stock > Mobile Automation setup

    1. Go to the Stock search section.

    2. Select the Stock change flow type.

    3. Define the stock search filters that you want to use in this transaction. You can define up to 8 filters.

    In this transaction, these filters do not display in the order in which you have defined them in the Mobile Automation setup function. They always display in the following order: Location, Lot, Sublot, Serial number (when the management mode is Received/Issued), Status, Packing unit, PAC/STK conversion factor, Identifier 1 and Identifier 2, Custom field 1 and Custom field 2.

Web service prerequisites

  1. Open: Administration > Web services > Classic SOAP pools configuration

    Stop the web service pool.

  2. Stock change transactions (GESSCT)

    Open: Setup > Stock > Entry transactions > Stock change transactions

    Validate the ALL entry transaction.

  3. Web services (GESAWE)

    Open: Development > Script dictionary > Scripts > Web services

    Publish the CWSSCS web service.

  4. Open: Administration > Web services > Classic SOAP pools configuration

    Start the web service pool.

How to create a stock change

Open: Stock control > Stock change

To create a stock change, you must enter information on 3 pages:

  • The initial page is used to:
    • Set the Change date and the entry Transaction.
    • Identify the Product code.
  • The second page is used to select the product stock lines.

  • The third page is used to enter the quantity to move, the destination location and the other stock destination information.
    When you have completed the changes for this product, you can create the stock changes document, or select another product to perform another stock change which will be on the same stock change document.

Operating mode

  1. In the initial page, check that the Change date, Site and Transaction default values are correct.
  2. Scan, select or enter the Product code or UPC code. For more information, refer to the Stock change initial page section. The Enter stock details page automatically displays the list of the existing stock lines for the product.
  3. You can filter the list based on the selection filters displayed in the header. These filters are defined in the Mobile Automation setup function (FUNADCSEARCH). Refer to the functional prerequisites.
    When you scan a GS1 composite barcode on the initial page, the following detailed information is extracted from the code and entered automatically : The Lot and the Serial number. For more information, see the functional prerequisites.
  4. To access the stock line details, tap the line.
  5. Enter the quantity and the destination information. Tap Select.
  6. The previous Enter stock details page displays again. The checkbox for the stock line to move is automatically selected for the requested quantity.

  7. You can select another stock line to perform another stock change which will be in the same stock change document.

  8. Tap Next when you have completed all the stock changes for this product.

  9. You can perform another stock change for another product: Scan or select another product and repeat step 2 to step 8.

  10. Tap Create when you have completed the changes for all the products, and you are ready to validate the stock change creation.

    • If you could proceed with the creation, the generated stock change number displays. The stock change document and its movements are created.

    • If you could not proceed with the creation, an error or information message displays.

      • Tap Go back to display the previous page.

      • Tap Cancel to delete all the stock changes.

Step by step

Stock change initial page

   

Enter the details of the stock change.

  • The Change date defaults to today's date. You can change it until you tap Create and only to an earlier date. This date applies to all the stock changes performed in the same document.
  • The Site defined in the Site screen displays automatically. You cannot modify it on the current page.
  • The Transaction field displays only if you have access to several entry transactions. It defaults to the first available Stock change entry transaction (GESSCT) (sorted by alphabetical order).
    You can select another transaction from the drop-down list. This list is filtered based on your Function profile (GESAFT) permissions (access codes).
  • Scan, select or enter the Sage X3 product code, the UPC code, or the GS1 composite barcode. A warning message displays if the product is part of a stock count session.
If you scan the GS1 composite barcode in the product field, a Mandatory field message displays. You need to scan the GS1 composite barcode again.
   

You cannot tap Create: First, you need to save at least one product stock change.

   
After you have selected the product code, the Enter stock details page displays automatically.
   

Enter stock details page

Use this page to determine the stock line to move.

The header displays:

  • The product code and description
  • The stock site

The filters defined in the Mobile Automation setup function (FUNADCSEARCH) display here. Use them to filter the list of stock lines.
When you scan a GS1 composite barcode on the initial page, the Lot and the Serial number can be extracted from the code and entered automatically.

The list of stock lines displays.

Each stock line displays the stock line quantity and the product code. Additional dynamic information display, based on the selected stock filters.

   

Tap the stock line you want to move.

Stock change - Enter destination page

The page displays the stock details. You can enter the quantity to move and select the destination information.


 

 

 

 

The stock details.

Some of these fields are displayed or hidden depending on the stock detail information, on the product settings, or on the selected entry transaction.

The quantity to move defaults to the stock line quantity. You can change it. The origin unit displays.

  • Scan or select the destination information. Fields display according to the selected Stock change entry transaction being used. You do not have to enter all of them.

  • Select the Destination status. Its default value and the list of available authorized statuses depend on the receipt Management rules set for the Stock change Movement type in the Product category function (GESITG).
  • The Destination unit defaults to the product stock unit. You can select the packing unit from the drop-down list.
  • The Destination conversion factor automatically displays.
  • The Destination identifier fields display only if they are set as Entered in the entry transaction.
  • Tap Select to validate the quantity and save the stock destination details. The previous Enter stock details page displays.

    At this stage, the stock changes are saved in the UI only, and not in the database.
  • Tap Cancel to go back to the previous Enter stock details page.

Depending on how the product is managed, you might need to select the related stock details.
For example, if the product is managed by global serial number, you need to select the range of serial numbers to be moved, before selecting the other destination information.

   
   
   
Keep or update the quantity to move.

Select the Starting serial number. The Ending serial number is automatically selected based on the quantity.

Only sequential serial numbers can be selected: The quantity you enter must be consistent with the range of serial numbers.
Enter the destination information.
Tap the + icon to validate your selection and display a summary of the serial numbers to move.
     

 


 
   
   
   
   
   
   
   

The summary of the selected stock details is displayed. You can add another quantity and another range of serial numbers.

   
 

When you have selected all the serial numbers to move, tap one of the following actions:

  • Select to validate the entered information. The previous Enter stock details page displays. The checkbox for the stock line is automatically selected for the requested quantity.

  • Cancel to cancel the entered information and go back to the previous Enter stock details page.

 

Enter stock details page

The previous Enter stock details page displays.

The checkbox for the stock line to move is automatically selected for the requested quantity.

You can select another stock line to perform another stock change which will be in the same stock change document.

   
   

Tap Next when you have completed all the stock changes for this product. You are ready to perform the following actions:

Create the stock change document and generate stock movements

The list of products which will be part of the change provides the following information at the bottom of the page:

  • Product code
  • Stock quantity, stock unit of measure

You can perform the following operations:

  • Scan or select another product to perform another stock change which will be in the same stock change document.

  • Validate the creation of the stock change document.

Before validating the creation, you still have the possibility to delete a saved stock change: Tap the delete icon.

   
   
   

Tap Create when you have completed all the product changes and you are ready to validate the stock change creation and print the stock labels.

To print labels, refer to the functional prerequisites.

 

 

 

A GraphQL payload is sent to Sage X3. The data of this payload is mapped with a web service object named CWSSCS to create the stock change document and the stock movements in the Sage X3 database.

A message displays the generated document number and confirms that the printing is launched.

   
   
   
   

Limitation

  • You cannot enter a quality request number.