Stock valuation report

• Company (field CPY)

Enter the company code or use the Look up tool to search for and select the code.

• Costing mode (field CSTCOD)

Leave as Primary issue method, the default valuation method, to run this report based on the valuation method defined on each product-site record selected for this report.

Alternatively, select from the following:

• Standard cost: The stock value is based on the fixed cost for the fiscal year that applies to the entered reference date.
• Revised standard cost: The stock value is based on the revised standard cost that applies to the entered reference date.
• Last cost: The stock value is based on the actual cost of the last stock transaction.
• Moving average cost: The stock value is based on the average value of the stock on hand on each of the reference dates selected for the report.
• FIFO cost: The stock value is based on the first in, first out method of turnover using the unit cost of each stock movement that occurred during the entered reference dates.
  See Limitations: FIFO cost below.
• Average lot cost: The value of stock is based on the average value of each lot and sublot received into stock on each of the reference dates selected for the report.
• LIFO cost: The stock value is based on the last in, first out method of turnover using the unit cost of each stock movement that occurred during the entered reference dates.
• Budget cost: The stock value is based on the budgeted standard cost for the fiscal year that applies to the entered reference date.
• Simulated cost: The stock value is based on the simulated standard cost that applies to the entered reference date.
• Secondary issue method: The value of stock is based on the secondary valuation method defined for the valuation method defined on each product-site record.
  To apply this valuation method the Accounting date check box must be selected.

You must leave the accounting reference dates as today's date, the default date, to apply the following valuation methods: Last cost, LIFO cost, Budget cost, Simulated cost.

Sage advises that the valuation method defined on each product-site record must match the Costing mode you set for this report, if this report is based on an average costing method such as Moving average cost, Average lot cost, FIFO cost or LIFO cost.

Limitations: FIFO cost

The FIFO value of stock calculated for this report might be slightly different from the actual FIFO value of the stock for the selected reference dates. The results can differ when transactions such as customer returns are entered in date order which changes their position in the FIFO queue.

Example

Transactions are entered in the following order:

• 01/01: Receipt 1 for 10 units.
• 01/03: Shipment 1 of 10 units.
• 01/05: Receipt 2 for 10 units.
• 01/07: Return 1 of 1 unit.
• 01/09: Shipment 2 of 1 unit.
  This shipment consumes the returned unit.
• 01/11: Receipt 3 for 10 units.

On 01/10 the FIFO basis comprised Receipt 2, however the valuation report only considered 1 returns unit and 9 units from Receipt 1.

All receipt transactions are taken into account for the valuation, whether they are receipts, change receipts, or deleted receipts.

Receipt adjustments are linked to the valuation method defined for the product-site record. The valuation method defined on each product-site record must therefore have a FIFO valuation method otherwise receipt adjustments are omitted from the report.

• Accounting date (field ACCDATFLG)

Select this check box to use today's date to filter the transactions selected for this report by the actual accounting date of the transaction.

For example, today's date is June 1st. This is the reference date. If you select this check box, all transactions with an accounting date on or before June 1st this year will be included in the calculations for this report. However if you leave this check box clear, all transactions with an allocation date on or before June 1st this year will be included in the calculations for this report.

• Start date (field STRDAT)

This field identifies the earliest date of the transactions that can be included in the calculations for this report.

This field is only available if the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

• End date (field REFDAT)

This field identifies the latest date of the transactions that can be included in the calculations for this report. It is set to today's date, by default. The report will reflect the calculated value of stock from the records selected for the report as of today.

You can change the default date to any date prior to today. The report will reflect the calculated value of stock from the records selected for the report up to and including the selected date:

• If the Accounting date check box is selected, all transactions with an accounting date (ACCDAT) on or before the selected date will be included in the calculations for this report.
• If the Accounting date check box is clear, all transactions with an allocation date (IPTDAT) on or before the selected date will be included in the calculations for this report.
  If the Accounting date check box is clear, the transaction creation date (CREDAT) is applied to price adjustment movements, and to value change movements (and not the allocation date (IPTDAT)) if the Adjust issues cost field defined on the valuation method defined for the product-site record is set to No.
  

Sage advises that you set theCosting mode to eitherPrimary issue method orSecondary issue method if you change this date from the default of today's date. Additionally, you must define aStart date if theAccounting date check box is selected, and theCosting mode is set toPrimary issue method orSecondary issue method.

• Amount not absorbed (field AMTDEVFLG)

Select this check box 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)

Select this check box to value the stock in the reporting currency declared at folder level.

• Detail printing (field DETFLG)

Select this check box for a detailed report.
This check box is only available if the accounting reference dates are set to today's date, the default date.

When the Accounting date check box is selected, and the Costing mode is Primary issue method, the detail report includes details on receipts and issues between the report start and end dates, and breaks down the data by lot, receipt date, or version where applicable. The summary version groups by product only, and includes transaction quantity totals.

For all other cases the detail 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.

• From site (field STOFCYSTR)

Filter for results within a range of sites defined on the selected company. For a single site, enter the same site in the From site and To site fields.

• From warehouse (field WRHSTR)

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

These fields are not available for entry when the Accounting date check box is selected, and the Costing mode field is set to Primary issue method or Secondary issue method.

• Category Start: (field TCLCODSTR)

Filter for results within a range of categories. For a single category, enter the same category in the Start/from category and To/end category fields.

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

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

• From accounting code (field ACCSTR)

Filter for results within a range of accounting codes. For a single accounting code, enter the same code in the Start/from accounting code and To/end accounting code fields.

These fields are only available if the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

• From buyer (field BUYSTR)

Filter for results within a range of buyers. For a single buyer, enter the same code in the Start/from buyer and To/end buyer fields.

These fields are not available for entry when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

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

These fields are not available for entry when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

• Site (field TOTFCYFLG)

Select this check box to calculate subtotals by site.

• Version (field TOTVERFLG)

Select this check box to calculate subtotals by product versions.

This option is only available when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

• Warehouse (field TOTWRHFLG)

Select this check box to calculate subtotals by warehouse.
The subtotals by category, product, lot, user, and statistical groups are then prohibited.

This check box is only available when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

Selecting this check box can negatively impact performance if you have a high number of stock transactions. To improve the runtime you should reduce your report selection criteria as much as possible.

• Category (field TOTTCLFLG)

Select this check box to calculate subtotals by category.

• Product (field TOTITMFLG)

Select this check box to calculate subtotals by product.

• Lot (field TOTLOTFLG)

Select this check box to calculate subtotals by lot.

• Accounting code (field TOTACCCOD)

Select this check box to calculate subtotals by accounting code.

This option is only available when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

• Buyer (field TOTBUYFLG)

Select this check box to calculate subtotals by user.

This option is not available when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

• field TOTTSIFLG

Select this check box to calculate subtotals by statistical group.

This option is not available when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method.

• Allow A (field AAASTA)

Select this check box to select transaction lines associated with this stock status (Accepted (A), in Quality control (Q), Rejected (R)).

When the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method, only the Transferred option is available.

• Allow Q (field QQQSTA)

• Allow R (field RRRSTA)

• Transferred (field TRAFLG)

Select this check box to include stock that is currently being transferred, that is, where an intersite transfer has not been completed.

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