Post work order cost to G/L

  • Updated

Every posting to a work order creates work order value entries. You transfer these costs to the general ledger (G/L entries) with the Post Work Order Cost to G/L report for many work orders at once, or with the Post to G/L action for a single work order. If Automatic Cost Posting is enabled in the Work Order Management Setup (General FastTab), maintool posts the costs as soon as the consumption is posted.

Prerequisites

  • The work order has at least the status Execution and is not blocked.
  • The posting setup is complete: the work order posting setup and the work order dimension setup contain the combination of work order posting group and gen. prod. posting group with all required accounts. See Posting setup – overview.
  • The Work Order Post … Cost fields in the Source Code Setup are filled in. See Source codes for work order management.

What is posted

  • maintool posts the amounts of the work order value entries that are not yet in the general ledger. Amounts that have already been posted are not posted again; if an amount has changed, only the difference is posted.
  • maintool posts some costs only if the corresponding switch is enabled in the Work Order Management Setup (General FastTab):
    • Resources: Posting Resource Costs to G/L
    • Non-inventory items: Posting Non-Inventory Item Costs to G/L
    • Detail costs and rounding differences: Posting Detail Costs to G/L
    • Expected costs from purchase documents: Expected Cost Posting to G/L
  • maintool also posts adjustment entries created when work order entries are adjusted to the adjusted unit costs of items (Adjustment flag). See Reclassify and readjust postings.
  • The G/L entries receive the work order no., the budget name and the budget position of the value entry. Posting date and document date come from the value entry unless you choose otherwise in the report.

Post costs with the report

  1. Search for Post Work Order Cost to G/L and open the report.
  2. If needed, set filters on Posting Date and Work Order No. on the Post Work Order Value Entry to G/L FastTab. Without filters, the report includes all work orders with open amounts.
  3. On the Options FastTab, select in Post with Posting Date from:
    • Entry: each G/L entry receives the posting date of its value entry.
    • Actual Input: all G/L entries receive the date from the Posting Date field.
  4. In the same way, select the source for the document date in Post with Document Date from and, for Actual Input, enter a Document Date.
  5. Leave Post disabled at first and run the report, for example with the preview. You receive the test report (see below).
  6. If the test report is correct, run the report again with Post enabled.

Result: maintool posts the costs to the general ledger per work order. The report lists the posted lines per work order. Work orders that are blocked or still have the status Planning are skipped, and the report shows the message Work Order is blocked. or You can not post any Work Orders to G/L, if their Work Order Status is lower than Execution.

Test report

If Post is disabled, the report does not post anything. The heading is then Test Report (Not Posted). For each work order you see the lines maintool would post: account no., debit and credit amount, posting date, document no., work order posting group and the value of the first global dimension. If an account or other information required by the posting setup is missing, the test report already stops with an error message about that field. This way you find gaps before anything is posted.

Post a single work order: Post to G/L

  1. Open the work order and choose the Post to G/L action (or F9).
  2. Select an option:
    • Post: posts the open costs of the work order.
    • Post and report Work Order finished: posts and then sets the work order to Finished.
    • Post and Complete Work Order: posts and then sets the work order to Closed.

maintool posts with the posting and document dates of the value entries and reports Work Order has been posted. or, if nothing is open, There is nothing to post. The status change runs the same checks as Status Change, see Finish and close a work order.

The cards in Closed Work Orders and Canceled Work Orders also offer Post to G/L. There, maintool asks Do you want to post Work Order …? and posts after Yes without changing the status. This way you can post, for example, costs from a late purchase invoice.

Automatic cost posting

If Automatic Cost Posting is enabled, maintool posts the open costs of a work order to the general ledger as soon as you post to that work order, for example a work order feedback, a line in the work order journal or a purchase document. The report and Post to G/L then usually find nothing left to post.

Amounts that were already open when you enabled the setting are posted only with the next posting to the same work order. To clear all work orders at once, run the report once after enabling the setting.

General journal postings with account type Work Order

You can post costs that do not come from maintool directly to a work order in the general journal. To do so, select Work Order as the Account Type and a G/L account as the balancing account (or vice versa). The following applies:

  • The Document Type is blank, the work order is not blocked and has a status between Execution and Closed. maintool checks this as soon as you enter the work order no. as the account and copies the description and dimensions of the work order to the line.
  • The combination of the work order's posting group and the line's gen. prod. posting group exists in the work order posting setup.
  • maintool posts the G/L entry to the Account No. of the work order. If it is blank, maintool uses the Other Expenses account of the work order posting setup.
  • In addition, a work order ledger entry of type G/L Account with value entries is created. The costs therefore appear in the statistics and the budget of the work order.

Because these costs are already in the general ledger when the general journal is posted, the work order cost posting does not post their direct costs again.

If item unit costs have changed, adjust them before posting to the general ledger, for example with the Adjust Cost - Item Movements report. See Reclassify and readjust postings.

Related articles

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request