1 of 1 people found this helpful
If you are using the Total Cost Template this should be an easy task.
Create a lot and create all line items within that lot. At the lot level create the the following cost terms and they should add up to the total you are looking for.
Freight = 400
VAT/CST = 2000
Service tax = 300
Thank you Vilas ! It worked for me.
Thanks for your help on the previous query. It was very helpful.
Here is the new case where I have been assigned to get the Landed cost by defining formula in RFP template.
Would you kindly advise me, How I can derive the Landed cost by creating formula in RFP with total cost ?
Below example for your reference.
Line item 1 : 10000
Line item 2 : 20000
Line item 3 : 30000
Line item 4 : 40000
Line item 5 : 50000
- Discount : 10%
+ CST : 12%
+ Freight : 1000
+ Packaging and Forward : 10%
+ Additional charges per Qty : 2%
How do i get the Total Landed cost for above table ? Hope, I am not coming back with the same question !
Thanks in advance.
You do the same thing that Vilas suggested before, just add additional terms as needed. The only question I have is related to the last term, "Additional Charges per Qty". Are you wanting this term to interact based upon the item quantities? Or is that jus tthe name and you are just multiplying the Lot Extended value by 25?
I have added the additional terms as usual but the Total Cost calculation is not coming perfectly. Maybe, i will have to define a formula to get the total cost.
I have followed the below procedure:
Step 1. Created Section in Content Tab
Step 2. Under Section, I have Created Line items
Step 3. Added Cost Terms to Section Level
Now my concern is % of Discount, % of CST, and % of pckg&fwd. These components are calculating only in the Cost Terms level but not at the Section level. I needed at the Section level.
Please Note : I would want to add these components at the Section level only.
That isn't how it works. You need to add an item lot to the Total cost event, add the cost terms to the lot and you are good to go.