Field help (CONSBAG4)

The "Customer since", "Last quote, order, shipment, invoices"fields are for the Bill-to/Sold-to customer for the Company/Site combination. The "Last payment, doubtful receipt and reminder" fields are for the paying-customer for the Company/Site combination. They can be justified via right click.

"Highest reminder level":It is the maximum reminder level observed for the Pay-by customer.

"Number of doubtful receipt entries"  (respectively "doubtful receipt entry"): It is the number (respectively, cumulated amount) of returned, unsettled payments entered via the entry of doubtful receipt entries, independently of the question about what is going to happen later to these doubtful receipt entries.

"Average payment time": This is an average, which is derived from the difference in number of days between the invoice accounting date and the payment date.

"Early/late payment": This is an average, which is derived from the difference in number of days between payment date and the due date of the invoice. A case of late payment is not signalled, the inverse case where the customer pays in advance of the due date, the number of days will be preceded by a "-" sign.

Not paid / average lateness : expresses for the late and unpaid invoices, the average number of days late. A case of late payment is not signalled, the inverse case where the customer pays in advance of the due date, the number of days will be preceded by a "-" sign.

For instance:

BP situation with a pivot date of 03/03/2005 :

Average payment time : [(58 days*100)+( 57*200)] / 300 = 57,33 days is the average payment time.

Early/late payment : [(29 days*100)+(28*200)] / 300 = 28,33 days is the average payment lateness with respect to the due date of the invoices.

Not paid / average lateness : [(27 days*300) /300] = 27 days is the average lateness for late and unpaid invoices on the day the inquiry is made. The INV004 is excluded from the calculation because the due date is later than the inquiry date.

The summary of the commercial actions for the sold-to BP can be viewed in the "actions" section:

- First contact date : first commercial action carried out and the type.

- Date of last contact : most recent commercial action carried out and the type.

- Next contact : next commercial action to be carried out and the type.

"Order movement history" and "loan order"represent the sum of the orders received from this partner since they became a customer.