Division wise item

[Former Member]

Dear Experts,

My client is having divisions and they have a seperate product list for each Division as well as a seperate customer list for each division. In accounts, segmentation is used based on divivsions and seperate number series are defined for each division. They want the same user to be doing billing for each division. So is there any way by which I can make the user specify for which division he is billing and, filter the customer list and product list that will be available for selection in the bill based on this input??

I'm using SAP B1 2007B. Please Advise.....

Thanks & Regards

Jaics

[Former Member · Accepted solution]

Hi Jacis,

You should define following UDFs

Division in user master.

Division in BP master

Division in Ware House master

You have to also define a ware house for each division and set G/L account by Ware House in Item master-this will resolve your segmentation accoungting issue.

In Item master you need to define respeactive ware house against each item.

Now as you have identification of division with all of following objects, You can use FMS and get the desired results.

1.All User are assigned a division

2.All Items are assigned a division

3.All ware house are assigned a division

4.All customers are assigned a division

Hope above is of help to you.

Best Regards,

Samir Gandhi

[Former Member · Accepted solution]

Hi Samir,

Thanks for the reply. Your solution seems to workout.

Let me check the details and report requirements...

Thanks & Regards

Jaics

[Former Member]

Hi Jaics,

If you need user level authorization, then only SDK or add-on could help you. If you just need reminder to the user, you may use property fields or UDF.

Thanks,

Gordon