Skip to Content
avatar image
Former Member

How To Create Item Codes that Identify itself as Imported or Domestic

Mar 01, 2017 at 10:35 AM | 81 Views

Hi There !

We need to Create One Single Series of Items Codes Starting from 1 to Infinity, in a way that looking at the Code itself one can identify if the Item is Imported or Domestic in nature.

Intend to use Prefix or a Suffix to do that. Is this possible ?

No of Items 5000

We need a little guidance on how best to do it.

Regards !

Kshitij

SAP Business One, version for Asia Pacific Japan | SAP Business One, version for EMEA and the Americas | SAP Business One, version for Central & Eastern Europe | SAP Business One | SAP Business One | sapb1 | sbo | item master | item code
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Nagarajan K
    Mar 01, 2017 at 12:29 PM

    Hi,

    Not possible to use single series to create such item.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Balaji Selvaraj
    Mar 01, 2017 at 12:02 PM

    Hi Kshitij Prakash,

    You can use Prefix to filter. Also based on digit you are going to use for the item code can be decided.

    example 10100001 here the first three digit stands for Domestic

    20100001 here the first three digit stands for Imported.

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Mar 01, 2017 at 12:14 PM

      Hi Balaji !

      Thanks for the Prompt response. I too understand what you mentioned.

      However, we wish to maintain Only One Series viz.

      10100001

      20100002

      10100003

      20100004...........

      Is this possible ?

      Regards !

      Kshitij

  • avatar image
    Balaji Selvaraj
    Mar 01, 2017 at 12:36 PM

    Hi Prakash,

    In case of one series you need to go through FMS and the fms will work based on another field value.

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded