Need to copy BKTXT field value to XREF3 field - for residual documents

[Former Member]

HI

We setup the Lockbox automatch key field as XREF3 , but our standard mapping for invoices from Interfaces is to post the invoice number to BKTXT field .

To have the residual document identified by Lockbox file, now the requirement is to copy the BKTXT field to XREF3 as well .

I am not sure if the substitution works, is there a better way to setup this logic.

Thanks and Regards

[eduardo_hinojosa]

Hi

If you are talking about SD invoices you can do it with enhancements (see Note 301077 - User exits for the interface to accounting).

But the most general option (MM, SD or FI invoices) you can use the BTE 00001120 where you can populate T_BSEGSUB-XREF3.

I hope this helps you

Regards

Eduardo

[former_member184580]

Hi Sravanthi,

Yes. Substitution will work. Substitute XREF3 field with BKTXT.

Thanks & Regards,

Prasad

[Former Member]

Thanks Prasad ..

My requirement is at the document level :

If  Account type "D" and Posting key "06"

        copy BKTXT to XREF3 on all customer line items .

Do you think, a customer user exit is needed as well to specify this logic .

Thank you

[former_member184580]

Hi Sravanthi,

You can try as below.

But it may work only for line item having account type 'D' and posting key '06'. Please activate substitution in transaction OBBH.

If you need to copy all the line items with the same logic, you may need to go for user exit.

Thanks & Regards,

Prasad