Usage of sort key in FS00

[Former Member]

Hi,

Can the Sort key (31 - Customer Number) be used in GL account type, for getting the assignment field in the Line item to be populated with customer number.

I tried it but did not work.

Can any one tell how to (standard way) populate the custmer number in the line item of GL account (account type S)?

Regards

Seshadri

[former_member182098]

FBL3N -> Execute

Settings ==> Special Fields

Table BSEG

Field KUNNR

Create Transport Request & Transport.

Get this in your layout of FBL3N

Regards,

Ravi

[Former Member]

Hi Ravi,

I just tried your solution, but the "customer" column is all empty. Can you give me some suggestion on that? Do I need to change sort key to "customer" in this case? I already changed, but looks like it is not working.

Thanks in advance,

DL

[Former Member]

Hi DL

To populate the customer field in (offsetting) GL accounts

You would need to implement a BTE

Check the following OSS Notes

Note 112312 - Line item: Display of offsetting a/c information

Note 1034354 - FAGLL03: Display of offsetting account information

Regards

Sach!n

Edited by: Sachin Bhutani on Mar 24, 2010 2:42 AM

[Former Member]

Thanks! Sachin

[Former Member]

Hi Seshadri,

Sort key in the GL master will guides the system to display line items of the business partners or GL account in a specific sort order in reports FBL1N, FBL3N and FBL5N.

If you want the system to populate the assignment field in the customer line item report, go to Tcode FBL5N and select menu item settings-> special filelds

Press new entries and add the entry for table BSID - ZUONR and BSAD - ZUONR

This might solves your requirement.

Post again for more details.

Thanks,

Srinu

[Former Member]

Hello,

Your question is not very clear but the function of sort key is to give addtional data to the document by automatically filling up the assignment filled and depending upon the sort key defined into paritcular GL it will reflect in assignment filled.

Example :

you went into a FS00 say GL cash-100000

and you have assigned sort key 31(Customer nbr)into GL cash 100000.

So when you will post any doc may be a customer invoice the assignment filled will be automatically updated with customer number and will reflect in your document.