cancel
Showing results for 
Search instead for 
Did you mean: 

Adding a line item in Invoice

former_member393821
Discoverer
0 Kudos

Dear Expert

Greetings!

We have a requirement from our customer, as mentioned below.

Requirement,

-> Add new line item in the invoice for the customers with the transportation cost per invoice created on the day.

    The New line item is required as they charge 23% tax for the transportation cost (service material).

I am thinking of user exit in include LV60AB03.

Please let me know, if any other work around possible to reduce manual effort.

Please note, there can be multiple sales order combined in one invoice.

regards

Praveen

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Govindappa,

Add a new line item at Sale order level.

and then create a invoice.

Regards,

MK

former_member393821
Discoverer
0 Kudos

Hi Mahesh,

Adding a new line item in sales order is difficult as multiple order are combined in one shipment.

And the transportation cost is charged based on the invoice created as per the shipment.

There is a possibility the customer can order more than once per day and receives one shipment at the end of the day.

the transport cost has to be charged based on the shipment.

Note : We are using collective shipment, where multiple orders from different customer are combined in one shipment

regards

Praveen

Lakshmipathi
Active Contributor
0 Kudos

Create a new condition type which should be assigned both in shipment cost pricing procedure and billing pricing procedure.  Set this condition type as statistical in shipment pricing procedure.  In billing pricing procedure, check the box "TSPP" and assign routine 24 so that it will appear only in billing document.  Finally, in copy control for Delivery to Billing type, set "F" for the field "Pricing source"

G. Lakshmipathi

Answers (2)

Answers (2)

ravi_kumar100
Active Contributor
0 Kudos

Hi,

If you do not have transportation /shipment process configured you might not be able to use the shipment cost functionality.

In your case if the transportation cost is known then you can create a condition type as both Header/ Item condition and Group condition ( so that the value is proportionated to the items) with records to be determined during Billing creation.

As you are creating the Order Related Invoice ,check with your business for which combinations the transportation cost has to be triggered.

Regards,

SRK.

former_member393821
Discoverer
0 Kudos

Hi SR Kumar

The Shipping cost calculation is difficult as multiple deliveries of different customer are combined in one shipment and Transportation cost is charged on basis of per shipment to customer.

Please correct if my understanding is correct.

regards

Praveen

RAF
Active Contributor
0 Kudos

HI,

you can try using Shipment Cost document via transaction VI01.

Copy per standard copy control these cost condition into the invoice.

Set up a tax condition with basis value for this condition.

BR