Information

Title	Negative Numbers Not Allowed

Summary	Error 10027 received when attempting to process inventory adjustment on a newly created part number

URL Name	Negative-Numbers-Not-Allowed

Resolution

Update the prtmst.rcvuom to correct UOM that part should be received.

For example:

[update prtmst set rcvuom = 'CS' where prtnum = '59322']

NOTE: Perform all updates in a Test or Development instance before making them in Production to confirm expected results are achieved

Products	Warehouse Management

Module

Version	2008.2 and above

Error Message Code

6660 T-SRV 11:12:53:774 [5] Executed command (VARint/create inventory)
6660 T-SRV 11:12:53:774 [5]
6660 T-SRV 11:12:53:774 [5] *** RAISING ERROR 10027
6660 T-SRV 11:12:53:774 [5]
6660 T-SRV 11:12:53:774 [5] Negative numbers not allowed.

Cause

When new prtnum is created prtmst.rcvuom must be set otherwise untqty is set to zero and the system is unable to create new inventory as illustrated in example below:

6660 T-SQL 11:12:53:743 XLATE: select prefix, prelen, prlflg, seqlen, LTRIM( CONVERT( VARCHAR,lstseq)) lstseq, suffix, suflen, btsflg, seqflg, LTRIM( CONVERT( VARCHAR,lstseq+:i0)) seqval from sysctl where numcod = :q1
6660 T-SQL 11:12:53:743 Found passed-in bind list
6660 T-SQL 11:12:53:743 Executing statement with bound parameters
6660 T-SQL 11:12:53:759 Query completed
6660 T-SQL 11:12:53:759 Query returned 1 row(s)
6660 T-SQL 11:12:53:774 *** SQL Status: 0
6660 T-SQL 11:12:53:774 ==> T_PERF = 0.031
6660 T-SQL 11:12:53:774 Generating Sequence for [dtlnum]
6660 T-SQL 11:12:53:774 ==> T_PERF = 0.000

Additional Information

Publication Status	Published

Negative Numbers Not Allowed

Information