Assignment number is FBL5N

[Former Member]

Dear Friends,

I created a new sort key (040) under OB16 - as excise invoice number (XREF3) - and inserted this new sort key in the customer master.

now all the txns that take place, the line items should be sorted based on the excise invoice number.i.e. the excise invoice no. should reflect in the assignment column of FBL5N.

But it is not happening.

what have i not done in order to have the excise invoice no. reflect in the assignment column of FBL5N?

Thanks for your responses

Sanjay

[eduardo_hinojosa]

Hi,

Perhaps you need enhance FBL5N. Check these notes:

SAP Note 373268 - Line item: new display field

SAP Note 215798 - FBL*N: Special fields are not displayed

SAP Note 208807 - Line items: Append fields for RFPOSX are missing

and related notes

Regards

Eduardo

[Former Member]

Hi Sanjay,

Please check if the 'Ref key 3' of the customer document contains any value. The reason I ask is because, if sort key 40 has been configured as XREF3; the field status for 'Reconciliation account' and 'posting key' has been modified to allow input of excise invoice number and customer master has been updated with sort key '040', I do not see any reason why assignment field should not get the values from XREF3.

Regards,

Ashish

[Former Member]

Thank you all for your replies.

yes the XREF3 field has a vlaue - the excise inv.no. 37

I will work on Susheel's suggestion and revert.

Also i have another case with regards same topic - in FD03 - the sort key is 011 - plant no. and the recon GL master has sort key - 031 - customer no. but what appears in assignment field is the commercial invoice no. - how come this happens?

Thanks

Sanjay

[dominic_holdstock]

Hi,

The sort key is used to fill the field assignment , if no other entry is made.

Check the Invoice, in this the field assignment will be filled and hence will be used instead of the sort key.

Kind regards

[Former Member]

Sanjay,

The next thing I would do is to check if there are any user exits or validation / substitution in place for Assignment field.

Regards,

Ashish

[Former Member]

Dear Dominic,

thanks your response, but i do not see anywhere the assignment field in VF02.

when i double click on the accounting documents - i do see the assignment number being populated with the comm inv.no. but where does that come from? when our sort key is different - it should show either the excise inv.no. which is sort key for FK02 or the customer number which is sort key for the recon GL acct

Can you kindly assist

Thanks

Sanjay

[praveen_jagadeesan]

Dear Sanjay,

Check T.Code VTFA or VTFL - copy control functionality, which triggers the assignment field from Sales order. Take the help of SD consultant and check whether they have assigned any Values to the assignment field.

Thanks and regards

Praveen.J

[dominic_holdstock]

Hi,

IN VF03 go to the header , tab header , in the accounting data area you will see assignment. If filled this is being transfered to FI > Check Copy Control in SD as suggested above.

If it is blank, then a User exit / Substitution is responsible.

Kind regards

[ajaycwa1981]

Hi Sanjay

I doubt if this will happen with in standard SAP..

Sales invoice is created 1st which hits the customer account and then excise invoice is created with ref to the SD Invoice...

So, by the time excise invoice is created, customer account is already accounted for...

In my opinion, you need to create a program (BAPI or a BDC which calls Fb02 in the back ground) which runs at day end and updates the XREF3 as you wish

Regards

Ajay M

[Former Member]

hi sanjay

make sure you have assigned the sort key to the customer recon account in GL master.

regards