Important

Refer to the Stock valuation documentation which describes the basic principles of stock valuation along with detailed information on price adjustments on receipt and issue. Click the link that applies to your Sage X3 solution:


Use this function to recalculate the average price and margins when the calculation base of the margin is the average price. When the valuation method is Average, FIFO, or LIFO and you have enabled Adjust issues cost, a recalculation trigger is created for transactions that will cause an adjustment in the value of subsequent movements. This cost adjustment record is held in the Cost adjustment table (STKMVTADJ) until this function is executed to update the value of movements.

When a transaction is adjusted, it is updated directly if it has not been posted. If it has been posted, a deletion record (in quantity) and an adjustment record are created.

If the period is closed for these movements, you receive an error log with the list of records that cannot be posted and the period that needs to be reopened.

  • You can only adjust primary valuation methods.
  • This function will ignore all products that have a negative stock total registered in their stock history. See Limitations.
  • It is recommended to run this function prior to calculating and declaring the stock value with the Stock valuation report. Running this function will ensure that all costs and variances are absorbed into the stock costs before the stock valuation calculation is carried out.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

This function can be launched in bulk for all the following transactions or selections:

  • Company
  • Site
  • Product category
  • Product
  • Valuation method
  • User
  • Statistical groups

You can run this process in simulation mode first.

Start - end range

From company (field CPYSTR)

Enter the company for the report.
To company (field CPYEND)
From site (field STOFCYSTR)

Enter or select the storage site where the selected product is active.

The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table.
To site (field STOFCYEND)
Category Start: (field TCLCODSTR)

The product categories are used to classify and filter the products according to their use. This step makes it possible to refine the selection prior to carrying out the adjustment process. This code is used in the Product record to enable selections.
Category end: (field TCLCODEND)
From product (field ITMREFSTR)

Filter for results within a range of product codes. For a single product, enter the same product code in the From/start product and To/end product fields.
To product (field ITMREFEND)
From valuation method (field VLTSTR)

Filter for results within a range of valuation methods. For a single valuation methods, enter the same valuation method code in the From valuation method and To valuation method fields. You can leave the From valuation method field blank to search all valuation methods.
To valuation method (field VLTEND)

End range of the valuation methods that must be applied to the products to be selected for the report.
From user (field BUYSTR)

Enter or select the code of the operator responsible for reordering the product on the selected site. This code is referenced in several scripts, such as the buyer’s plan, the supplier order entry, etc.

To user (field BUYEND)
field TSICODSTR

Filter for results within a range of statistical groups. For a single statistical group, enter the same group code in the Start/from group n and To/end group n (where n is a number) fields.
field TSICODEND
Simulation (field SIMFLG)

  • Simulation Mode ("Simulation" tick box checked): a fictitious adjustment of issue prices is performed. No modification is recorded. 
    A log file appears with the details of the performed update by clicking [Ok], at the end of the execution. The price adjustment should be used on a specific product, the simulation is limited to one BOM level.

  • Actual Mode ("Simulation" tick box not checked): an effective adjustment of issue prices is performed. A log file is available by selecting "detailed log file" in the STOTRACE- Log level stock update parameter (STO chapter, MIS group).

Limitations

This function will skip a product and write an error to the Log file if it detects a negative stock total for that product at any time in the product's stock history.

Stock totals for a product can go negative if receipt transactions are entered onto your system after issue transactions using a date that does not match the actual transaction date.

To prevent this situation from occurring, if you enter receipt transactions after issue transactions, that is the system treats stock as being received after it has been issued, you must ensure the transaction dates match the actual physical stock movement dates.

A correct receipt - issue date timeline is critical.

Example

Stock received - June 10 (actual date).
Stock issued - June 20 (actual date).

Issue transaction entered onto your system - June 23 - change date field to June 20.
Receipt transaction entered onto your system - June 25 - .

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Quantity generating a negative stock

This error is displayed in the Log file when a negative stock total is detected. See Limitations.

Use the Allocation date modification function (FUNIPTD) to modify the receipt allocation date of the incorrect transaction lines to resolve this situation.

Tables used

SEEREFERTTO Refer to documentation Implementation