This function is used to value the production WIP for one or more Work Orders (WO) or Subcontract Orders.

The production WIP corresponds to the value of the products in production for which the raw material has been consumed, time has been entered, and stock receipts have been carried out.
The WIP value is determined by the consumed value and the receipt value, where:

  • the consumed value represents:
    • the value of the material and semi-finished product consumed,
    • the value of the hours consumed (machine hours, labour hours),
    • the value of sub-contract receipts,
    • the value of the overheads,
  • the receipt value represents the value of the finished products booked to stock.

Note There is no backup file of the WIP value. A report can be printed at the end of the processing.

Prerequisite

See also Refer to documentation Implementation

Screen management

An intermediate screen is used to enter the selection criteria prior to the WIP valuation.

Entry screen

Selection criteria

Company (field CPY)

Enter or select in this field the company for which the WIP must be valued.
From storage 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.
To storage site (field STOFCYEND)
Entry type (field VCRTYP)

This scroll-down menu is used to specify whether the orders to be considered in the WIP valuation need to be Work Orders or Subcontract Orders.
From document no. (field VCRNUMSTR)

Enter or select in these fields the ranges of the Work or Subcontract Orders.
Note This choice depends on the document type specified in the 'Document type' field.
To document no. (field VCRNUMEND)
Closed (field MFGSTA)

This box, if checked, specifies that the WIP valuation report must include the closed Work (or Subcontract) Orders.
Costed (field MFGTRKFLG)
Cutoff date (field DATMAX)

The work (or subcontract) orders to be included in the processing will not go beyond the date specified in this field, by default the current date.
This date is the reference date for the launche of the WIP valuation report.
Formula (field FORMULE)

Printing

WIP selection (field IFAFLG)

This scroll-down menu is used to choose a WIP valuation option:

  • 'Global WIP report': this option is used to launch the WIP valuation report on all the entries in the WIP valuation table,
  • 'Posted WIP report': this option is used to launch the valuation report of the posted WIP.
Detail (field PRNCOD2)

  • When this box is not selected, the report only prints the total of the price components for the selected WOs or subcontract orders. The report prints this total site by site.
  • When this box is selected, the report prints the valuation of the WIPs, either by WO or by subcontract order, in addition to the totals at the end of the report.
    This valuation can be generated in detail or it can be summarized. If the check box "Summary" is selected, the valuation is summarized.
Summary (field PRNCOD)

This check box is only available if the "Detail by document" is requested.

  • If this check box is selected, the WIP valuation report only shows the total of the price components for all the WOs and subcontract orders processed.
    Then, several WOs/subcontract orders are printed on each page.
  • If this check box is not selected, the WIP valuation report shows the details (material, operations, overheads, sub-totals, etc.).
    Then, a single WO/subcontract order is printed on each page.

Printer

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.

Error messages

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

Site incorrect

This message appears following the control on the WO number if the site of the WO is not the one entered.

This order has not yet been the object of reporting

This message appears following the control on the WO number if the reporting flag is set to "Printed" or "In design".

This works order is closed

This message appears following the control on the WO number if the status flag for this order is set to "Closed".

The production cost has already been calculated for this order

This message appears following the control on the WO number if the status flag for this order is set to "Prod cost calculated".

provisional Product cost records exist already

This message appears after modification of the WO number if records exist for the non updated provisional calculation of the product cost (MFGCOSTW) (information purposes).

After the process, the log file can contain the following messages :

Operation... the secondary work centre is not the one planned ...

This message appears if the secondary labour work centre indicated in the operation tracking is different to the planned secondary work centre. The secondary work centre does not appear in the report.

No valuation section for this work centre ...

This message appears if the Costing dimensions of a work center is empty.

Tables used

See also Refer to documentation Implementation