Hi Jonathan.gonzalez 

I think you should use the Last purchase cost to obtain the result you are looking for:

Please be sure to run the proper test in a test environement prior to changing your Live environment.

Hi Jonathan.gonzalez 

I think you should use the Last purchase cost to obtain the result you are looking for:

Please be sure to run the proper test in a test environement prior to changing your Live environment.

Actually I run some test in 2023R1 and I failed to replicate the scenario you mentioned above:
See before misc. receipt:

Both Last receipt cost and Last purchase price remain identical after the misc. receipt created at a different order price:

Can you share the detail of the valuation method setup (screenshots)?

Thanks Julien Patureau ,

We need use "last receipt cost" and not "Lats purchase cost" because we have additional invoices that increase the "last receipt cost" that must be the true cost (purchase cost is less than "last receipt cost" ).

Here some screenshots with our problem (sorry by the language, i translate):

Valuation method:

Example with Product 000145:

Last Journal receipt:

Related transaction:

Thanks!

Hi Jonathan.gonzalez 

I have reproduce the described behavior (2023R1).

By design Last cost is updated with the latest stock receipt (misc. receipt included).

Jonathan.gonzalez said:

I create a miscellaneous receipt, qty=1, value=23. Therefore the product-site "last receipt cost" change to 23. I would like to maintain 22.

If this is really the expected behavior, then I can suggest a simple development to ensure to have the order cost entered at Last price, but of course this would affect the secondary valuation method as well.

But before you move forward on this direction, I'd like to draw your attention on your unusual configuration:  using order cost for receipt but Last cost for issue is inconsistent in my opinion.

Imagine, the following scenario:
• Supplier Receipt 1: 1 unit at 2€
• Supplier Receipt 2: 1 unit at 3€

At this stage stock value is 5€ in your GL and last cost is 3€
So if you empty your stock, you will get :
• Customer delivery: 2 units at 3€ (so total value 6€)

And now in your GL you have a negative value (5-6=-1) for your stock value. I suspect, the valuation method maybe not set to do what your are looking for.

In the above scenario, after creating the receipts 1 & 2, what is the expected value for the 1st unit you will issue? Then what is the expected value for the 2nd unit you will issue?

Hi Julien Patureau ,

I understand the design behaviour, but in stock journal the "Value price" (0.4476) is the last cost befote the misc. receipt. I don't understand why Sage x3 use the "order value" (0.5050) to update last cost and not "Value price", as "Receipt valuation exceptions" said. The development is our B-plan (maybe easy, because these misc. receipts come from a existing development).

About the configuration: Issue with last cost (is ok); Receipt with order cost (sage x3 doesn't allow use "last cost" in "Receipt Source" but yes in "Receipt Alternate" in Valuation method).

We work always with last cost. The problem comes when the misc receipts update the last cost with an erroneous value (because the correct is purchase cost + aditional costs).

All issues must be valued to the last cost receipt.

In your example, after Receipt 2, all issues must be 3€. 

If GL = General Ledger, in Spain is not mandatory register the stock movements in GL. 

Thanks Julien Patureau 

Hi Jonathan.gonzalez 

So I think you have not choice but to go for plan B: development.

Jonathan.gonzalez said:

I don't understand why Sage x3 use the "order value" (0.5050) to update last cost and not "Value price", as "Receipt valuation exceptions" said.

Last price, Average cost, Lot Average cost and FIFO are always calculated in Sage X3 disregarding the valuation method setup (based on VARORD and not VARVAL). Indeed, if you are using standard cost, following your proposition, the system should fed the above costs with the value matching the standard cost.

The benefit of the current behavior is to be able to compare your stock value with other methods (using the valuation report) and to be able to change of valuation method at some point.

Jonathan.gonzalez said:

If GL = General Ledger, in Spain is not mandatory register the stock movements in GL. 

Yes GL stands for General Ledger.