Generating custom Batch number during reception

I am going to show how you can generate a custom batch number during the reception flow via customization framework.

You can find more information about the technology on the url below:

Customize Flows on Mobile Client

Start the Mobile Client in customization mode and navigate to the screen where you can enter the batch number

Enable the customization mode by clicking on the gear icon, click on the screen and then the customization window will appear. Go to the Events tab and set the name of the query and press Save button.
I am going to use:  GenerateBatchAtReception


The query will appear in group PMX_CLIENT_CUSTOMIZATION_USER_QUERIES
Open the query in SAP and define the following query:

SELECT
"ItemCode" + CAST(YEAR(CURRENT_TIMESTAMP) as nvarchar(4)) as "txtBatchNumber"
FROM OITM
WHERE "U_PMX_CUDE" = '$[lblItem]'

Start the Mobile Client without customization mode to see the result. Customization doesn't work in customization mode.

Video