Confused with Landed Cost Voucher. Need some help and explanation

aldoblack · January 20, 2020, 6:43pm

I am on v12 and I am confused when I create a Landed Cost Voucher. This is my example on e newly installed environment.

I created a Purchase Order -> Purchase Receipt -> Purchase Invoice -> Payment Entry

which Grand Total is $5000

After that I sell 8 of them for $100 each.
8 * $100 = $800.
(Sales Order -> Delivery Note -> Sales Invoice -> Payment Entry)

When I see Profit and Loss Statement it shows like this:

which makes sense. From $800 that I have sold, my expenses are $400.

BUT, when I create a Landed Cost Voucher of $1000 on Purchase Invoice that was $5000 the Profit and Loss Statement changes.

This is the Landed Cost Voucher:

and this is the updated Report of Profit and Loss Statement

How was that -500 calculated ? Why my profit went from $400 to $1300 which doesn’t make sense because I spent $1000 more on that Purchase Receipt which was the Shipping Cost.

shraddha · January 21, 2020, 5:34am

Hi,
Have you gone through document ?
https://erpnext.com/docs/user/manual/en/stock/landed-cost-voucher

It may help.

nmami · January 21, 2020, 9:27am

Hi,
I did some investigation on your issue, below my feedback, as a conclusion remaining stock onhand 92 should get the 1000$ extra cost only, what you say?

aldoblack · January 21, 2020, 5:59pm

Yes, I did. I always read documentation first. before posting here.

aldoblack · January 21, 2020, 6:01pm

I, still am having difficulties how that $ -500 and $ 1300 was calculated on Profit and Loss Statement after I created the Landed Cost Voucher.

nmami · January 21, 2020, 8:16pm

For me it’s more a bug, but we need confirmatiin from community members…

aldoblack · January 22, 2020, 5:52pm

Can you tag anyone please, because I do not know which one to tag.

nmami · January 23, 2020, 9:44am

Hi @nextchamp.saqib,
I am sorry to tag you, since I am not sure about above issue is it a bug or not, please could check and update at your free time.

Or let me know who can help on this.

Rgds
Nofal

sunhoww · February 2, 2020, 6:52pm

Hi.

The profit seems to increase from $400 to $1300 because you haven’t entered any outgoing expense for Shipping Cost yet. You’ll notice that the value against Expenses Included in Valuation is negative. This will need to be adjusted somewhere.

Suppose you make another Purchase Invoice to another Supplier for the Shipping Cost for $1000. The “purchase” of this service might go against Freight and Forwarding Charges. After this transaction the following values will get cancelled out -

Expenses Included in Valuation $-1000
Freight and Forwarding Charges $1000

Total expense will be $500. Which should give you a Profit for the year of $300. A decrease from the one before the LCV, which is understandable because the valuation rate of the items just increased.

Referring to the screencap, the Jan column is similar to what you have and the Feb column is after the Shipping Cost expense is registered.

That being said, I think the Cost of Goods Sold amount should be $480. Reasoning -

Before LCV
valuation rate: $50
cogs: $50 x 8 = $400

With the LCV, the $1000 is considered as additional value of the items.

After LCV
valuation rate: $60 (because original total value of all items $5000 + $1000 = $6000, so the valuation_rate becomes $6000 / 100)
cogs: $60 x 8 = $480