Need Different GL for COGS and Revenue of same Material

[Former Member]

Hello All,

I have 2 materials wall and Roof. I have created GL entries for both the materials.

Wall  5011001 (Cost of Goods Sold-Delivery time)

Roof  5011002 (Cost of Goods Sold)

Wall  4011001 (Revenue-Billing time)

Roof  4011002 (Revenue-Billing Time)

Now the issue is when i am doing COGS of material WALL i am getting account entry 5011001 but once i do billing i am getting same GL account 5011001 although 4011001 should hit at the time of billing. Reason behind doing this is my client provided me GL list in which they have showed different GL accounts for COGS and Revenue my hit of Same Material.

Regards

[former_member182378]

Hi,

Could you please explain how is COGS being posted?

Is this during the delivery process? And is basic function - account determination being used?

For posting revenue to a GL account, you could follow standard Account determination functionality i.e. condition table with Account assignment group CMR, account ass group MMR, account key (from pricing procedure)...and then in condition record give the GL account.