Sales Invoice and Sales Order Posting Date Issues

ERPNext
1

Hello Guys,

When I change the default value of Posting date during creation of SALES ORDER or SALES INVOICE, the LUOM Liter is not working ie I change UOM from Gallon to Liter.

Here is my Configurations:

UOM Conversion Factor = 1 Gallon = 1000 Liter

Item Properties:
UNITS OF MEASURE
UOM = Gallon, Conversion Factor = 1
UOM = Liter, Conversion Factor = .001

Item Price
1,650/Gallon
450/Liter

Step to Replicate issue:

  1. Create Sales Invoice
    2 Select Item Name by default Item is in Gallon (1,650) Price is Correct
  2. I change Gallon to Liter and I got (450) Price is Correct
  3. Edit Date posting 4 days backward and the Rate become (1.65)

Posting Date - Jan 20 - Rate = 450/Liter - True
Posting Date - Jan 19 - Rate = 450/Liter - True
Posting Date - Jan 18 - Rate = 450/Liter - True
Posting Date - Jan 17 - Rate = 450/Liter - True
Posting Date - Jan 16 - Rate = 1.65/Liter - False

Is this a bug or configuration only?
anyone can take a look at this, thank you in advance to your help

2

Could not replicate this on v13. Which version are you using? Also, check the “Valid From” date in the item price master. Maybe that is causing an issue.

1 Like
3

I am using ERPNext v12.16.2

4

Thank you so much, I resolve the issue make empty the “Valid From”