Purpose

Currently you can see the the total value of unpaid invoices of a customer in the field "Credit Used" in window "Business Partner" on tab "Customer".

Plan is to have two additional fields to show

• the value of all orders which have not or only partially been invoiced ("Open Order Value")

• the resulting "Total Credit" = "Credit Used" + "Open Order Value"

For some companies with long running sales contracts it is important to know how much credit in total has already been given to the customer.

Scope

Provide the ability to check overall customer credit status.

Design Considerations

The functionality shall be provided as an extension package.

Technical Requirements

Create columns C_BPartner.SO_OrderValue, C_BPartner.SO_CreditTotal
Create related fields in window "Business Partner", tab "Customer"
Create MOrderLine.calculateOpenOrderValue
Create a mechanism to trigger the method whenever a relevant state change happens:

• C_Order.DocStatus changes to "CO", "VO" , "IN", "RE", "CL", "WP"

• C_OrderLine.QtyInvoiced changes
  SO_OrderValue should be calculated as the sum of all (C_OrderLine.QtyOrdered-C_OrderLine.QtyInvoiced)*C_OrderLine.PriceActual plus taxes