Stock valuation report

• Reference date (field REFDAT)

Specify the calculation date of the stock and costs.

• If you enter the current date, the printed report is a current valuated stock report.
  
• If you enter a date prior to the current date, the stock is recalculated based on the stock movements at the given date, including the allocation date (IPTDAT) or accounting posting date (ACCDAT) if you have selected the Accounting date flag.
  If you have not selected the Accounting date flag: for products where Adjust issues cost is set to No at the Valuation method level, the creation date (CREDAT) is always used and not the allocation date (IPTDAT) for the price adjustment movements (e.g. on invoices with price variances) and for value change movements.

• Company (field CPY)

This field specifies on which company the process is carried out.

• Costing mode (field CSTCOD)

Choose the stock valuation method. The possible values are:

• Standard price (for the year of the reference date).
• Updated standard price (valid on the reference date).
• Last price (available only if the reference date is not in the past).
• Moving average price: Recalculated to retrieve the price at the reference date.
  This method consists in retrieving the stock of the requested date by going back to the base amounts and base quantities of the current date and "replaying" backwards all the transactions that were carried out between the two dates.
• FIFO price: first in, first out (recalculated to retrieve the price at the reference date).
  This valuation method consists in determining, first, the stock quantity at the reference date, and then "retrieving" the receipt transactions which were used to load the FIFO basis until this date. The amount of the FIFO basis is thus reconstituted and the average FIFO price is determined.
  See below for the limits of this method.
• Average lot price
• LIFO price: last in, first out (available only if the reference date is not in the past)
• Product issue method (This is used to read the valuation method on the product record and to use it to calculate the cost. This makes it possible to simultaneously print products valued by standard cost and products valued by moving average price. This value is available only if the reference date is not in the past).
• Budget cost
• Simulated price

Limits of the FIFO method

• The result obtained may be slightly different than the real values of the FIFO basis at the reference date. This is due to the fact that, in the calculation of the valuation report, transactions such as delivery returns are positioned by creation order, whereas they normally take the position of what has been delivered.
   
  Example: the following transactions were created in the following order:
  • 01/01: receipt 1 of 10 units
  • 03/01: shipment 1 of 10 units
  • 05/01: receipt 2 of 10 units
  • 07/01: delivery return 1 of 1 unit
  • 09/01: shipment 2 of 1 unit which consumes the delivery return 1
  • 11/01: receipt 3 of 10 units
  
   On 10/01, the FIFO basis was composed of the receipt 2, but the valuation report considers that it was composed of 1 return unit and 9 units of receipt 1.
   
• All the receipt transactions are taken into account, be they receipts, change receipts or receipt deletions.
• The receipt adjustments are linked to the valuation method of the product-site (Costs tab). The FIFO valuation report will be coherent only if the method chosen for the product-site is the FIFO method. Otherwise, the adjustments are not taken into account.

• Amount not absorbed (field AMTDEVFLG)

This check box can be selected to calculate the amount not absorbed of the chosen products and to display it on the report.
The result obtained is the sum of the amounts not absorbed of all transactions from the calculation start date to the reference date.
The calculation start date must be specified.

• Calculated start date (field AMTDEVDAT)

This specifies from which date onward the amount not absorbed must be calculated.

• Reporting currency (field RPTCUR)

This check box can be selected to value the stock in the reporting currency declared at folder level.

• Detail printing (field DETFLG)

This check box can be selected to request a detailed print (STOCK12D report; otherwise, the report printed is STOCK12G).
The detailed report displays for each product, lot, location, the lot value calculated as a function of the chosen valuation, the lot quantity in stock and packing unit. This choice is available only if the reference date is not in the past.

• Accounting date (field ACCDATFLG)

Select Accounting date to use the actual accounting date as a filter with respect to the entered Reference date .
For example, if the entered reference date is 01/03/2017 and you select Accounting date, the considered movements are the ones with an accounting date lower than or equal to 01/03/2017. If you do not select Accounting date, the considered movements are the ones with an allocation date lower than or equal to 01/03/2017.

• From site (field STOFCYSTR)

Enter or select the site range in these fields.

• To site (field STOFCYEND)

• From warehouse (field WRHSTR)

The presence of this box is subject to the activity code WRH.
This concerns the start warehouse used to select the records to be processed.

 The warehouses indicated must be linked to the sites selected.

• To warehouse (field WRHEND)

The presence of this box is subject to the activity code WRH.
This concerns the end warehouse used to select the records to be processed.

• Category Start: (field TCLCODSTR)

The first category used to select the records to process.

• Category end: (field TCLCODEND)

The last category used to select the records to process.

• From product (field ITMREFSTR)

Enter the selection start product number. The product ranges limit the adjustment to these products only.

• To product (field ITMREFEND)

Enter the selection end product number.

• From valuation method (field VLTSTR)

Start range of the valuation methods that must be applied to the products to be selected for the report.

• 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)

The start buyer allowing the selection of the entries to be processed.

• To user (field BUYEND)

The end buyer allowing the selection of the entries to be processed.

• field TSICODSTR

The first statistical groups used to select the entries to process.

• field TSICODEND

The last statistical groups used to select the records to process.

• Site (field TOTFCYFLG)

Check this box to calculate the sub-total by site.

• Warehouse (field TOTWRHFLG)

Check this box to calculate the sub-total by warehouse.
The sub-totals by category, product, lot, user, and statistical groups are then prohibited.

• Category (field TOTTCLFLG)

Check this box to calculate the sub-total by category.

• Product (field TOTITMFLG)

Check this box to calculate the sub-total by product.

• Lot (field TOTLOTFLG)

Check this box to calculate the sub-total by lot.

• User (field TOTBUYFLG)

Check this box to calculate the sub-total by user.

• field TOTTSIFLG

Check this box to calculate the sub-total by statistical group.

• Allow A (field AAASTA)

Check this box to select the lines associated with this stock status.

• Allow Q (field QQQSTA)

• Allow R (field RRRSTA)

• Transferred (field TRAFLG)

Tick the box to include what is currently in transfer in the stock (inter-site receptions that have not been carried out on the other sites)

• Destination (field NPRDEN)

Enter the document or report destination.
The destination must exist in the Destinations table, which is where its characteristics are defined (issue type, printer, server etc.).

• Server (field NPRSRV)

This field is used to define the print server.
This setup is sent at the print request from a Crystal Reports report.

• Printer (field NPRIMP)

Default printer.

• File (field FICHIER)