Account assignment for Material codes

[Former Member]

Hi,

I have a requirement from one of my client.

We need to assign to respective Material codes, the following GL accounts :

Mat. Code	Material	Account Assignment	GL Account
200000	SHEET GI -SCRAP	COGS	710231
200027	MS ANGLE SCRAP	Scrap Income	800080
900303	FIBER GLASS GROOVING&SCRAP MC-E300EG GLS	COGS	710231
900765	GEAR BOX ASSEMBLY (SCRAP) HG-320-B GLS	Scrap Income	800080

Sale of the above scrap material should hit the GL account as mentioned above.

Plz help as to how to start.

[former_member205178]

Hi,

Between -> Manjit, Suman, Krishna and Enayet you got your answers.

I believe there is nothing else anybody can contribute more.

Good luck for your auto postings.

Thanks.

[former_member184881]

hi,

please specifi that material's GL and cost center. if it delivery PGI accouting posting then please use T-code: OBYC and go to Inventory posting- BSDto assign GL under your compny Chart of Accounts and if it is Sales order billing GL posting then use t-code: VKOA go to

1	Cust.Grp/MaterialGrp/AcctKey

thanks

Md. Enayet Hossain

[abumohammad_shoyeb]

GO TO : OBYC - Select Transaction "GBB" and add General Modification "VAX, VAY, VKA" and spcify you required field.

[suman_sardar2]

Hi Prince,

As rightly said by Manjit, you have to maintain the Revenue Account Determination in VKOA to generate the Accounting of a Billing document in your desired G/L account.

But as you mentioned the COGS, so I am confuse that are you trying to setting up the Revenue account at the time of Billing or you also talking about the PGI when Inventory is getting moved.

Your Material Master Account Assignment Grp is responsible for Revenue A/C determination which you have to take care in VKOA.

And for Inventory you have to set up as per your requirement in OBYC, you can consult with your MM guys.

Thanks,

Suman$

[Former Member]

Thanks Suman

Will try that

[Former Member]

Dear Suman

The concept is as :

1. 1.       The cost of ALL material that is being scrapped should go to COST. (710230 - COGS - Scrap Disposal)
2. 2.       The revenue from the scrap material sale should be accounted as :

• Material scrapped in process of production – the revenue on sale should be credited to COGS (710231 - COGS - Scrap Sale)
• For the rest -  the revenue on sale should be credited to COGS (800080 – Scrap Income)

We want to configure the process for respective material as :

Mat. Code	Material	During PGI (COST)		During Billing (REVENUE)
		GL Account	Description	GL Account	Description
200000	SHEET GI -SCRAP	710230	COGS - Scrap Disposal	710231	COGS - Scrap Sale
200022	ALU DUCT BRD SCRAP	710230	COGS - Scrap Disposal	710231	COGS - Scrap Sale
200024	ALUM SHEET-SCRAP	710230	COGS - Scrap Disposal	710231	COGS - Scrap Sale
200025	STAINLESS STEEL SHEET-SCRAP	710230	COGS - Scrap Disposal	710231	COGS - Scrap Sale
200027	MS ANGLE SCRAP	710230	COGS - Scrap Disposal	800080	Scrap Income
200028	WOOD SCRAP	710230	COGS - Scrap Disposal	800080	Scrap Income
200029	SLOTTED U CHAN-SCRAP	710230	COGS - Scrap Disposal	800080	Scrap Income
507615	OLD DX UNIT FOR DISPOSAL -SCRAP	710230	COGS - Scrap Disposal	800080	Scrap Income
507616	OLD COMPRESSOR FOR DISPOSAL-SCRAP	710230	COGS - Scrap Disposal	800080	Scrap Income
507617	COPPER MATERIAL FOR DISPOSAL-SCRAP	710230	COGS - Scrap Disposal	800080	Scrap Income
507618	EMPTY REFRIGERANT CYLINDER DISPOSALSCRAP	710230	COGS - Scrap Disposal	800080	Scrap Income
508691	SCRAP-OTHERS	710230	COGS - Scrap Disposal	800080	Scrap Income
900303	FIBER GLASS GROOVING&SCRAP MC-E300EG GLS	710230	COGS - Scrap Disposal	710231	COGS - Scrap Sale
900751	BLADES / SCRAP CUTTING HG-320-C GLS	710230	COGS - Scrap Disposal	710231	COGS - Scrap Sale
900765	GEAR BOX ASSEMBLY (SCRAP) HG-320-B GLS	710230	COGS - Scrap Disposal	800080	Scrap Income
900793	MOTOR FOR SCRAP DRIVE E-300-AG-B GLS	710230	COGS - Scrap Disposal	800080	Scrap Income

I hope the table above is clear as to which GL accounts need to be hit on PGI and Billing.

Please let me know in case you need any other information on this.

[Former Member]

Hi

Pls maintain account assignment group for material i.e. Sales FG - 01 , Scrap Income - 02 & assign this  account assignment to material master sales view & maintain GL account setting accordingly in VKOA.

Hope this will help you.

Regards

Manjit Dhiman

[Former Member]

HI Manjit,

Let me try your suggestion and will update you if i have any difficulties.