How the current taxes and charges in purchase invoice work is that ,
if i consider the charge for valuation and say add 50 on actual , then the amount will be divided equally and added to each item in the invoice equally , or if i add on rate then that is the rate for all the items in that invoice and the valuation will be increased accordingly for each item .
Please correct me if i am wrong in this understanding ,
But that is not how the extra charges are actually distributed , – what i am talking about is obviously the charges of shipping and fright etc.
They depend upon weight ,each item has different and the item with more weights has caused the charges to increase more and the valuation of that item should be increased more as compared to the light weight item which relatively added very little cost to shipping .
There should be field in the items table as extra cost so i can add the cost for that item individually , this cost i need to be added only to the valuation and not the total of the invoice .
this way i can add different extra cost for each item which would separately reflect on the valuation of that item .
Is there a way already present to achieve this in the system ? if so please tell ,
Created a custom field in purchase invoice item called extra_cost_rate, which is the rate of the extra cost each item is incurring , using custom script added it to base_rate (because the invoice might be in different currency and the additional cost is in local system currency - so adding in final converted rate ) , now finding a way to trigger the recalculation of totals , as the event is not set for base_rate (only rate) – might need to customize in transactions.js ??
this will increase the total of the invoice as well ,
IS there a programatic solution for adding this cost only to valuation rate of those items , ? what all paramters i need to change?
Any idea be it functional or programatic is welcomed .
You create an invoice that will contain items you sell.
For each item that you add to the invoice , the item has a base price, to which you add an additional amount for valuation of some sort, or could we call it a profit margin based on some criteria - customer, quantity for example.
In addition there is a charge for shipping the item. Each item may ship separately, not in one shipment so you would like the freight charges for each item to be attributed to the items themselves not to the invoice as a whole.
The shipping amount for each item will be determined by shipping method and weight of item, and needs to be calculated for each item separately then added to the price of the item.