External Invoice Number Ranges

[Former Member]

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

[Former Member]

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.

[jignesh_mehta3]

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

[former_member182378]

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

[Former Member]

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

[Former Member]

Hi Arun,

This is very much a legal requirement. And as I said earlier its not plant or country dependent requirement.

Please share the solution.

Regards,

Himanshu

[former_member186385]

Hi,

User Exit

USEREXIT_NUMBER_RANGE  can be used for external number range of Billing documents

regards,

santosh

[former_member184080]

Hi Himanshu,

May I know for which Industry and country you are imlementing SAP ? I have seen external number range asking for Excise Invoice level, but, at Invoice level is new to me.

Anyway, Santosh has already provided you the exit.

Regards, Sai Krishna.