Change Sort Field in GL Master - Implications

[Former Member]

Hi,

I would like to know if I want to change the Sort Key in my Reconciliation GL account will there be any imact of this.

If you can let me know what will be the impact will be help full.

Below is the example what I have change.

In my Customer Recon Account there was Sort key for Doc Number and Fiscal Year now I have change to Assignment Field.

Regards,

Kiran.

Edited by: Kiran C on Jan 25, 2011 12:55 AM

[Former Member]

Hi Kiran,

1. The purpose of defining Sort Key is only to use automatic clearing and in most of the cases automatic clearing is not used for customers so no reason to worry.

2. You have changed sort key from Doc Number and Fiscal Year to Assignment which I do not see of no use at all because Assignment should never be a Sort Key because the Sort Key is defined to populate value of field into Assignment field itself.

So, now onwards your sort key will become void since you will have to enter value in assignment field manually.

Precisely, if you are not using automatic clearing for the customer, there are no implications.

Study your business processes.

Regards,

Chintan Joshi

[former_member213733]

Hi ,

Sort key updates the assignment field in the document that is being created for that particular GL account .

So if you have set the assignment as the sort key then the settings for asssignment would be updated in the document posted for the customer reconcilliation account .

Regards ,

Dewang T

[former_member190588]

Hi Kiran,

The sort key in GL /Vendor/Customer Master data enables to post the given field value in the assignment field in

the transcation. The impact of changing this what ever you have posted before will have different assignment value and after the change it will be different.

For Eg. GL account GR/IR account have sort key " 001" earlier and now changed to "014" then the new document line item

will have purchase order as Assignment field.

Hope this helps

pbb