Subject: Request for Assistance with Landed Cost Voucher and Tax Calculation in ERPNext
Dear ERPNext Community,
In Ethiopian taxation, the item tax is calculated after the Landed Cost Voucher has been prorated and the applicable amount distributed. This affects the taxable amount in the Purchase Receipt tax calculation. The Landed Cost Voucher amount for an item is added to the item amount, and then the tax calculation is done based on this.
I understand that this functionality is not available by default in ERPNext and that I might need to customize my setup or write a custom script to achieve this. However, I am not sure how to go about doing this and would appreciate any guidance or advice you can provide.
Thank you in advance for your help.
1 Like
Firstly when you ask such questions, adding a few examples with numbers or mapping out the accounting entries does help understand the requirement better.
I am assuming that there is some taxable charge like Freight and Forwarding charges which are unknown at the time of booking Purchase Receipt and later you are posting a Landed Cost Voucher for it.
Here only one item was added to the Purchase receipt which had a base rate of 1000 and then an LCV was posted for adding charges of 100
This is how the accounting entries look once the PCV is submitted and the taxes do get booked on the Purchase Receipt
The taxes do get added to the purchase receipt. You’ll have to elaborate more on your question for us to give further suggestions
2 Likes
Thanks for sharing this example. It would help me clear some confusion (and perhaps be useful to the forum) if you can also illustrate how LCV is different than say an item/account affecting inventory valuation? Is it possible to create a workflow / account / item called Inbound Freight whose expense is automatically added to the inventory valuation? So this expense will only be deducted as the goods are sold (not when incurred). Or the recommended route in ERP is always via LCV? Import tax, duties etc and exchange rates are often dictated by local customs authorities - only route for those to be booked is via LCV?
