Different Rate between Purchase Receipt and Purchase Invoice

ERPNext
1

Let say we received 1qty at $100 but on purchase invoice we get discount become $95.

How to update stock valuation rate from $100 to $95 for that product item?

Tks

2 Likes
2

I wonder why after submission of purchase invoice, stock valuation is not updated?

3

Hi,
-Stock Valuation Rate only update at the time of Stock entry,Purchase receipt,Delivery Note etc.

  • At the time of submitting Purchase Invoice Stock Valuation Rate can not be update.
  • At the time of Purchase receipt if you put discount then only that will be fetched on Invoice and Stock Valuation Rate will be updated.
  • if you not given Discount on Purchase Receipt and Directly given ā€˜Discountā€™ on Invoice then it will not accept.
  • If you want you can use "Allowance Percent " which is on ā€œItem masterā€ form or
    in Stock Setting .

Shraddha Ranjane
New Indictrans Technologies Pvt. Ltd

3 Likes
4

Allowance percent is only allow us to change rate in the invoice, but it doesnā€™t update stock valuation. So we will have ā€˜wrong valuationā€™ because of this issue.

I donā€™t understand why stock valuation is only updated in purchase receipt in purchase cycle. In business reality, invoice rate may differs from receipt rate due to discount, additional costs, rate correction etcā€¦

5

You can use Landed Costs to change valuation after you receive delivery.

6

When supplier send invoice, it often has different rate from receipt (e.g. it has discount, rate correction). Also the supplier sometimes charges additional costs in the invoice. These can be done in the purchase invoice, but it doesnā€™t update stock valuation.

Creating separate landed cost voucher to just update stock valuation is like doing this manuallyā€”double input & force users to calculate valuation manually before entered in the landed cost voucher. Many users most probably will make mistakes on calculation or forget in doing this since it needs 2 separate actions in 2 separate documents.

Landed voucher is more for landed cost invoice (another document) like freight charges that come after supplier invoiceā€¦

7

Iā€™ve seen Landed costā€¦and I think it cannot be used to change valuation per specific item at specific rate accurately.

Case example: rate correction per item, disc% per item on purchase invoice

I see Landed cost is only applicable for additional costs thatā€™s coming after invoice like freight chargesā€¦and later we spread it by amount or qty

8

@jof2jc I thought valuation was updated via Purchase Invoice. Anyways, you can fix this or sponsor development.

9
10

Please anybody whoā€™d like to share the cost for this fix? This is core issue which affecting costing calculation.

Invoice stage MUST also update stock valuation due to rate changes, discount or additional costs. Thatā€™s the proper way that all ERP systems must do.

Tks

11

It just happen to me.

Here is what I do :

  • Cancel the Purchase Receipt
  • Amend the Purchase Receipt
  • Update the Item Rate as in the Supplier Invoice I receive
  • Save & Submit the Purchase Receipt
  • Create & Submit the Purchase Invoice base on the Purchase Receipt

I hope ERPNext will consider to update the Purchase Invoice so that the valuation rate also update at Purchase Invoice (which will make it possible to enter different rate on Purchase Invoice).

Thanks

12

I will look into this / sponsor if itā€™s a larger fix - one of our largest suppliers gives us a 2% discount if we pay early, for example.

@rmehta could this be as simple as adding an ā€œUpdate valuation based on invoiceā€ checkbox in buying settings and updating the validation code on purchase invoice submission? I can take a look at it if thatā€™s the case.

13

iā€™ve been doing the same thing with @rudyhn ā€¦ and it is not good to cancel and amend documents each time. thanksā€¦

14

No need additional option setting. The proper way is purchase invoice must update stock valuation as far as itā€™s stock itemā€¦

We can consider also to add ā€œUpdate Stockā€ option in purchase invoice (similar with sales invoice), so user can bypass purchase receipt if needed

15

Now in V7.xā€¦Purchase Invoice has ā€˜Update Stockā€™ option but stillā€¦if thereā€™s difference rate between purchase receipt and purchase invoiceā€¦valuation rate is not updatedā€¦

Users have to go to another ā€˜manual workā€™ā€¦ using landed cost voucherā€¦which is not an ideal solution.

Update stock option in Purchase Invoice only ā€˜receive stockā€™ if we donā€™ use purchase receiptā€¦but not adjusting stock valuation if both receipt and invoice is being usedā€¦

1 Like
16

@nabinhait would you take some time to verify this? Iā€™m on V7 and Purchase Invoice doesnā€™t seem to update valuation rate if the rate is changed due to final disc, new contract etcā€¦

I think this is critical costing issueā€¦thanks

1 Like
17

+1 for me, I need this function too.

18

This guy has the answer:

akurungadam
Module Volunteer
Dec '17
You should try turning off the ā€œMaintain same rate throughout purchase cycleā€ flag in Buying Settings

1 Like