Incorrect Stock Valuation due to mismatch in Purchase Invoice and Purchase Receipt

ERPNext Accounting
1

Background Info: We import materials. Agreement with supplier is payment first before ship out.

So our process for these in ERPNext is

  1. Purchase Order
  2. Purchase Invoice
  3. Payment Entry
  4. Purchase Receipt (maybe after 2 or 3 months; when the item arrives)
  5. Purchase Invoice (for any additional expenses from 3rd party like delivery charges or freight charges)
  6. Landed Cost Voucher.

Problem 1: Exchange rate at Purchase Invoice and Purchase Receipt is not the same. This causes mismatch in Stock Received But not Billed account

Problem 2: There are times when Purchase Invoice and Purchase Receipt quantity is not the same. For example you purchase and paid 3 cubic, but upon receiving the item (maybe 2 or 3 months later) it is actually 2.98 cubic.

This causes mismatch in Stock Received But not Billed account because total value is not the same

Additionally, I would like stock valuation to use Purchase Invoice amount on Purchase Receipt quantity. Since in the earlier example, we paid for 3 cubic but only received 2.98 cubic. So my costing per cubic should be more expensive to take into account the 0.02 cubic that was lost.

Any help would be appreciated.

Thank you

2

Create a Debit Note against the Purchase Invoice for the non-received quantity value.

Example:
If the Purchase Invoice is created for 3 cubic, but only 2.98 cubic is received, then create a Debit Note for the remaining 0.02 cubic value.

After that, the Purchase Receipt should post accounting entries only for the accepted/received quantity value (2.98 cubic)