If you invoice work from a work order to a customer, you create the sales documents directly from the work order: a quote from the planning lines or an invoice from the posted consumption and from sales items, that is, flat rates that you plan in the work order. For several work orders of one customer, you can alternatively get the consumption in a sales invoice.
Prerequisites
- The work order is not blocked.
- Quote: The work order has planning lines and is not Canceled. A quote is already possible in the status Planning.
- Invoice: Depending on the Invoicing Method, consumption that has not yet been invoiced is posted to the work order (work order ledger entries with a Chargeable Quantity), or the work order has lines of type Sales Item that have not yet been invoiced. The work order has a status from Execution to Closed.
- If Further Job Costing is enabled in the work order and a Sales to Customer No. is entered, maintool suggests this customer, see Fields of the work order card.
Three ways at a glance
| Action | Where | Based on |
| Create Sales Quote | Work order: Lines FastTab > Functions or action on the card | Planning lines of the work order |
| Create Invoice or Create Sales Invoice | Work order: Lines FastTab > Functions or action on the card | Posted consumption and/or sales items of the work order, depending on the Invoicing Method |
| Get Work Order Consumption | Sales invoice | Posted consumption of all work orders of the customer |
Create a quote
- Open the work order.
- Choose the Create Sales Quote action. If only individual lines are to be included in the quote, select them on the Lines FastTab and choose Functions > Create Sales Quote there.
- Specify whether a new quote is created:
- New quote: Turn on Create new Document. Check the Customer No. Enter your own Document No. or select a number series in No. Series. If both fields remain empty, Business Central assigns the number from the number series for quotes.
- Add to an existing quote: Leave Create new Document turned off and select the quote in Document No. The list shows the quotes of the entered customer.
- Turn on Transfer Price from Work Order Line if required (see "Prices").
- If you chose the action on the Lines FastTab, turn on Create Quote from marked lines if only the selected lines are to be transferred. Otherwise, maintool transfers all lines.
- Choose OK.
The message Quote … was created! or The System created new quote lines for Quote …! appears.
Which lines are included in the quote
- Lines of type Item, External Service and Sales Item become quote lines of type Item, lines of type Resource become resource lines with the Work Type Code of the planning line.
- Text lines with a standard text in No. become text lines.
- Lines of type Resource Group and text lines without a No. are not transferred.
- maintool transfers unplanned lines like planned lines, see Enter planning lines.
- The planned Quantity of the line is transferred, regardless of what has already been reported.
- Item and resource lines get the Work Order No. Their dates are based on the execution date of the planning line; location, bin and customer price group also come from the planning line.
- Each line gets the Description and Description 2 of the planning line. If a Language Code is specified in the quote and an item translation exists for the item, maintool translates Description and Description 2 for item, external service and sales item lines, provided they were not changed in the planning line. maintool transfers changed texts unchanged.
maintool does not check whether lines are already included in a quote. If you run the action again, the lines are created a second time.
Available from version 20260800.0: Unplanned lines are no longer skipped when creating a quote.
Create an invoice from the work order
You specify what is included in the invoice with the Invoicing Method: the posted consumption, meaning work order feedbacks and postings in the work order journal, the lines of type Sales Item of the work order, or both. maintool does not invoice other planning lines.
- Open the work order and choose the Create Sales Invoice action, or on the Lines FastTab choose Functions > Create Invoice. Both actions take the entire consumption of the work order into account; selected lines are irrelevant.
- In the Invoicing Method field, select what is invoiced:
- Time and Material (default): the posted consumption.
- Fixed Price: the lines of type Sales Item.
- Mixed: both.
- As with the quote, specify whether a new invoice is created with Create new Document or whether you add to an existing invoice in Document No.
- If only consumption from a certain period is to be invoiced, enter Date from and Date to. The filter applies to the posting date and only if both fields are filled in. It does not apply to sales items.
- Turn on Transfer Price from Work Order Value Entries if required.
- Choose OK.
The message Invoice … was created! or The System created new invoice lines for Invoice …! appears.
An invoice line is created for each Work Order Ledger Entry with the Entry Type Consumption and a Chargeable Quantity: resources as a resource line, items and external services as an item line, G/L accounts as a G/L account line. The line gets the chargeable quantity, the Work Order No. and the entry in the Applies-to Work Order Entry field. Location and bin come from the entry.
For each line of type Sales Item, an invoice line of type Item is created with the quantity that has not yet been invoiced: the Quantity of the line minus the quantity that is already on an unposted sales invoice or has already been invoiced and posted. The invoice line gets the Work Order No., the Line No. (Work Order), the unit of measure, the location as well as the Description and Description 2 of the line; its dates are based on the execution date of the line. If a Language Code is specified in the invoice and an item translation exists, maintool translates Description and Description 2, provided they were not changed in the line. The line does not need an Applies-to Work Order Entry.
Only invoice lines that maintool created in this way from a sales item line count as invoiced. Flat rates that you enter yourself in a sales invoice or invoice using a quote do not count.
Available from version 20261000.16: Work order lines of type Sales Item and the Invoicing Method field in Create Sales Invoice. Before that, Create Sales Invoice only invoices the posted consumption.
Get work order consumption in the sales invoice
With this action, you combine the consumption of several work orders of one customer in one invoice.
- Create a sales invoice for the customer or open an existing one.
- Choose the Get Work Order Consumption action.
- In the Get Work Order Usage dialog, the Sales to Customer No. filter is preset with the customer of the invoice. Add further filters for the work orders if required, for example the No.
- Turn on Transfer Prices from Work Order Value Entries if required and choose OK.
maintool adds lines for all consumption entries with a chargeable quantity from the filtered work orders, structured as with Create Invoice.
Add standard invoice text items
You invoice flat rates, for example a maintenance flat rate, with standard invoice text items. If you plan them in the work order as a line of type Sales Item, maintool transfers them with Create Sales Quote and with Create Sales Invoice (invoicing method Fixed Price or Mixed), see Enter planning lines. Alternatively, add them in the quote or invoice as a line of type Item and enter the Work Order No. in the line. If the item is set up as a non-inventory item, no Applies-to Work Order Entry is required for it. To learn how to create these items, see Set up standard invoice text items.
Other lines that you give a Work Order No. yourself in a sales invoice need an Applies-to Work Order Entry when posting if they are resources, inventory items, service items or non-inventory items without a maintool Item Type. G/L account lines do not need one.
Prices
- Transfer Price from Work Order Line (quote): The quote line gets the Unit Price of the planning line. If it is 0, maintool determines the price with the sales price calculation.
- Transfer Price from Work Order Value Entries (invoice): The invoice line gets the unit price from the work order value entries of the consumption.
- Invoice lines from sales items always get the Unit Price of the line in the work order, regardless of this option. If it is 0, maintool determines the price with the sales price calculation.
- Without these options, Business Central determines the prices as in any sales line.
- A new document gets the Currency Code and the Customer Price Group of the work order. Prices including VAT are not possible: an existing document that you add to or post must not have prices including VAT.
Dimensions, posting groups and credit limit
- A new document gets the dimensions of the customer in the header, supplemented by the dimensions of the work order.
- Lines with a Work Order No. also get the dimensions of the work order, and lines with an Applies-to Work Order Entry additionally the dimensions of the entry. For the same dimension, the value of the work order or entry applies.
- If Transfer to Sales is enabled in the work order posting group of the work order, the line takes the Gen. Bus. Posting Group and the VAT Bus. Posting Group from the work order posting group. You find the setup on the Work Order Posting Groups page.
- If Check Credit Limit is enabled in the Work Order Management Setup (Sales FastTab), maintool checks the credit limit of the customer from the Sales to Customer No. of the work order before creating the quote or invoice.
Result
- Quotes and invoices are normal sales documents. You edit and post them as usual in Business Central.
- In the work order, you find the lines with the actions under Sales Documents: Quotes, Invoices, Posted Invoices, Posted Credit Memos and Quotes Archive. The number is also shown in the Work Order History FactBox, see FactBoxes of the work order card.
- When the invoice is posted, maintool posts a work order ledger entry with the entry type Sales to the work order for each line with a Work Order No. The chargeable quantity of the applied consumption entries is reduced accordingly. Consumption that has already been invoiced is therefore not retrieved again. Likewise, maintool does not invoice sales items again that have already been invoiced or are on an unposted sales invoice.
Messages
| Message | Cause |
| Please select a Customer! | Create new Document is turned on, but the Customer No. is missing. |
| Please select a No. Series or choose your own number! | Neither Document No. nor No. Series is filled in, and the number series for quotes or invoices is missing in the sales setup. |
| Please select an existing Quote! | Create new Document is turned off, but no document is selected in Document No. The message also appears for the invoice. |
| The Quote … already exists! | The own Document No. you entered is already used by a quote. Choose a different number. |
| There is nothing to require! | The work order has no lines that can be transferred to the quote. |
| There is nothing to invoice! | Depending on the Invoicing Method, there is no consumption with a chargeable quantity (if applicable in the selected period) and there are no sales items that have not yet been invoiced. |
| The sales items of this work order are already on the unposted sales invoice … | With the invoicing method Fixed Price or Mixed, there is nothing to invoice because the sales items are already on this invoice. Post the invoice or delete the lines from it. |
If the work order is blocked or its status does not fit (see prerequisites), maintool stops with an error message for the Blocked or Work Order Status field.
Related articles
- Set up standard invoice text items
- Create and post a work order feedback
- Create a purchase quote or purchase order from a work order
- Fields of the work order card
Related to