Showing posts with label zebra language. Show all posts
Showing posts with label zebra language. Show all posts

Wednesday, April 5, 2023

Date, time and number format in layouts

Walkthrough for Date, time and number format on the Label layouts work in the Microsoft Dynamics 365 SCM

In this blogpost I am going to explain the Date, time, and number format configuration available in the Label layout page and how to make it work.

Go to Warehouse management > Setup > Document routing > Label layout.
You will notice Date, time, and number format field there. This field control how numbers and dates were formatted on the printed label. For example, you can have a requirement that numbers need to be formatted - the decimal dot/comma and the thousands dot/comma/tick and so on. Previously it was not possible, for example, to use US number format with European WMA user (or vice-versa). Now you can have it configurable.

Let's imagine that I have the following label layout for license plate labels. I have both number field -Qty and date field - PrintedDate.

Label layout for license plate labels


^XA

^FX Top section 
^CFA,30
^FO50,100^FDOrder Number: $OrderNum$^FS
^FO50,200^FDLicense plate: $LicensePlateId$^FS
^FO50,300^FDProduct: $ItemId$^FS
^FO50,400^FDPrinted Date: $PrintedDate$^FS
^FO50,500^FDQuantity: $Qty$^FS

^FO50,690^GB700,3,3^FS
^FO50,700^FDFrom Location: $WMSLocationIdFrom$^FS
^FO50,750^FDTo Location: $WMSLocationIdTo$^FS
^FO50,800^GB700,3,3^FS

^XZ

In my scenario, I will be using Chrome emulator to present the results. 

So, if you try to print license plate label using the layout above no matter what you select in the Date, time, and number format, it will not change formatting of the date and number. 

But as soon as you add :d to the Date field, it will make a difference.

^FO50,400^FDPrinted Date: $PrintedDate:d$^FS

I have printed 3 labels and for each label I changed the Date, time, and number format field. Pay attention to the Printed Date on the label and how it changes. 

DA Label

DE Label

JA Label

The same story with the Qty.

As soon as you add :N to the number field, it will make a difference.

^FO50,500^FDQuantity: $Qty:N$^FS

I have printed 2 labels and for each label I changed the Date, time, and number format field. Pay attention to the Quantity on the label and how it changes. 
DE-AT Label

EN-US Label


That's it! I hope it helps.