G/L account determination through material account assignment group

[Former Member]

Hi ,

I would really appreciate any help on this . The scenario is .

We changed the account assignment group of maetrial to 01 just 2 days back.

We have old open sales order line up for this particular material . When I am trying to Bill these open orders , the system is not recognizing the account assignment grp change which happened 2 days back ,because of which I am getting a A/C determination error .

This is a I/C order and we have PO linked to it. I am suggesting to back out everything (Do Invoice reversal,MIGO cancellation,PO cancellation , then cancel invoice ,delivery and sales order ) so that we can create a new cycle and the system will recognize the account assignment grp change and determines the G/L whwn it comes to acounting .

1. Is this the right way

2. Is there any other way by which I can make the accounting happen

It was very obvoius that when I see the account determination analysis ,the system wasn't able to find the account assignment grp for the material .

Thanks

Sridhar

[Lakshmipathi]

Dear Sridhar

First of all, I dont think, you will be able to change the Account Assignment Group of a material in sale order if any subsequent document is generated bcoz the said field will become uneditable. Moreover, via MASS, this is not possible as the field name of Account Assignment Group for material (KTGRM) is not available in MASS.

So the other option is via MASS, you can assign Reason for Rejection for existing orders. To assign Reason for Rejection in bulk is run T.Code MASS, input [BUS2032] as Object Type and execute. There block he Sales Order Item Data and click on Fields and block the field MASSVBAP-ABGRU and execute. Input the sale orders if possible otherwise leave it blank and once again execute. Now you can assign Reason for Rejection in mass.

Meanwhile, you have to create new orders for all those open items.

thanks

G. Lakshmipathi

[Former Member]

why dont u try like this by doing mass update of account assignment grp of the material in the order using the T CODE MASS.

mass-object type:bus2032------sales order header data.......give the sales document numbers like xxxx to xxxxx.....click on the icon "select fields" and select account assigment grp..... enter the new value that has to be updated in the field "new value" and select the respective things and carry out the mass change.

reward if it helps

Edited by: kiran alahari on Aug 21, 2008 12:45 PM

[Former Member]

Hi kiran,

MASS lists only for customer account assignment grp and not material account assignment group. Is there any other way.

Thanks

Sridhar

[Former Member]

It is possbile

u can try like this

mass-object type: BUS1001------instead of selecting tables u select fields in that u select fieldMVKE-KTGRM material account assignment group.......give the MATERIAL ,SALESORG ,AND DISTRIBUTION CHANNEL like xxxx to xxxxx.....click on the icon "select fields" and value that has to be updated in the field "new value" and carry out mass change.

REWARD IF IT HELPS

Edited by: kiran alahari on Aug 21, 2008 3:47 PM

Edited by: kiran alahari on Aug 21, 2008 3:48 PM

[Former Member]

Hi Kiran,

Account assignment grp for materials is found at the sales order item level . When I tried to look in the fields tab I don't find the option (VBAP-KTGRM) to select .

I am not sure whether this field is not allowed for MASS change .

Please let me know if there is any other way for doing a MASS chnage for this field.

Thanks

Sridhar

[Former Member]

The field is notVBAP-KTGRM it is MVKE-KTGRM material account assignment group

it should work

Reward if it helps