The purpose of this function is to check all invoices and credit memos coming from the suppliers.
After recording invoices, you can generate the corresponding accounting entries directly by clicking Validation, or program the validation for later using the corresponding function.

SEEREFERTTO See the documentation on the Invoice validation for further information.

Various elements can be managed by this option:

  • The invoices, referring to orders and/or receipts. These invoices are checked by reconciliation with:
    • receipts already entered,
    • orders not received yet,
    • orders without receipts (general purchases).
  • Additional invoices, which can be allocated to ordered products (except on subcontract orders), or to shipped, received and/or invoiced products. These invoices can only come from:
    • the supplier of the goods in the case of an additional invoicing, for instance,
    • a business partner other than the supplier of the goods, in which case the invoices must be assigned to products (e.g.: for freight charges or customs expenses).
  • Credit memos. It can be:
    • a total credit memo. This credit memo corresponds to an invoice cancellation. The stock valuation of products remains the same as the receipt valuation.
    • a partial credit memo in the event of a dispute on the invoiced price or invoiced quantity. The stock valuation is adjusted.
    • a credit memo on return related to a recorded return. For information, a credit memo on return linked to a supplier receipt always impacts the stock entry of the original receipt (and not the stock issue relative to the return).

When the Fixed assets module is managed in the folder, the invoice validation triggers, when all the conditions are met, the automatic creation of an expense for each purchase invoice line (the expense creation terms are detailed below). The Linked expenses list displays the generated expenses. After selecting an expense in this list, you directly access the expense management function.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The layout of the entry screen depends on the setup of the chosen transaction.

If only one transaction is set up, no choice is provided. If several transactions are set up, a window displays the list of the transactions you are authorized to use

The recording of supplier invoices is subdivided into three stages:

  • The entry of the general information in the invoice header, including the invoicing elements (charges, freight, packing, discount, rebate etc.), the total excl. tax of the product lines and the total amount of taxes.
  • The entry of those lines that can be limited to a single taking into account, in full or in part, of the orders, receipts returns or invoices. You can easily select these entries in the dynamic lists of the selection panel.
    After taking this into account, the invoice lines are preloaded with the information on the concerned orders, receipts, returns or invoices. The manual creation of specific lines along with the modification or deletion of the preloaded lines are always an option.
    SEEINFO For additional invoices, you cannot use the selection panel lists: you can either enter the lines manually or simply preload the lines from the Actions icon.
  • Final checking with discrepancy management and potential posting or putting on hold.

Header

In this header, enter the general information of the invoice such as the invoicing site, supplier code, date, etc.

Tab Management

Tab Lines

Tab Control

Tab Costs

Examples of the impact of additional invoices on documents

The addition of additional invoices on a document directly impacts this document.
This also impacts the purchase and stock costs of the related documents, pro rata of the relevant quantities.

Additional invoice on order

1/Additional invoice of €100 for an order of 100 IPAD.
Use case: additional cost, not expected when creating the order (e.g.: a service provider adds transportation fees to your invoice).

  • Creation of an order of 100 IPAD that cost €200 each, for a total of €20,000.
  • An additional invoice of €100 is created for this order line. Follow these steps: preload the lines, select the New cost flag and enter the amount of €100. When posting the invoice, the additional invoice total and the actual purchase cost of the original order are updated.
  • When receiving the complete order line for 100 IPAD, the valuation of the goods, excluding the additional invoice, is generated, in other words, €20,000 in stock movements.
  • Closing the order line triggers the update of the valuation for the 100 IPAD by allocating the €100 included in the additional invoice to the order, increasing the cost from €20,000 to €20,100 in stock movements.
The €100 amount of the additional invoice is displayed on the order Line cost as a non-detailed cost. It is also displayed on the receipt. This amount is broken down pro rata of the received quantity if several receipts are completed. However, the additional invoice amount on the order line can only be included in the stock valuation if the order line is closed. If you partially receive this order line and close the order line, the whole additional invoice amount is allocated to the received quantity in the stock valuation.

2/Additional invoice on an order with product cost matching
Use case: cost expected when creating the order ultimately higher or lower than expected (e.g. the service provider invoices two additional days of storage on the transit warehouse where the goods are located).
  • The IPAD product has been set up with a cost structure including a product cost COST021 of €100 for the overall transport.
  • Creation of an order of 100 IPAD that cost €200 each, for a total of €20,000 (+ total of product costs COST021 of €100).
  • Creation of an additional invoice for this order line, matching the overall transport cost to €120 following these steps: preload the lines, disable the New cost flag, select the COST021 cost, select the order line and enter an amount of €120. When posting the invoice, the additional invoice total and the actual purchase cost of the order are not impacted.
    The complete receipt of the order line of 100 IPAD triggers the valuation of the goods with a receipt movement of €20,000 + total product cost COST021 of €100, for a total of €20,100.
  • In order to update the valuation and match the COST021 product cost, you must close the order line and launch the STCREG - Cost matching task to adjust stocks.
  • From the receipt line, click Cost structure detail from the Actions menu: the product cost amount COST021 is displayed with an amount adjusted to €120 (against the amount calculated to €100), the Reconciled field is set to Yes for this cost. The stock movements (CONSSMV) display the price adjustment with the €20 additional difference.
