How to Process a Value Change for a FIFO Valued Item in Sage X3

By: | Category: ERP

With today’s frequent fluctuation in commodity pricing and supply chain challenges, the cost of raw materials can change significantly over time. Read today’s blog to learn how you can use an X3 utility to update the inventory value of FIFO products within the manufacturing processes to keep your profitability in line with changing raw material costs.

Learn how to process an inventory value change for a FIFO valued item. Content for this blog post was originally posted on Sage City by Joel Singam, December 23, 2021.

For an item that is valued at FIFO (First in First out), we can use the value change function to modify the FIFO basis lines. This will generate a stock movement record in STOJOU with a TRSTYP of 23. Lately there have been some changes in this area and the recommendation is to modify each FIFO layer at a time.

For example, let’s take an item whose valuation method is FIFO.

  • Go to value change function under Stock, Utilities, Valuation, and pull up this item.
  • You can see it defaults the distribution and auto journal code fields and lists the available FIFO stacks, quantity and the unit price. If you are managing lots, then you will see the lot layers under “Batches” grid.
  • For the item selected below, you can see the Global values and FIFO totals on the top half of the screen and the bottom half displays the FIFO basis and lots lines.

Value change screen: Global values match the product site record and the FIFO totals with FIFO stack lines.

FIFO-Valued-Item-sage-X3

Stock valuation report: If we run the stock valuation report as of today, we can see the same values as shown above.

FIFO-Valued-Item-sage-X3

FIFO-Valued-Item-sage-X3

Next, issue out a quantity of 20 from lot 2222.

In the stock valuation report the current unit price is $10.71 and the amount in USD is $321.25.
FIFO-Valued-Item-sage-X3

In value change screen FIFO totals match the stock valuation screen. The FIFO price used for the issue is $10.50.
FIFO-Valued-Item-sage-X3

Product site record average cost matches the value change global value average cost.
FIFO-Valued-Item-sage-X3

Listed below are the STOJOU, STOCOST, STOMVECOST tables.

CSTCOU_0 value for the receipts used, match the delivery transaction record.

STOJOU:
FIFO-Valued-Item-sage-X3

STOCOST:
FIFO-Valued-Item-sage-X3

STOMVTCOST:
FIFO-Valued-Item-sage-X3

Now let’s use the value change function to update the value of a FIFO layer.

  • When changing a FIFO price or quantity, always update a single FIFO layer at a time and do not update two layers at the same time.
  • When you run the stock valuation report after a value change using the FIFO basis grid, the stock valuation report will look for any value change records where CSTCOU_0 is equal to the CSTCOU_0 of the receipt.

Therefore, the recent change implemented requires that any value change must be done on the FIFO basis and only one FIFO line at a time.

Value change is not built to create multiple STOJOU records when multiple FIFO tiers are adjusted at the same time.

Reduce the unit price of the second FIFO stack by $5.

In STOJOU, system picked up the CSTCOU_0 line (7770.0) and assigned that number to the value change line TRSTYP_0 = 23.
FIFO-Valued-Item-sage-X3

FIFO-Valued-Item-sage-X3

FIFO-Valued-Item-sage-X3

If you want to modify 2 FIFO tiers, do the second change after completing the first. This way the stock valuation report will have a clear picture and be easy to analyze.

If you have any questions about processing a value change for a FIFO valued item, or any other questions about Sage X3, please contact us.