on 10-11-2007 2:30 PM
Hi,
We want to have the document reference to be equal to the document's number.
I made a new substitution rule via OBBH which replaces BKPF-XBLNR by BKPF-BELNR but unfortunately it doesn't work. Probably because the document number is only known after saving the document.
Someone any clue to get this replacing done?
Hi Johan,
Subsitution might not work correctly, as stated above create a zprogram to replace reference number with doc number using 1- sys-date (previous date) via tcode FB02. ensure that this is run first hour next date.
Hope this helps
pls assign points as way to say thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
why not have the SD document number the same as the Finance document?
This is easily done, you need to make doc type RV externally calculated.
The only reason why you cant you this is if you use invoice lists, which create more than one a/c per invoice or payment terms with two payment dates.
It wont affect what the business sees, and for statements and so on use the BELNR field.
hi Johan,.
I am afraid, you can do it only afterwards: as you realised, the number you have only, after you saved the document.
I have no idea, why this makes any sense, storing an information <i>twice</i> (in the same table!)... However if you really need this feature, you should write a program, which runs as a job each night at 1:00 (for example) and changes each document posted on the previous day (CALL TRANSACTION FB02 for example).
hope this helps
ec
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.