R27456 Invoice - Check For Over Invoiced Quantity

Code R27456
Entity Crm.Invoicing.Invoices Entity
Name CheckForOverInvoicedQuantity
Attribute -
Layer Back-End
Events Released +
Modify NO
Action

For every line :

If 'Config.CheckForOverinvoicedQuantityInSalesOrderLinesDisabled.KeyValue '== NULL' or '!= 1'', validate that 'InvoiceLine.ParentSalesOrderLine' is not over-invoiced.





A SalesOrderLine is over-invoiced when:

  • 'SalesOrderLine.Quantity > 0' and ''SUM(InvoiceLine.Quantity[InvoiceLine.ParentSalesOrderLine=SalesOrderLine])' > SalesOrderLine.Quantity';

     

  • 'SalesOrderLine.Quantity < 0' and ''SUM(InvoiceLine.Quantity[InvoiceLine.ParentSalesOrderLine=SalesOrderLine])' < SalesOrderLine.Quantity'.



    NOTE: 'SUM(InvoiceLine.Quantity[InvoiceLine.ParentSalesOrderLine=SalesOrderLine])' is the sum of the quantity/es of the lines in all non-voided Invoices on document state Released + that refer the particular SalesOrderLine and the quantity of the current InvoiceLine.



** Description** Invoice is a primary accounting document with which a supplier (seller) documents the sale of goods, materials, services and others. Which generally means that Invoices are based on sales. That's why the quantity in the invoice can not exceed the quantity of the particular sale.

In order to make sure that the Sales Order is not over-invoiced (not only by the current invoice but in general), the system validates that the described rule is not valuated. The rule throws an error only if for the configuration key path 'CheckForOverinvoicedQuantityInSalesOrderLinesDisabled' is not configured or its key value is different from '1'. Otherwise,  the sum of the quantity/es of the lines in all non-voided Invoices on document state Released + that refer the particular Sales Order Line does not have to exceed its quantity. Sales Order Line are referred by the Invoice Lines through the field 'Parent Sales Order Line'.
Message The field 'Parent Sales Order Line' in line '{Invoice.LineNo}' refers a sales order line which quantity is over-invoiced.

Please, check if the right quantity is set in the line or if the sales order line is invoiced by other documents.



Introduced In Version 2017
Revocable NO

* For more information about the Business Rules Documentation Template and a short explanation of each column, see topic System Business Rules.

Suggest improvement to this page