Posting Work-In-Progress From Work Orders

OBJECTIVE

Used to post work-in-progress resulting from non-invoiced work orders. An Excel file is created using the Work Order Accrual Report and Export option. This file must then be imported into an Advanced Project-to-Project Transfer before the work-in-progress entry is posted.

 

PREREQUISITEs

 

Steps

Configuration – Work Order

To post work-in-progress from work orders:

 

maestro* > Projects > Maintenance > Work Orders > Configuration

 

  1. Click Accrued in the menu on the left.
  2. Complete the information for the Accrued Revenue Activity, Accrued Cost project, Accrued Cost activity and Accrued Cost group.
 

This section must be completed to prepare the accounting entry for work-in-progress for the work order.

If the accrued revenue activity is not specified, the system uses the activity specified in the original transaction on the Work Order.

  1. Click Save.

 

Define Cost Groups

To define the income group that will be used to post (credit) the work-in-progress:

 

maestro* > Projects > Maintenance > Project > Define Cost Groups

 

  1. Create the necessary Accrual Cost Groups or review existing cost groups and determine which cost groups are to be used for the accrual entry.
  2. Select each group and complete the Accrual Group field.
 

You do not need complete the Income Accrual Group field for the group code that identifies the Accrual Group.

The group used for deferred income must be a type 2 - Invoicing.

  1. Click Save.

 

Work Order Accrual Report

You can print the accrued work orders report to check the data before exporting the entry for accrued charges.

 

You can refer to help on the Work Order Accrual Report for additional information.

 

Work Order Accrual Report and Export

To export the entry used to post accrued work orders:

 

maestro* > Projects > Work Orders > Reports > Work Order Accrual Report and Export

 

  1. Complete the settings to display the report on the screen.
 

A confirmation message may be displayed if the date in the As of Date field does not match the end date of an accounting period.

  1. Click Accept.
 

The report is displayed on the screen.
  1. Close the report by clicking the Close icon.
 

A confirmation message is displayed and asks you to confirm that you want to Export the Entry for Accrued Values to Excel. Click Yes to accept. An Excel window opens with the entry displayed.

  1. Save the Excel file.
 

This saved file will be necessary for the next step.

The debit amount affects the project, activity and group defined in Configuration – Work Orders. The credit amounts affect the Accrued Revenue activity defined in Configuration if it exists. Otherwise, the activity entered in the original transaction on the Work Order is applied The group is from the Accrual Group field in Define Cost Groups.

 

Advanced Project-to-Project Transfer

To import the entry for work-in-progress from work orders:

 

maestro* > Projects > Project Costing > Processing > Adanced Project-to-Project Transfer

 

  1. Click in the Breakdown Grid with the right mouse button.
  2. Click the Import an Excel File option.
  3. Select the file to be imported and click Accept.
  4. Click Validate the Table.
 

The system displays non-existent values in red. Correct the data if necessary.
  1. Click Transfer to the Grid to import the Excel file.
  2. Click Exit to close the Import an Excel File screen.
 

The entry transferred to Project-to-Project Transfer will be Accrual if the Description column in the Excel file is not changed.

  1. Click Save.

 

See also

 

Last modification: September 20, 2024