BP Autocoding

[former_member209725]

Dear Experts,

My clients wants auto coding for bp master for different BP Types..

Like for

Customers 1 to 1000

Vendors 1001 to 2000

Lead 2001 to 3000

is it possible through FMS. can you plz provide me the FMS.

Is creating FMS for autocoding is genuine or problematic?

Regards,

Ravi

[former_member218051]

Hi Ravi,

In 8.82 there is a provision to define the series for business partner as well as item master through document numbering series setup.

So you do not need any FMS.

Thanking you

Malhaar

[K_Pauquet]

Hi Ravi,

since version 8.82 the application facilitates numbering series of master data. You can set up the numbering for BPs (separate series for vendors & customers) & items similar to the way you define numbering series for documents & don't need the workaround with FMS anymore.

8.82 has been available since February 2012.

All the best,

Kerstin

[Former Member]

HI

Try this:

select max(ItemCode)+1 from oitm where itmsgrpcode = $[oitm.itmsgrpcode]

select 'Autorefresh when field changes' for that FMS and choose 'Display Saved Userdefined Values' and then select the field as  'Item group' and update it.

Remember to select the group first,so that FMS will fire.

Make sure you are using only numbers for itemcode i.e 1001,1002 and it wont for characters like 'comn0001'

[former_member186095]

Hi,

In B1 8.82, you can use series-business partner -numbering setup. The setup is available in the module administration --> system init. --> document numbering.

it will be auto coding every time your create new BP. The user do not need to enter the new BP code.

It is automatically created after the BP is added.

I also attached the txt file contains query FMS of autocode if you don't use B1 8.82. I strong recommend to upgrade to B1 8.82 so that many new features in the version can be help you to use B1 effectively and efficiently.

JimM

query FMS auto code.txt.zip