problem in the creation of 2nd invoice

[Former Member]

Hello Friend,

Process:-

We are facing problem at the time creation of 2^nd invoice, we are doing following process

1 ) Create multiple Sales Order with multiple Item (T-code :-VA01)

2 ) Create multiple Delivery with reference to multiple Sales Order  (T-code :-VL01N)

3 ) Create Single Shipment Document with single Transporter against multiple deliveries and multiple routes (T-code :-VT01N)

4 ) Create  Single Shipment Cost Document against single Shipment Doc. (T-code :-VI01)

5 ) Crete Individual billing document with reference to Delivery (T-code :-VF01)

Issue:-

Same Condition type of fright is triggering twice in 2^nd Invoice which should be trigger 2^nd condition record for2nd delivery in 2^nd Invoice

For eg:-

Eg 1:-

Eg 2:-

Invoice Document	A
	B
	C

Let Say,

Pricing of Invoice of A

Invoice A		Amt	Per	Unit	Condition Value
	Basic Price	100	1	EA	100
	Fright	20	1	EA	20
	Total	120			120
	tax 5 %	6	1	EA	6
	Net amt	126			126

Pricing for Invoice B

Invoice B		Amt	Per	Unit	Condition Value
	Basic Price	125	1	EA	125
	Fright	30	1	EA	30
	Fright	20	1	EA	20	(Condition Record of 1st Invoice)
	Total	175			175
	tax 5 %	8.75	1	EA	8.75
	Net amt	184			184

I have maintain Condition record with the combination of Transportation planning point+Shipment Type+forwarding agent+shipping point+material grp

I have maintain Condition class  “B”  in Condition type for fright

Please help us to solve this issue, for better understanding if require I can share the process with screen shot also.

[former_member182378]

Mitul,

What is the freight condition record?

How is the first invoice getting value 20 as freight and the second invoice getting 30 + 20 as freight?

For how many deliveries are the invoices (first and second) created?

Please paste the screenshot of "Analysis" of the first and second invoices.

[Former Member]

freight condition record = TransportPlanningPt + Shipment type + Service agent f.stage + Shipping Point/Receiving Pt + Dest. zone + Material freight grp

We are calculating Fright at the time of Shipment Cost doc then we are copying from shipment cost doc to Billing doc.

1 Delivery = 1 Invoice

Following are the screenshot

[former_member182378]

Mitul,

It is not clear why freight is populating twice in the second invoice. Please explain.

The screenshots are not visible.

Message was edited by: TW Typewriter - updated

[Former Member]

Screenshot of 1^st Invoice

Pricing Analysis of 1^st invoice

Pricing analysis at the time of shipment Cost doc.

Screenshot of 2nd Invoice

Pricing Analysis of 2^nd invoice

Pricing analysis at the time of shipment Cost doc.

[jpfriends079]

Mitul,

Do you have scales for the condition type for this freight condition?

Further, is it possible for you to post screenshots for Item-Condition-Details & condition record (refer following screenshot) for both condition lines in question.

Thanks, JP

[Former Member]

Dear Prakashji,

NO we don't have scales for the condition type for fright condition

Detail of the 1st condition record

item Detail of the 1 st condition Detail

Detail of the 2nd condition record

item Detail of the 2nd condition Detail

[jpfriends079]

Check how those are getting determined in your shipment doc in source reference line. As your condition record determination in the invoice is Fixed & referenced from shipment doc. We can see 2 different Departure zone are determined. 1st Line - Z1000240 & 2nd Line - Z1000004. Also, compare your departure zone in your sales order, delivery & shipment doc.

If possible, try update pricing in your billing doc.

Thanks, JP

[Former Member]

how should i inactive second condition record for fright at the time of creation of billing document

Thanks & Regard,

Mitul

[jpfriends079]

Clearly from your Item - Condition - Detail, the pricing source is F - Shipment Cost(Check VTFL - Item - Pricing Source). It will better, if you can control this at shipment level. As actual shipment costs will be based costing in shipment for settlement and accordingly that is billed. Correct?

Why suggested pricing update. If either of the departure zone is not maintained, the system will redetermine pricing accordingly.

In addition to that, please check what is your Pricing type maintain copying Control for Delv to Billing(TCode VTFL). Hope you have suitable one assigned there.

Thanks, JP