Valuation rate and Avg. Buying Rate misconception or bug

Dear all,
I have been using ERPNext for over a year now, and i’m pretty satisfied (even grateful) that such an amazing system exists.

What I still do not understand up to this moment is:
1- What exactly are the factors that affect the valuation rate of an item? (in gross profit reports and stock reports)

  • sometimes the VAT 5% from the P.inv doesn’t add up at all to the valuation rate in the reports, and sometimes it does.
  • sometimes adding an amount of Expenses Included In Valuations adds up in the valuation rate when I check the stock ledger/balance, and sometimes it doesn’t.
  • adding Freight and Forwarding Charges charges to my P.inv never seems to add up at all in the items valuation rate in the reports.

what are the rules/factors? how can I know the exact Initial Cost of an Item I purchased which includes all the taxes/charges/reductions?

(only the 5%VAT added up to my valuation rate, even though the item costed me 25SR (including all the charges) not only 21… and that -in turn- messes up my gross profit report with extra (imaginary) profit.

So what have I missed here?

up ^^

Why are you considering the VAT as the cost. It will be recovered from the customer in the sales invoice. This VAT is your asset and when you recover it the balance you will give to govt.
For me, the valuation rate is filled during the stock entry and then all relevant reports are calculated perfectly.

that depends, here in KSA not all companies can charge VAT this year… so it is very possible that we need to consider the VAT as cost because 99% we do not charge it in the sales invoice and thus our pricing policy will make no sense.

  • ERPNext ALREADY counts VAT as the cost in my newly set erp accounts… so how does that add up?

  • VAT isn’t my only issue, how about Freight and Forwarding Charges? how about Expenses Included In Valuations?

again,

@Sam_HLK it depends upon the calculation method you selected at the time of making these templates

E.g. in tax template there are 3 separate calculation methods under consider tax or charge

  1. Total- it will not impact item valuation
  2. Valuation and Total- it will impact your valuation rate

Same applies in landed cost and fright charges

Thank you, this seems really helpful in my case…

However, I couldn’t find those options in “Tax and Charges Template”
Can you please tell me where it is?

Here are the web based docs https://erpnext.org/docs/user/manual/en/setting-up/setting-up-taxes

The Awesome search bar and Help system built into ERPNext work well for learning.

To check a current instance with data try demo.erpnext.com

Welcome and hope this helps Sam_HLK

2 Likes

It did help a bit indeed but it didn’t answer my question.

let me quote once again:

what are the rules/factors? how can I know the exact Initial Cost of an Item I purchased which includes all the taxes/charges/reductions?

And yes, I pretty much tried looking that up myself but couldn’t find any documentation about it.

As a grateful user and to find out for yourself, one sure way is to setup a few test cases to compare expected with actuals - the scientific method!

Then let us know what you discover :wink:

already done sir, and the results were shocking :sunglasses: I found the solution and I pretty much know everything now…
I could even say what I found could be considered a “bug” :laughing:

And being the grateful good-hearted user that I am… I’ll tell you what it is about…

Then let us know what you discover :wink:

when you add your expenses (ie taxes/freight&forwarding/shipping) from a predefined templated… everything works like a charm… and the ‘gross’ cost that you see in the reports for each time- already includes all the mentioned expenses.

HOWEVER, when you manually add those lines in the P.inv. , nothing will add up and the ‘cost’ you see in the reports would only (unfortunately) be the exact purchasing price from the p.inv. (no matter how many lines you manually added in the ‘charges’ field…

PROBLEM SOLVED everyone ! :v:

1 Like

here I manually added the rows of the p.inv expenses and taxes (P.inv 00100)

20,000+1,000+500+400/1,000(qty) = 21.9SAR (gross unit cost)… and that number never showed in my reports… only the exactly item purchasing rate showed there (20SAR), which is very very problematic…

and here I only chose the predefined template, and it automatically added the rows for me (P.inv 00105)


500+500+1,000/500 (qty) = 22SAR (Per unit)… and that was exactly what appeared in the SL

here’s the stock ledger :slight_smile:

2 Likes