Skip to Content
author's profile photo Former Member
Former Member

Serial Number Generation

Hi All,

I am managing Items by Serial numbers and management method is On releasse only.

Now i have two questions:

1. How do I assign serial numbers to newly produced items automatically?

2. For assigning serial numbers manually how do I come to know the last serial number assigned for a particualr Item?

Regards,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 01, 2007 at 09:04 AM

    Hello,

    Here are the answers for your questions:

    1. when you perform Issue for production and receipt from production, the system will popped up the serial number assignation screen and you must define the serial no. code there. I am not sure that it could be automatic except maybe using addon.

    2. There is serial no. detail under inventory module --> item management submodule

    or serial number transaction reports that is still under the same module. try to use these standard one.

    Rgds,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 01, 2007 at 11:05 AM

    Maybe try this to find out <b>last serial number assigned to a PARTICULAR product</b> - customer uses an "intelligent code" in their serial numbers (coded as Item Number + BP Number + Date) - hint - that is why T0.ItemCode is in there twice.

    SELECT

    T0.ItemCode,

    T0.ItemName,

    T0.SysSerial,

    T0.IntrSerial,

    T0.ItemCode,

    T0.CardCode,

    T0.CreateDate,

    T0.CardName,

    T0.Quantity

    FROM OSRI T0

    WHERE T0.ItemCode = [%0]

    Zal

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.