Skip to Content
avatar image
Former Member

Problem with serial number with using DTW

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"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2008 at 05:28 PM

    Thanks Gordon,

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Oct 17, 2008 at 06:27 PM

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

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 06:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 07:31 PM

    Thanks Gordon and Suda

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

    And i still got the same error message

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 08:08 PM

    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,"

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 06:44 PM

    Thanks Gordon

    That's was exactly our problem

    Add comment
    10|10000 characters needed characters exceeded