G/L account determination- include 'Material Type' From Materail Master

[RPANREDDY]

GL Key Component ID : For one of our Key requirements, to allocate GL code to Order Lines is like blow

Required Lookup Key combination is = Order Type + Ship-to location + Material type

ex : ( Normal Order + 349999 + Finished Good ( From Material Master ) based on this key combination assign GL code = 45900000
Tentative approach to build the Key Component >>

Step 1) General Ledger Key Component Order -

a)Order_Base_refnum (Order Type) ----------------------------Key Component Type
b)Location or Order_involved_party_location( Shinto Location )-------------Key Component Type
c)?? Material Type- Out-of box configuration has only one option to map related Item that is PACKAGED_ITEM and this element doesn’t takes parameters. My question is how I can build the GL Lookup Key for this Material Type so that I can add this to GL key Component.

2) Once the General Ledger Key Component Order is created for above there elements, I want to map these TO
General Ledger Lookup Key Order

3) Assign above created General Ledger Key Component Order to General Ledger key:

To implement this, right now I’m not sure how to proceed with Material Type (- General Ledger Key Component Order ) configuration.
Any kind of direction towards configuring the key to determine G/L account with above combination is greatly appreciated.

If you need additional information please let me know

[james_foran]

Re: G/L account determination- include 'Material Type' From Materail Master

Hello,

From your question, it looks like you may have the order incorrect.

1) First, you must create a Key Component.

2) From here, you then create a GL Lookup Key, which is made up of one or more key components.

3) Each General Ledger Code is then linked to a Key. From here, you then enter the parameters which must be met for that general ledger code to be applied. You can leave a Key Component blank and it will still assign.

Let me know if this helps. If you have any further questions, please dont hesitate to contact me.

Thanks and regards,

James Foran
Toll

[RPANREDDY]

Re: G/L account determination- include 'Material Type' From Materail Master


Thank you James,
I agree with you , but sill I'm waiting to get the answer for my issue , my question is how I can create a Key Component - for Material type this value is part of Item Master , as i mentioned earlier - For Item there is only one key Component is available- PACKAGED_ITEM ( Default ) and this element doesn’t takes no parameters.
Kye Parameters to determine the GL code is
Order Type + Ship-to location + Material type
So that I can assign these to GL Lookup Key >> this to General Ledger Code.

If I'm not clear with the question or you need more Inforamtion please let me know , thank you for your time

Thank you
Raghu

[james_foran]

Re: G/L account determination- include 'Material Type' From Materail Master

OK.... I think I see your problem now. I am not that familiar with the use of Items.

I have handled similar issues on Shipments by using the INVOLVED_PARTY. you could do the following:

1) Create an Involved Party Qualifier called MATERIAL_TYPE.

2) Create Contact for each MATERIAL_TYPE.

3) Creat an Agent to popuate the MATERIAL_TYPE, copying this from... Not too sure. Just make sure there is only one...

4) Create you KEY_COMPONENT for ORDER_INVOLVED_PARTY with a parameter of MATERIAL_TYPE. You can even call it MATERIAL_TYPE.

The rest should be fairly easy. Let me know how you go.

[RPANREDDY]

Re: G/L account determination- include 'Material Type' From Materail Master

James,
I appreciate you thoughts, but still this also won't work I think, because the Material type is at line Level and in an Order each line may have different Material Type - if I update this at Header then, it is difficult to map to Line level. Sill I try to think on your lines and If i find any solution I will let you know , meanwhile if you think of any other possible options , please let me know.

[james_foran]

Re: G/L account determination- include 'Material Type' From Materail Master

Ok. well, you need to review the Functional and Business requirements then.

Perhaps there should be an option set at MATERIAL_TYPE of MULTI for orders which have mutliple types. Otherwise you might need a hierarchical system to select a single MATERIAL_TYPE.

Regards,

James
Toll