on 04-18-2013 6:10 AM
Hi All,
I have a requirement where my customer wants to manually punch external invoice number at the time of billing.
I am aware of the fact that external invoice number is not possible in sap standard. Please suggest the best possible solution for the same.
Regards,
HB
Hi Himanshu,
Please ask you abaper you to write a code to populate the external number range in
the below program
RV60AFZC
USEREXIT_NUMBER_RANGE_INV_DATE .
If this user exit active USEREXIT_NUMBER_RANGE is not processed anymore,
Thanks,
Siva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Himanshu,
Have you tried to search a solution for this problem before creating a new thread?
Please search in Google / SCN & you will fine many suggestion along with ABAP code to be inserted in User Exit - E.g. - http://scn.sap.com/thread/1456896
Thanks,
Jignesh Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jignesh,
The link which you have provided has a piece of code by Pablo Nunez Mauricio Urrea.which in fact does not address the requirement of external number range while creating billing documents.
From my understanding, the logic (code) helps "extract" billing document number from different internal number ranges, for different criteria.
Please go through the code and comment on if that code address the OP's business requirement.
This is an example:
data: l_c_NUMKI type TVFK-NUMKI.
CLEAR l_c_NUMKI.
- Se lee el rango de numeros para este tipo de factura
select single INTERV into l_c_NUMKI from ZTSD0014 where VKORG eq vbrk-VKORG and VBTYP eq vbrk-VBTYP aND FKART eq vbrk-FKART. IF SY-SUBRC NE 0.
- Si no lo encontro lo busca con FKART igual a vacio
select single INTERV into l_c_NUMKI from ZTSD0014 where VKORG eq vbrk-VKORG and VBTYP eq vbrk-VBTYP aND FKART eq ''. ENDIF.
- Si encontro el intervalo lo asigna al campo US_RANGE_INTERN
IF l_c_NUMKI IS NOT INITIAL.
MOVE l_c_NUMKI TO US_RANGE_INTERN.
ENDIF.
you need to create a table Z with the following structure, for example:
- Sales Organization.
- SD document categ (Invoice or Intercompany invoice or, Credit memo, Debit memo Etc)
- Billing type
- Range (SNRO or you go to spro Sales and Distribution - Billing - Billing Documents - Define Number Range For Billing
Documents, you need to create the intervals that you want)
example table structure:
Sales Org SD document categ. Billing type Range
1110 5 ZNVC IK
1110 M ZNFC IK
1110 M ZSGR IK
1110 O ZCNC I0
1110 O ZSDV I1
1110 O ZSNC I1
1110 P ZSND I7
1120 5 ZNVC IL
Mauricio Urrea.
Message was edited by: T W
Hi Himanshu Banga,
May I know the reason or what is the business process/country in which business need external number for invoice. Is this legal requirement?
Regards
Arun
Moderator Message: Don't post you replies in all BOLD fonts.
Message was edited by: Jyoti Prakash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.