Goods Issue DTW Template

[Former Member]

"with system serial 0 is not in stock."

I get this error on my item code if I will upload using oInventoryGenExit.

eg. CEL 01350 has 1 stocks in Warehouse XXX with Serial yyyy

Doc:

RecordKey DocEntry DocDate DocDueDate DocTotal Comments

RecordKey DocEntry DocDate DocDueDate DocTotal Comments

1 20101127 20101127 aw ah

DocLines:

RecordKey LineNum AccountCode Barcode ItemCode ItemDescription Price UnitPrice Quantity LineTotal WarehouseCode

RecordKey LineNum AccountCode Barcode ItemCode ItemDescription Price UnitPrice Quantity LineTotal WarehouseCode

1 0 _SYS00000000059 CEL 01350 XXX 1 XXX

Serial:

RecordKey LineNum BaseLineNumber InternalSerialNumber

RecordKey LineNum BaseLineNumber InternalSerialNumber

1 0 0 yyyy

Why is the error like that?

Thanks

[Former Member · Accepted solution]

Check this thread:

Thanks,

Gordon

[Former Member · Accepted solution]

He said

I filled system serial number which was blank in my sheet.

But I don't know what to fill on this field, I filled it with IntrSerial too but an error occured.

You shold use existing serial/batch numbers for this document type.

Application-defined or object-defined error

Thanks

[Former Member · Accepted solution]

You can run query to find out the system serial number.

Try:

SELECT T0.ItemCode, T0.IntrSerial, T0.SysSerial

FROM OSRI T0

WHERE T0.IntrSerial LIKE '[%0\]%'

[Former Member · Accepted solution]

Please check

RecordKey DocEntry Comments DocDate DocDueDate

RecordKey DocEntry Comments DocDate DocDueDate

1 Sample Issue 20101127 20101127

RecordKey LineNum AccountCode ItemCode ItemDescription Price UnitPrice WarehouseCode

RecordKey LineNum AccountCode ItemCode ItemDescription Price UnitPrice WarehouseCode

1 0 _SYS00000000059 CEL 01350 Testing 23530 23530 ROG

RecordKey LineNum BaseLineNumber InternalSerialNumber SystemSerialNumber

RecordKey LineNum BaseLineNumber InternalSerialNumber SystemSerialNumber

1 0 1 352480040898163 2

I've got this error

You should use existing serial/batch numbers for this document type

How can I check the Serial if it is available? Just to counter check.

Thanks

[Former Member · Accepted solution]

Availability check:

SELECT T0.ItemCode, T0.IntrSerial, T0.SysSerial

FROM OSRI T0

WHERE T0.IntrSerial LIKE '[%0\]%' AND T0.Status = '0'

[Former Member · Accepted solution]

Yes, it is available...

Because I can find it

[Former Member · Accepted solution]

It has to be available to the warehouse too.

[Former Member · Accepted solution]

Kindly check

# Item No. Serial Number System Number Warehouse Code Status

1 CEL 01350 352480040898163 2 ROG 0

I use this command

SELECT T0.[ItemCode], T0.[IntrSerial], T0.[SysSerial], T0.[WhsCode], T0.Status FROM OSRI T0 WHERE T0.IntrSerial = '[%0]'

Thanks...

[Former Member · Accepted solution]

The Syntax is correct.

It is just, their is a problem on the system...

I just isolate itemcodes that has problem and manual make Goods Issue...

Thanks