FIC - M3 BE Financial Controlling

CAC - Cost Accounting

  • 'Internal Account Entry. File' (CAS970)

    This function archives internal accounting entries.

    Note: Internal account entries with an error code of blank, 0 or 9 can be archived. Internal account entries with an error code of blank must have been transferred to general ledger to be included.

    Soft selections can be made on 'Accounting/Transaction date' and on internal account entries with error code 3. The Accounting/Transaction date field indicates the date up to which internal transactions are archived. The date refers to either the accounting date or the transaction date, depending on the type of transaction. A combination of accounting date and transaction date is used for all transactions that have been transferred to the general ledger, that is, both these dates may not be later than the date selected for the archiving. For transactions with error status 0, 3 or 9, the date used is the transaction date. The latter is also used if the company does not use the M3 General Ledger module.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    CINACC TF: Internal accounting entry
    CRACTR TF: Various accounting transactions
  • 'Average Cost History. Archive' (CAS975)

    This function archives average cost history transactions.

    Soft selections can be made on Transaction date, Facility, and Item. The Accounting/Transaction date field indicates the date up to which internal transactions are archived. The date refers to either the accounting date or the transaction date, depending on the type of transaction. A combination of accounting date and transaction date is used for all transactions that have been transferred to the general ledger, that is, both these dates may not be later than the date selected for the archiving. For transactions with error status 0, 3 or 9, the date used is the transaction date. The latter is also used if the company does not use the M3 General Ledger module.

    This function archives the records in the following tables:

    Table Description (TF=Transaction File)
    FCAAVP TF: Average cost history
    FCAAVC TF: Average cost history - Attribute cost
  • 'Order Costing. File' (CAS980)

    This function archives order costing transactions. Selections are made on 'Finish date'.

    Note: Order costing must have Status 1 or 3 in (CAS310) to be included.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    CPOHED TF: Order Costing head
    CPOMAT TF: Order Costing Material lines
    CPOOPE TF: Order Costing Operation lines
    CPOPRO TF: Order Costing Product cost
    CPOCOA TF: Order Costing Material components
    CPOCOS TF: Order Costing Semi finished material
    CPOCOM TF: Order Costing Operation components

MUC – MUC - Multiple Unit Coordination

The 'Int Deliveries btw Div. Archive/Delete' (MFS290) function archives internal deliveries between divisions found in 'Internal Transfer. Display btw Divisions' (MFS200).
Note: Only deliveries where the reference order has already been archived are included. Excluded records from the latest archive run can be found in 'Archiving Error Log. Open' (AMS350).

Soft selections can be made on 'Planned dely dt' and 'Internal status'. If the user is a central user, soft selection can also be made on 'Fr division'.

This function archives the records in these tables:
Table Description (TF=Transaction File)
CMUFTR Int dely between divisions
MSYTXH Text head
MSYTXL Text line

PCO - Product Costing

This 'Product Costing. Archive/Delete' (PCS270) function archives or deletes product costings. Use setting 'Archive/delete' on panel (PCS270/E) to indicate if the records will be deleted. The valid alternatives are:

  • 1 = Archive
  • 2 = Deletion

If Alternative 1 is selected, the costing records will be also be deleted after archiving is completed.

Note: If you select alternative 1 in the Archive/delete field, the values are archived before they are deleted. The only exception is unanswered costing warnings; they can only be deleted, not archived.

The setting 'Deletion scope' has the following valid alternatives:

  • 1 = Unanswered costing warnings and saved costing data from the product structure. (MCCWAR, MCBOMS, MCCMAT, MCCSEM, MCROUS, MCCOPE, MCHEAS)
  • 2 = Same as alternative 1, with the addition of the total per costing component on all levels. (MCCOMA, MCCOML, MCCOPU)
  • 3 = Same as alternative 2, with the addition of the total amount record for the costing ID. This is the amount displayed in (PCS300/E). (MCHEAD)

If you select alternative 1, you can still display the costing model with its costing component values in (PCS300). However, no information on the product structure used as input for the costing is available.

If you select alternative 2, you can display the costing model head with its total cost in (PCS300) but no other data is available.

If you select alternative 3, all costing model values are deleted.

TAC - Time Accounting

This 'Time Report. File' (TAS800) function archives time accounting transactions. Selections are made on Employee ID, Time report number, and Change date.

This function archives the records in these tables:

Table Description
OTHEAD Time accounting transactions - header
OTTRAN Master file for time acc transactions