Product costs can only be matched when the product is managed with a cost structure already including the product cost when creating the order. In order to create the additional invoice with cost matching, in the line preloading screen, the New cost flag must be disabled and the cost to match of the Cost field must be defined. This information makes it possible to apply a control on the order lines when performing a picking in the selection panel. A message is displayed if the cost is not displayed on the picked order line.
In order to distribute the amount of the additional invoice, the STCREG - Cost matching task performs an adjustment but only if the order line has been closed. This task is only used in the case of cost matching.
3/ Additional invoice on order (flag New Cost = No) and deletion of a receipt.
Use case : you save an additional invoice on order (New Cost flag disabled) after performing several receipts on order.
You then delete one of the receipts. A message warns you that reconciled costs exist.
You save a new receipt.
This new receipt is valued without considering the additional invoice on order. It is valued as a normal receipt.
  • Creation of an order of 10 products with a unit price of €100, and a cost amount of €100.
    The stock cost per unit is €110.
  • Creation of a first receipt with 4 products.
  • Creation of a second receipt with 6 products.
  • Recording of an additional invoice on order (New Cost flag disabled) with an amount of €200.
    You run the STCREG batch task to refresh the cost amount and update the stock valuation.
    The stock cost per unit is now €120.
  • Deletion of the second receipt.
    The stock cost per unit of the first receipt is still €120.
  • Creation of a new receipt.
  • This new receipt is valued without considering the additional invoice. Its stock cost per unit is €110.
  • Recording of an invoice on order.
    The calculation of the stock cost per unit takes into account the cost amount for the various receipts and calculates the average unit cost of the two receipts. The calculation is as follows:
    • For the first receipt: the cost amount per unit is €20.
    • For the second receipt: the cost amount per unit is €10.
The amount of valued costs on the invoice is:
(20 * 4) + (10 * 6) = €140, corresponding to a unit amount of €14.
The stock cost per unit is therefore 100€ + €14 = €114.
The two receipts are thus valued at €114.
 
When an invoice on receipt is concerned, each invoice inherits from the cost amount of the receipt it is associated to. In this example, the product stock cost per unit for the invoice related to the first receipt would be €120, and the product stock cost per unit for the invoice related to the second receipt would be €110.

Additional invoice on shipment

4/ Additional invoice of €100 for a shipment of 100 IPAD.
Use case: new costs linked to the shipment are invoiced by a partner or supplier.
  • Creation of an order of 100 IPAD that cost €200 each, for an order line of €20,000.
  • Creation of a shipment and selection of the order line of 100 IPAD.
  • Creation of an additional invoice of €100 for this shipment line. Follow these steps: preload the lines, select the New cost flag and enter the amount of €100. When posting the invoice, the total of additional invoices and the total shipment cost of the Shipment.
  • The complete receipt of the shipment line for the 100 IPAD triggers the shipment line closing and generates the valuation of the goods for €20,000 and simultaneously allocates the additional invoice amount to the shipment for €100, for a total stock movement of €20,100.
The €100 amount of the additional invoice on shipment is recovered on the order line cost as a non-detailed cost. The additional invoice total and the actual purchase cost of the order are also updated.
If the shipment line has been received multiple times, the €100 amount on the additional invoice is broken down pro rata of the received quantity. However, this additional invoice amount on the shipment line only impacts the stock valuation if the shipment line is closed (through the complete receipt of the shipment or manual closing of the shipment line). If you partially receive this shipment line and close the shipment line, the whole additional invoice amount is allocated to the received quantity in the stock valuation.

