Apply purchase invoices to work order ledger entries

  • Updated

maintool also posts purchase lines with a Work Order No. as work order ledger entries: the receipt results in an entry with the entry type Consumption, the invoice in an entry with the entry type Purchase. So that the invoice settles the correct consumption entry and a credit memo the correct invoice, maintool links the document line to the existing entries. This work order entry application usually runs automatically. If it is missing, you apply the entries yourself in the purchase line.

When a manual application is necessary

maintool applies automatically in these cases:

  • Receipt from a purchase order: The consumption entry is linked to the order line and settled when you post the invoice in the purchase order.
  • Purchase invoice using Get Receipt Lines: maintool links the consumption entries of the receipt to the invoice line.
  • Purchase invoice without a purchase order: When you post, the consumption entry is created together with the purchase entry.
  • Purchase credit memo using Copy Document from a posted purchase invoice or using Create Corrective Credit Memo in the posted purchase invoice: For lines with Work Order No. and Line No. (Work Order), maintool links the purchase entries of this invoice.

You mainly have to apply manually for a purchase credit memo with a Work Order No. that you have entered yourself, and for a copied credit memo line without a Line No. (Work Order). In general: If posting stops with the message Found no Apply of Work Order Entries., the application is missing.

Prerequisites

  • The purchase invoice or credit memo has the status Open.
  • The line has the type Item or G/L Account, a Work Order No. and no negative quantity. Without a Work Order No., the action is not available.

Apply entries

  1. Open the purchase invoice or purchase credit memo and select the line with the Work Order No.
  2. In the lines, choose the Apply Work Order Entries action.
    The Apply Work Order Entries page shows the entries that match the line: same work order, same Line No. (Work Order), same number and same location, variant and bin.
    • For an invoice: consumption entries that are not yet completely invoiced.
    • For a credit memo: purchase entries with an invoiced quantity.
  3. Select the entries that you want to apply and choose Set Applies-to ID (F7).
    Applies-to Doc. No. and Applies-to Doc. Line No. now show your document line. At the bottom, you see the Quantity of the line, the Applied Quantity and the Remaining Quantity.
  4. Apply as much quantity as you invoice or credit, and close the page.
  5. Post the document.

To undo an application, select the applied entry and choose Set Applies-to ID again. If you change Work Order No. or Line No. (Work Order) in the purchase line or delete the line, maintool also undoes the application.

Result

  • Invoice: maintool posts the purchase entry and settles the applied consumption entries (Invoiced Quantity).
  • Credit memo: maintool posts a purchase entry for the credit memo, links it to the applied purchase entries of the invoice and reduces the invoiced quantity of the related consumption entries. For item lines, maintool reverses the work order consumption before the return to the vendor and applies the return to this reversal, not to another inbound entry at the location.
  • If Exact Cost Reversing Mandatory is enabled in the Purchases & Payables Setup, purchase lines with a Work Order No. are exempt from this check, like project lines. If several purchase entries are applied to the credit memo line, maintool applies the return according to FIFO.
  • With Applied Entries on the Apply Work Order Entries page, you can see what an entry is applied to.

Messages when applying and posting

Message Cause and solution
Found no Apply of Work Order Entries. No entry is assigned to the line. Apply the entries as described above.
Quantity to Apply could not be bigger than the Applied Quantity from Work Order Ledger Entry. The quantity that you invoice or credit is greater than the applied quantity. Apply further entries or reduce the quantity in the line.
The current Entries to apply are using different … The selected entries have a different Account No., Work Order Posting Group or Gen. Prod. Posting Group. Apply these entries in separate document lines. If the global dimensions differ, maintool only asks whether you want to apply anyway.

The Apply Work Order Entries action is also available in the lines of a purchase order. Entries of the type G/L account can only be applied with invoices and credit memos.

Related articles

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request