Problem with serial number with using DTW

[Former Member]

I tried to Upload my inventory balance with serial numbers using the template oInventoryGenEntry

But i always got this message

"you should use existing serial/batch numbers for this document type error 65171"

[Former Member · Accepted solution]

Thanks Gordon,

But i tried with only one base line (and qty 1), and i still get the same message.

[Former Member · Accepted solution]

Where is your BatchID?

[Former Member · Accepted solution]

It has no value within the column BatchID

Damn...it wasn't working because of that! I tried only with the item managed by serial and I removed the BatchIdColumn and it worked!

Edited by: Mathieu Bourgouin on Oct 21, 2008 7:57 PM

[Former Member]

Thanks Gordon

That's was exactly our problem

[Former Member]

I removed the Card Code and the SystemSerialNumber and now i get this message:

"[IGN1.WhsCode][Line1] BINDB23 cannont be released from stock without a full selection of serial/Batch no,"

[former_member583013]

Hello Roy,

It will be hard to say whats wrong unless we can see the template.

Will you be able to paste it here?

[former_member303406]

On behalf of Yves Roy;

RecordKey DocDate DocDueDate

RecordKey DocDate DocDueDate

1 20081020 20081020

RecordKey LineNum AccountCode ItemCode Price Quantity WarehouseCode

RecordKey LineNum AccountCode ItemCode Price Quantity WarehouseCode

1 0 _SYS00000000017 BINBD23 300 2 01

1 1 _SYS00000000017 231350 101 2 01

1 2 _SYS00000000017 AES400/50G 102 3 01

1 3 _SYS00000000017 AES400P/50G 103 4 01

1 4 _SYS00000000017 AES400FB/25G 104 5 01

1 5 _SYS00000000017 AEB910303 200 2 01

RecordKey BaseLineNumber BatchID InternalSerialNumber

RecordKey BaseLineNumber BatchID InternalSerialNumber

1 0 23542439

1 0 23423328

[Former Member]

At least the BaseLineNumber has to be unique under each record key. Duplication is not allowed.

Thanks,

Gordon

[Former Member]

Thanks Gordon and Suda

I made all the changes: Dates, delete DocNum, add AccountCode

And i still got the same error message

[Former Member]

Remove SystemSerialNumber. It is no need.

CardCode might be problem too.

Try again.

[Former Member]

Header

RecordKey DocEntry CardCode DocCurrency DocDate DocDueDate DocNum

1 14 inno $ 15102008 15102008 4

Line

RecordKey LineNum ItemCode Price Quantity WarehouseCode

1 1 BINBD23 300 1 01

Serial

RecordKey LineNum BaseLineNumber InternalSerialNumber ReceptionDate SystemSerialNumber

1 1 1 865875 15102008 865875

1 1 1 52423432 15102008 52423432

1 1 1 5345345 15102008 5345345

Thanks

[Former Member]

Date format should be YYYYMMDD. DocEntry needs to be empty.

That is first two things to change.

Thanks,

Gordon

[former_member583013]

PLease take a look at this thread there the templates and their relation has been explained

[Former Member]

Please post some of your sample data so that we can tell anything wrong.

Thanks,

Gordon