5/ Additional invoice on shipment with product cost matching
Use case: cost expected when creating the shipment but ultimately higher or lower than expected (e.g. the service provider invoices two additional days of storage on the transit warehouse where the goods are located).
  • The IPAD product has been set up with a cost structure including a product cost COST021 of €100 for the overall transport.
  • Creation of an order of 100 IPAD that cost €200 each, for a total of €20,000 on the order line (+ total of product costs COST021 of €100).
  • Creation of a shipment and selection of the order line of 100 IPAD.
  • Creation of an additional invoice for this shipment line, matching the overall COST021 transport cost to €120 following these steps: preload the lines, disable the New cost flag, select the COST021 cost, select the shipment line and enter an amount of €120. When posting the invoice, the total of additional invoices and the actual purchase cost of the Shipment.
  • The complete receipt of the shipment line of 100 IPAD triggers the valuation of the goods with a receipt movement of €20,000 + total product cost COST021 of €100, for a total of €20,100.
  • The total receipt of the shipment line automatically triggers the closing of the shipment line.
  • In order to update the valuation and match the COST021 product cost, you must close the shipment line and launch the STCREG - Cost matching task to adjust stocks.
  • From the receipt line, click Cost structure detail from the Actions menu: the product cost amount COST021 is displayed with an amount adjusted to €120 (against the amount calculated to €100). The Reconciled table is set to Yes for this cost. The stock movements (CONSSMV) display the price adjustment with the €20 additional difference.
Product costs can only be matched when the product is managed with a cost structure already including the product cost when creating the shipment. In order to create the additional invoice with cost matching, in the line preloading screen, the New cost flag must be disabled and the cost to match of the Cost field must be defined. This information makes it possible to apply a control on the shipment lines when performing a picking in the selection panel. A message is displayed if the cost is not displayed on the picked shipment line.
In order to distribute the amount of the additional invoice, the STCREG - Cost matching task performs an adjustment but only if the shipment line has been closed. This task is only used in the case of cost matching.
 
6/ Additional invoice with no variance (no new cost and no product cost matching)
Use case: invoicing costs on a shipment with no stock valuation but with an accounting tracking.
  • Creation of an order of 100 IPAD that cost €200 each (with or without product costs).
  • Creation of a shipment and selection of the order line of 100 IPAD.
  • Creation of an additional invoice for this shipment line:
    • You can use the line preloading in order to select shipment lines using the following setup: disable the New cost flag, clear all costs (no selection) and leave the amount blank. After validating the selected shipment lines in the picking screen, enter an excluding-tax line amount on the invoice lines.
    • You can also directly select Shipment from the additional invoice origin instead of preloading lines and indicate the shipment lines to be invoiced. Enter an excluding-tax line amount on each invoice line.
  • The complete receipt of the shipment lines triggers the closing of the shipment line but does not generate any stock movement.

Reports

By default, the following reports are associated with this function:

  • PBONFAC : Invoice control notes
  • PINVOICEE : Purchase invoice list
  • PINVOICEL : Detail purchase invoice list

This can be changed using a different setup.

This setup is performed at the Customization level of the current object, by associating a report code or a print code to it.
It is possible to further specify this setup:

  • By specifying a given report at transaction entry level. If this report matches a print code, the list of reports associated with this print code is also submitted.
    The report entered at transaction entry level and the reports associated with the print code are automatically submitted in creation mode only.
  • At a more detailed level, by associating a print template with the BP. This template mentions the report to be used in priority for the printing of each document, as well as the expected number of copies.
    SEEINFOIf the number of copies is not specified, or if there is no print template associated with the BP, the number of copies defined for the Destination printer is chosen. If the number of copies is not specified for the destination printer, then a single copy is printed by default.

Specific actions

Particular cases

Distribution of footer elements on credit memos:

It is possible to create credit memos that only concern footer elements. Based on their setups, these elements can be distributed in proportion to the quantities, the weights, the volumes or the amounts.

For that purpose, it is necessary to mention on the credit memo all the invoice lines on which the invoice footer needs to be distributed. If the distribution of the footer elements is carried out in proportion to the quantities, all the lines must be given a null quantity. The distribution is then performed in proportion to the quantities on the lines of the original invoices. In the same way, if the invoice footer is performed in proportion to the amounts, a net null price must be entered for each line. The distribution is then performed in proportion to the amounts on the lines of the original invoices.

Caution, if there are lines whose quantity or amount are different from zero, the distribution will only take place in proportion to the lines whose quantity or amount is different from a null value.

Distribution of the footer elements on additional invoices:

On an additional invoice, it is possible to distribute a footer element on invoice lines. From the pre-loading screen, the user chooses the invoice lines that need to be posted.

On the other hand, like for credit memos, all the lines must be positioned to a null value or a null quantity for the distribution of the footer element ( if set up as being distributed in proportion to lines or quantities) to take place in proportion to the quantities or amounts of the lines of original invoices.

As for credit memos, if there is at least one line whose quantity or amount is different from the null value, the distribution type will only be in proportion to the lines having a value.

Over-invoicing
Credit memos on invoices when the PIHCPR - Invoice price adjustment parameter is set to With landed costs
Credit memos expressed in value and credit memos expressed in quantity

