on 11-05-2009 9:28 AM
Dear Gurus,
Our sales cycle is: Quantity Contract (VA41)
Sales Order (VA01)
Delivery (VL01n)
Shipping document (VT01n)
Shipping Costing document (VI01)
Billing document (VF01)
The issue is, when the Quantity Contract (QC) is made, the Marketing HOD has to approve it and only then a Sales Order can be created. And for the Mrkt HOD to approve the QC, he needs to see the Net after deducting all the costs incurred.
For Example: Invoice Value - 1000
Excise Duties - 100
Freight Charges - 150
Commission - 50
Sales Tax - 125
Other expenses - 75
Here we have to show the Net as (1000 - 100 - 150 - 50 - 125 - 75) = 500
But since Freight charges are being generated in the Shipping Document, I am not able to bring that value into the QC to show the correct Net value.
Freight charges are maintained in TK11 and are based on the 'Route' as determined in the QC according to the Customer's Transportation Zone.
How can I populate Freight condition type ZB00 in the QC with the value as maintained per the Route which is determined in the QC under Shipping.
I tried to search in the Forum, but unfortunately did not find a suitable thread. Any help from your side is HIGHLY appreciated.
Best regards.
Venkat - Hyd.
Closing the thread since no more replies. Appreciate all the efforts.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi venkat
U can use a pricing condition type for freight .Define a new condition type , a new access seq.
U can check the no.of options are avialble in filed catalog in t.code OV24,LZONEZ(Destination zone),Target postal code (PSTLZZ) or TRFZNZ Tarif zone of destination. Using any of these fileds along with Ship to party , plant u ca set acc seq and condition records.Through which at the time of Sales order Value of freight can be derived.
If Trnasportaion zone is filed needed u can add the same using append structure to KOMK or KOMP table.U will need help of abaper for that ,as after filed addition ,code is to be written in exit to capture value in filed.
and routine to update same in pricing.
Check the solution most suitable to u
Regards
Mandar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try from another way, Hope it may work.
Make sure Freight Condition type in Sales Pricing Procedure & Shipment cost Pricing procedure is same.
Else,
Create Freight condition type in V/06, with the same properties as shipment cost Freight Condition type(T_06). Use same access sequence with the tables . Assign this access sequence in respective condition types.
Assign Shipment cost condition type in SD freight condition type in V/06 in Ref Condtype field / Ref.Application "F"-shipment costs.
OR
you can do the same in viceversa,
assign SD freight condtion type / application(V) in shipment cost condition type inT_06.
it may help you.
Test & revert
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Here is my opinion.
Assign service vendor to partner function of customer master.
Create a condition record for freight charges where in condition records for the same has to be determined through condition technique.
ZFRE - freight condition type to be included in your pricing procedure.
Create a new access sequence for the above condition type (ZFRE)
Now create a z condition table to be assigned to above access sequene.
This condition table should include the fields as below (Select from field catalog):
Customer city code - CITYC
Vendor Number - LIFNR
And if required u can add some more fields in this new condition table.
Maintain condition records for condition type ZFRE.
Create a sales order and check condition record for the ZFRE is being derived or not....if it gets...hope this would resolve your issue.
Regards,
Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.