For calculating unit cost from included excise value

rinki123

Hi Experts,



In a trading company,when company receive a purchase invoice from manufacturer including Excise in value,how can we calculate direct unit cost from included Excise Value printed in invoice in purchase invoice form,using Navision functionality?


If we have a single item in purchase invoice then we done it manually but whenever we have multiple items in invoice, it is not easy to calculate each and every time that what is the unit cost including Excise.

For Example Purchase Invoice Shows -

Quantity | Net Rate | Assessable Value | BED@12% | Ecess@2% | SHEcess@1% = Total Value(VAT Base Value)


90 NOS | 119.6743 = (10770.69 + 1292.48 + 25.85 + 12.92 ) = 12101.94

---

Now, my unit cost is................ 12101.94 / 90 = 134.446 (is it any way to calculate unit cost from total value including Excise in Form Level?)

lubost

Hi,
I think you have to post pure unit and item charge should help you to post additional costs (+/-). Standard item charge functionality can divide charge by amount or plain.