Stock adjustments concerning the cases below are explained in details in the following documentation: Basic principles for the valuation of the stocks

Error messages

Product XXXXXXXXXX: No receipt line to be invoiced
Product XXXXXXXXXX: No return line to be invoiced

Product XXXXXXXXXX: No invoice line to be invoiced

This blocking message is displayed when you manually create an invoice line after having entered the product reference, and the number or the line of the original document has not been entered. It means that for the relevant product, all the lines of the source document have been invoiced.

Line already invoiced or closed

This blocking message is displayed when you manually create an invoice line after you have entered the line number of the source document. It means that the selected line has already been invoiced or has been manually closed for products without receipt.

Order not fully signed!

This blocking message is displayed when you manually create an invoice line and the entered order is not completely signed.

The return is not validated.

This blocking message is displayed when you manually create a credit memo line and the return is not completely validated yet.

It does not belong to the same legal company

This blocking message is displayed when you manually create an invoice line and the original journal number entered does not belong to the same company as the invoicing site mentioned in the header.

Different invoicing supplier!

This blocking message is displayed when you manually create an invoice line and the invoicing supplier of the original journal entered is not the same as the invoicing supplier mentioned in the header.

Modification in process on another workstation

This blocking message is displayed when the invoice that you are trying to modify or delete is being used on another workstation. Wait until this invoice has been released or select another invoice.

$PORDER XXXXXXXXXX Modification in progress on another workstation

$PRECEIPT XXXXXXXXXX Modification in progress on another workstation
$PRETURN XXXXXXXXXX Modification in progress on another workstation

$PINVOICE XXXXXXXXXX Modification in progress on another workstation

This blocking message is displayed when the selected original entry is being used on another workstation. Wait until the record has been released or select another one. This message can also be displayed during an update. In that case, the transaction is canceled and it is necessary to re-enter the invoice in progress.

The product is on hold [Continue End]

This message is displayed when you manually create an invoice line after you have entered the product reference. It depends on the value given to the blocking code (No/Warning/Blocking) mentioned in the product-supplier. If the blocking code is set to Warning, you can Continue or Abort the creation.

No line entered. Update impossible.

This blocking message is displayed when you try to create a invoice without having entered a line.

XXX Problem when retrieving the sequence number

This message is displayed in creation mode when the read of the specified sequence number is invalid and the system has been unable to retrieve a sequence number.

There are credit memos or additional invoices. Deletion prohibited!

This blocking message is displayed when you try to delete an invoice linked to credit memos or additional invoices. You need to delete these first, before deleting the invoice.

Invoice posted, modification or deletion prohibited!

This blocking message is displayed when you try to modify or delete an already posted invoice. A posted invoice can no longer be modified.

Payments carried out, deletion prohibited!

This blocking message is displayed when you try to delete an invoice associated with recorded payments.

Social and IAS accounts can be considered as fixed assets and the product cannot be considered as a fixed asset. Do you want to create the expense upon validation?

This warning message is displayed upon validation when the following conditions are met:
The Fixed assets module is managed
The accounts are tracked
The line has a product but the product is not capitalized.
The expenditure is created by clicking on Yes. When No is chosen, the expenditure is not created without an error generation.

No expense will be created for the line. Social and IAS accounts cannot be considered as fixed assets and the product can be considered as a fixed asset. The DBS directory is in read-only mode, remote SYSDBA connections are impossible.

This warning message is displayed upon validation when the following conditions are met:
The Fixed assets module is managed
- the product is capitalized
The accounts are not tracked
When Yes is chosen, the expenditure is not created but no error is generated. When clicking No, the validation stops and an error occurs.

No expense will be created for the line. Social account not tracked and IAS account tracked (or) Social account tracked and IAS account not tracked. The DBS directory is in read-only mode, remote SYSDBA connections are impossible.

This warning message is displayed upon validation when the following conditions are met:
- The Fixed assets module is managed
- One account is tracked and the other is not
When Yes is chosen, the expenditure is not created but no error is generated. When clicking No, the validation stops and an error occurs.

'Field error' 'Invoice Type'
'IN1 [LEG 1] : Document type IN2: Record does not exist for the current legislation [LEG 1]'

This message is displayed when the legislation of the entry type linked to the invoice type does not match the invoice legislation.

No ABN number is assigned to this supplier. Please check the Supplier record before posting the invoice.

This message is displayed when the following conditions are met: the KAU - Australia activity code is activated, the AUSABNWRN - Warn supplier without ABN parameter (LOC chapter, AUS group) is set to Yes and the selected supplier is not linked to an ABN code (this code is entered on the Supplier record in the SIRET code field).

Tables used

SEEREFERTTO Refer to documentation Implementation