Sort key required in Vendor Master & MIRO

[former_member3117]

Hi Guru,

I have assign sort key 014 PO number+ PO item in vendor master and and config using T-code OB16 , but when doing MIRO and save it is not showing in assignment field. It should be automatically assign.It is catching 00000

I have use following Field.

014  sortkey   : Field - EBELN - Purchasing doc. no     Length:10

                          Field- EBELP - Item                              Length:5

Can any one help me for this.

[JL23 · Accepted solution]

Have a look into OSS Note 322910 - RSZUN000 (ZUORDNUNG_AUFBAUEN) ZUONR, HZUON incorrect

this note is a bug fix for a wrong delivered program, and has as well a report attached to fix wrong numbers.

[former_member3117 · Accepted solution]

Thanks for your corrective response.

Regards,

Piyush Patel

[Former Member]

Hi Piyush,

Let's take a simple example for why sort keys are helpful.

Suppose, there is GR/IR account created with sort key 014 (Purchase Order) so at the time of

1. Goods receipt Purchase order with item no will automatically filled in assignment field.

Inventory dr. 15000

GR/IR cr 15000.

In GR/IR account item Assignment would be 150000 10.

2. Invoice through MIRO will also feed Purchase Order with item no in assignment field.

GR/IR dr . 15000

Tax dr. 5000

Vendot cr. 20000

In GR/IR account item Assignment would be 150000 10.

Now your entry is over. There are large number of such entries posted in the period for the GR/IR account.

Generally sort key allows you to configure what to populate in assignment field for FI documents. ( Refer assignment field in reports FBL3N , FBL1N, FBL5N) , you can enter sorting key in Vendor and customer accounting data , and control data of GL account.  Assignment field is generally used to run automatic clearing of open items you can configure it here SPRO -->Financial Accounting -->  General Ledger Accounting -->G/L Accounts--> Line Items  -->Display Line Items  -->Determine Standard Sorting for Line Items

Regards

Sanjeet Kumar

[former_member3117]

This message was moderated.