Search our Help.

  1. Unleashed Support
  2. Get Started
  3. Import Data

Import Serial Numbers field definitions

Follow

Use the Import Serial Numbers template to enable the "Serialized Product" setting and provide serial numbers for products with Stock On Hand (SOH).

The Import Serial Numbers template is only available when the configuration setting "Serialized Products" is enabled. For more details, see Serialized Products.

Import template field name
* denotes mandatory fields. 		Description
*Product Code The unique Product Code for the serialized product.
*Warehouse Code The Warehouse Code where the product currently holds SOH.
*Serial Number

The unique serial number per unit of the specified product. 

Each serial number requires it's own row per product.

Tips for importing Serial Numbers

  • The Import Serial Numbers template should be used to enable serial tracking for existing products that currently have SOH but no open transactions. 
  • The Import Serial Numbers template should not be used to enable serial tracking for existing products that currently have no SOH. Instead, use the Import Products template.
    NOTE: Products allocated to open transactions e.g. Parked Sales Orders and Purchases Orders cannot be updated to serialized products using the Import Products template.
  • The total SOH quantity across all warehouses per product must match the total number of serial numbers provided in the Import Serial Numbers template.
  • New products cannot be created using the Import Serial Numbers template. Use the Import Products and Import Stock on Hand templates to enable and assign serial numbers to new products.
  • The Import Serial Numbers template cannot be used to edit or change the serial numbers currently in stock, see Is it possible to change the current Batch or Serial Number of a product?
  • The Import Serial Numbers template cannot be used to assign serial numbers to transactions, such as Purchase Orders or Sales Orders.

Serial number allowable characters

Serial numbers can be any length between 1 and 50 characters long. In order to support serials encoded in the primary Code 128 barcode format, Unleashed supports any ASC11 character between code 32 and 126 as per the following table:

Code

Character

Code

Character

Code

Character

32

Space

64

@

96

`

33

!

65

A

97

a

34

“

66

B

98

b

35

#

67

C

99

c

36

$

68

D

100

d

37

%

69

E

101

e

38

&

70

F

102

f

39

’

71

G

103

g

40

(

72

H

104

h

41

)

73

I

105

i

42

*

74

J

106

j

43

+

75

K

107

k

44

,

76

L

108

l

45

-

77

M

109

m

46

.

78

N

110

n

47

/

79

O

111

o

48

0

80

P

112

p

49

1

81

Q

113

q

50

2

82

R

114

r

51

3

83

S

115

s

52

4

84

T

116

t

53

5

85

U

117

u

54

6

86

V

118

v

55

7

87

W

119

w

56

8

88

X

120

x

57

9

89

Y

121

y

58

:

90

Z

122

z

59

;

91

[

123

{

60

<

92

\

124

|

61

=

93

]

125

}

62

>

94

^

126

~

63

?

95

_

  
Was this article helpful?
0 out of 1 found this helpful