Basic parameters to define the grouping for the Items and the BPs in SAPB1

[Former Member]

Dear Friends,

What should be the basic parameters to define the grouping for the Items and the Business partners in SAP B1?

What will be the case when the client wants to classify the sales revenues various categories?

[Former Member]

Hi Das,

You want show the item Group wise Revenue

1.Create Item Groups & Linked with the item groups with the respective Itemcode in Item Master Data.

2.Set G/L Account by -> Item Group.

3.Go to Administratin->SetUp->Inventory->ItemGroup, in accounting Tab define the GL account

respective to Each Item Group.

4.Revenue account are mapped with different account based on Item Group in Accounting Tab

*Close the thread if issue solved.

Regards

Jambulingam.P

[Former Member]

Hi

What should be the basic parameters to define the grouping for the Items and the Business partners in SAP B1?

For items:

Raw Material.

Capital Goods

Finished Item

Semi Finished Item.

Conusmables

Stationary .........etc

or .

Metal.

Rubber

Wooden.....etc

Bsuiness Partner

Foreign or domestic.

Region wise e.g South,North,East,West.

State wise e.g MH,KT,DELHI,GOA....ETC

What will be the case when the client wants to classify the sales revenues various categories?

SIMILARLY

Foreign Revenue, Doomestic Revenue, Region Wise Revenue, State wise, Or Territory wise.......etc

I hope this clarifies you

Ashish Gupte

[Former Member]

Dear Ashish,

Foreign Revenue, Doomestic Revenue, Region Wise Revenue, State wise, Or Territory wise .... are these G/L accounts... if yes then how to do the account determination?

if these are item groups then what should be the G/L account behind it and the account determination?

[Former Member]

Hi

Create Control Accounts in the Chart of Account. And put that control Accounts in the BP Master >> Accounting TAB.

Say eg.

If the customer is from Foreign

Put your Foriegn Account in that BP master.

Ashish Gupte

[Former Member]

Ok Ashish, but I am asking for the Inventory Items...

Edited by: Narottam Das on Jul 10, 2009 5:07 PM

[Former Member]

Hi

R u going to map foriegn items and domestic items ?

I fyou are going to map your revenues with the Item wise then it is very difficult coz the ledger are always going to increase

So it beneficail for all that only revenues in terms of BP should be tracked.

Ashish Gupte