Skip to Content
avatar image
Former Member

How to get the invoice number on delivery document

i need your advise on the topics below it would be nice if you guide me to the right direction for implementing the system in Peru.

as in Peru they are required to follow the rules as their legal requirement for deliveries and invoicing

1) for every point of sale we have different number range given by government on a pre-printed form for delivery and invoicing,like we have four point of       sales so that mean we have four different series numbers for deliveries and four for invoicing.

2) its government requirement to have delivery number on invoice.

3) we can have maximum of 22 line item or at the maximum 22 serial numbers on one delivery,more than that need to create a new delivery.

4) we can have maximum 15 line items on one invoice and 220 serial numbers on one invoice more than that we need to create a new invoice.

serial number of items on deliveries and invoicing are the serial number of the product and they are required to print them on the deliveries and invoicing,like if we have order for 22 items of same kind we need to print them with all the serial numbers on deliveries.

please throw some light on this.

i do not find any direction.searched online but do not get enough documentation.the only document everybody is referring to is by Mr. Biswas that's a good document but it do not cover the topic in full,so if someone has worked on any requirement like this please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Jul 16, 2013 at 06:03 PM

    Hi,

    Go to VBRP table

    Select -VBELN-Billing Doc number

               VGTYP-Preceding Document Category-J

               MATNR-Material

    get

           AUBEL-Sales document

          VGBEL-Reference Document(Delivery)

          VGPOS-Reference Item

    Regards,

    Krishna.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2013 at 05:47 AM

    Hi Sam,

    Requirement 1:- Different number range given by government on a pre-printed form for delivery and invoicing which should be on basis of POS.

    Solution:-

         i. Treat POS as plant or Sales office as per your business requirement.

         ii) create four  range key for both delivery document and billing document as per given by goverement.

        iii) create two Ztable  one for Delivery and another for billing where make combination of Company Code or Sales Org + Sales Off or Plant +    Delivery/ Billing Document Type = Number Range Key

       iv) Call this Ztable in number range exit in Delivery and Billing (program Name -RV60AF, ZZUSEREXIT_NUMBER_RANGE)

     

    Requirement 2:-   Invoice number on delivery

    Solution:- for this in your delivery output give logic as given by Mr. Krishna for Smartform program along with create routine that if customer invoice is not created then this output type will not trigger and assign against output type in output procedure.

    Requirement 3:- Maximum of 22 line item or at the maximum 22 serial numbers on one delivery,more than that need to create a new delivery

    Solution:-

    Create Combination requirmt put your logic in it and assign in compy control from order to delivery.

    Requirement 4:- Maximum 15 line items on one invoice and 220 serial numbers on one invoice more than that we need to create a new invoice

    Solution:-

    Same as requirement 3 create routine for spliting criteria and assign in Data VBRK/VBRP field of copy control from delivery to billing.

    Regards

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 16, 2013 at 04:42 PM

    Hi Sam,

    2) its government requirement to have delivery number on invoice.

    What I understand from your post that you want to track the Delivery no from the Invoice no.

    If this is the requirement please get your data from VBFA table where put the Invoice no (VBRK-VBELN)

    in the VBFA-Followon doc no and fetch the preceding doc no where preceding doc category = J (Delivery).

    If the requirement is something else do let me know.

    Thanks,

    Suman$

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 16, 2013 at 06:26 PM

    sam,

    What is / are your requirements?

    One point which is unclear -

    2) its government requirement to have delivery number on invoice.

    Do you want the delivery number to mentioned in the billing document (in VF03)?

    Or you want invoice number to be "put" in to the delivery (in VL03N)?

    Members are giving the logic of how to go from a billing document to a delivery document etc.But do you want a delivery / billing number to be included / inputted in a document? or to get the reference number on a print out? or....

    Add comment
    10|10000 characters needed characters exceeded

    • To answer the first question - this is only possible when delivery is printed after the invoice has been created. Invoice number may be determined from the document flow (VBFA table, using VBRP won't be more efficient because you're looking for a consequent document) either in the output processing program or even in the form itself (I recommend the later if you're using a standard output program).

      Delivery output will need to be set up to do NOT print immediately (either by a batch job or in a transaction, if you have small volume and want to do it manually). After the invoices have been created, deliveries may be printed. If you're using a background job to create invoices, it's very easy to add another step and run RSNAST00 for delivery output.

  • avatar image
    Former Member
    Jul 19, 2013 at 07:25 AM

    Hi All,

    Since Sam says Delivery and Invoice No's are predefined.. can we map each delivery no with an Invoice no.. so that system uses the Invoice no at the time of Delivery creation and lock it for future Use???

    1) for every point of sale we have different number range given by government on a pre-printed form for delivery and invoicing,like we have four point of       sales so that mean we have four different series numbers for deliveries and four for invoicing.

    2) its government requirement to have delivery number on invoice.

    I might have gone wrong.. but can we work on these lines ???

    Counters Welcome

    Sriram.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 06, 2013 at 02:10 AM

    First thing would be to contact OSS or your SAP Account Manager.  SAP should of delivered a forn for this purpose.  if not then you'll need to write a functonal specificatio for a Smartform developer.

    Regards

    Waza

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2013 at 05:08 PM

    Hi,

    1) for every point of sale we have different number range given by government on a pre-printed form for delivery and invoicing,like we have four point of       sales so that mean we have four different series numbers for deliveries and four for invoicing.

    Please try to implement Business Place concept for different invoice number ranges.

    2) its government requirement to have delivery number on invoice.

    Please maintain copy control setting - @ header level between Delivery and Invoice - "Reference Field" as "Delivery Number".

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2013 at 04:28 AM

    Hi,

    if you check the Parcel tracking Tab in the Delivery Document you can find the Invoice Number.

    Add comment
    10|10000 characters needed characters exceeded