How are GL Accounts assigned with item categories in Sales Order

[Former Member]

Please advise;

- how and where GL accounts are assigned with item categories appearing in the sales order?

Points confirmed.

regardss

[Former Member]

Revenue GLs ar attached via VKOA. for the PGI related GL it are attached via the scheduled lines in the sales order. Scheduled lines have the movement type attached to them. u can check the settings in OMWB and OMWN.

Revenue GLs are attached to the condition types via account keys like ERB etc.

[Former Member]

Whats PGI related GL?

By Condition Types , you mean pricing conditions?

Can you provide some sample data/documents to work/view?

[Former Member]

Yes.. Pricing conditions....in pricing conditions we have the account keys....which are attached to the GL via VKOA.... even if u dont have account key it will post from the combination of sales org and COA.

when we do PGI accounting doc gets generated.... it is MM related... COGS to Inventory Stock ..... depending on the movement type used...

[Former Member]

So PGI means, Post Goods Issue

[Former Member]

Yes.. it is Post goods issue.... do u require further help....

[Former Member]

Yes. I need further help.

thanks

[Former Member]

Where and How do we check/find, if account keys are defined or not?

[Former Member]

the account keys are attached in the pricing procedure.... it is done by the SD people.... for us we can see the link between GL and account keys in VKOA.

[Former Member]

all SD-FI related config u can find thro this path:

SPRO-SD-basic functions- account assg/costing

[Former Member]

so, if the item category is like "Software" and in the pricing conditions is assigned to "Hardware" through account keys, it will get posted to incorrect GL account.

[Former Member]

the pricing procedure comes from the combination of sales area , sales doc type, pricing type attached and the customer pricing attached in the customer master.....

item categories are also attached to the sales doc type. we cannot use any item category without assigning it to sales doc type... with this combination we always get the correct pricing procure....

if we attach the software item category to pricing procure of hardware then system will pickup the wrong pricing... and wrong GLs will be updated..... and normally we dont segment revenue based on software and hardware at the GL level... SAP has lot of options for reporting on these features....

[Former Member]

We have number of sales document types and item categories. The sales order numbers are also different for hardware and software categories, so is the sales organization, plant and company code.

Usually, the hardware orders contain line items for software but the item category used is for hardware and therefore, it gets posted to the incorrect (hardware) GL account. Is this happening due to MATERIAL TYPE/CODES.

We are using separate GL accounts for both.

Where and what controls could be developed to prevent this?

Please let me know if you need further information.

[Former Member]

Nimit, Plz advise.

[Former Member]

The item categories which are used for the hardware should not be attached to the sales doc type of software then... u have this relationship in Item category assignment.... check if sofware item category is defined for the hardware doc type... u can see this in SD- sales-sales docitemassign

[Former Member]

Isn't the material type / code is creating this error?

[Former Member]

it is the item category grp which is also attached in that relationship... but as u said that u have diff sales doc type for diff companies then there wont e a problem of restricting your item categories.

i think a SD person there would be able to show u all the settings...

[Former Member]

Do you have any document(s) with reference to such relationship?

Thanks for your help. I truly appreciate.

I am new to these consifgurations. Am a SAP user on SD/FI for 4 years but just passed the certification test last month.

Could you guide me how should one develop its skills in this?

[Former Member]

as a FICO consultant we never come across so many features... i never tried to learn all this.. but as part of implementation projects we get to learn them.... if you have a sandbox system just try to play all around it...

i dont have any doc on this SD thing.... i am a pure FI guy... just try to play around Sandbox.. that will help immensely....

[Former Member]

Any project implementation that you could share to get an overview?

I guess, Our company wont give us access to SandBox. Any other alternate available to wor on practically?

[Former Member]

VKOA.