invoice split for customers

[Former Member]

hi gurus,

can anybody please throw some light on this scenario.we have a thrid party scenario where a customer orders a mateiral from us, we then order it from our vendor and ask him to deliver the customer. so we create the sales order for the material, purchase requsiiton gets created and then that is converted to a PO and then vendor ships the mateiral to the customer based on the devliery address on the PO. now as an example here the customer orders 2025 EA from us. The container quantity is 675 EA. the customs people need 1 invoice for each  of the container. so the vendor ships 3 containers each of 675EA to meet the 2025 quantity. now on the purchasing side we can ask and get the ASN and inbound delivery for each of the 675 EA from the vendot, in other words we can get 3 ASN's for 675 each and then after that in MRRL transaction we have the flexibility to generate the invoice per material document. so we can generate one invoice for each of the 675EA quantity but on the sales side in VF01, once the total quantity of 2025 is received on the purchaisng side, the total quantity comes up for billing. is there a way we can split the invoice on the sales side to match the invoice quantity on the purchainsg side.

The current process to get around this problem is, the purchaisng side they receive 675EA and ask the customer billing team to do the customer invoice for 675 and then do the 2nd 675 EA receipt and ask the customer innvoing team again to do the invoice and then receive the 3rd container of 675ea and then do the final billing and so on and so forth.

Thanks

anusha

[Former Member]

Hi Anusha,

There is nothing to special for this

For copy control sales document to billing document at item level set price indicator as order related quantity status according to invoice quantity.

Meaning when you do invoice receipt of 675 ea in MM side, then sales team will create invoice then system automatically picks qty 675 ea even though sales order have one line item with qty 2025 ea

Kapil

[Former Member]

Dear Friend,

                  It is nothing but a Invoice split made invoice at PGI level and made proforma invoice, may it will work please check and revert me back...

Thanks,

Hussain

[bsivasankarreddy_reddy]

HI

you have three invoice s for container wise ,

so you create the sale order for three lines item , for each line items 675 ea, and do the po side complete , then you can do the billing for order related billing when you enter the order number and select the line item, click on the selection list , Here comes three line items , select one line item do the invoice and also do the same thing 2 , 3 line item , then it will comes three invoices for each line items , with invoice split,

you want invoice split fallow the T W ans , 

[Former Member]

There is something I don't understand. Why do you need to match sales invoice to purchasing? Are you using vendor delivery document to customer instead of customer delivery document?

Why not a remarks in the sales invoice, that this is for 3 container?

[former_member182378]

Good point!

To site a similar example i.e. customer wanted invoice per truck load - The customer calculated costs on a "truck level" e.g. material cost, transportation cost, resource cost (truck driver, warehouse) etc.

Thus the customer needed invoice at "truck level".

[Former Member]

Yes. we are using vendor delivery document, in other words the statistical goods receipt that we do is an indicatioon and confirmation that the vendor has shipped th product to the custoomer. That triggers the AP invoice creation on the AP  side and then eventually the AR team would create the cusotmer invoice. It would have been nice if on the sales side as well there was a way on how we can generate tjhe invoice. Pretty similar to MRRL tcode on the purchasing side. In MRRL we can generate AP invoice for the whole PO, per line item, per material document etc etc.

[Former Member]

You can consider automatic delivery and invoice.

You have delivery unit in Material master as 1 CO in Sales Org 1 view.

You have Alternate Data -- uom conversion factor of 1 CO is to 675 EA/PC.

You set-up automatic delivery creation as background job at interval of example 10 mins. Once stock is GR and available, delivery document will create base on standard pack. Assume that vendor will give inbound delivery for each CO and at seperate timing. You also set-up automatic PGI at 10 mins and then automatic invoice at 10 mins interval.

You can consider delivery split by adding qty check in Data transfer routine. With this design, you may also consider 1 delivery 1 invoice by setting copy control VTFL header Reference Number as value "C.

[jignesh_mehta3]

Hello Anusha,

A T-Code like MRRL is not available on SD Side.

As suggested by others above you can create multiple line items in Sales Order & then create Invoice for each line Item.

Alternatively, in Item Category you can set billing relevance as G - Order-related billing of the delivery quantity. Thus as soon as statistical GR (MIGO) is done, you can create Sales Invoice for GR Quantity on Sales side.

Thanks,

Jignesh Mehta

[former_member182378]

In sales order, of total quantity 2025EA, create 3 line items, each of 675EA. In each of the line items, in Tab Billing Document, field INCO2 (Incoterms 2nd field) give different value. E.g.

Line item 10: Incoterms = DDP, Container1

Line item 20: Incoterms = DDP, Container2

Line item 30: Incoterms = DDP, Container3

By the above "setting" in the sales order, there would be invoice split (creation of 3 invoices). As INCO2 is a header field in billing (table VBRK).

Side note, giving different values to INCO2 shall not affect pricing, if condition record is not created with field INCO2.

The above concept of invoice split can be done for other fields too. Note that the field should be in the VBRK table (billing header), that shall cause invoice split.

In sales order different line items have to be created.