How does the credit update work
目录
How does the credit update work
Skip to end of metadata
Created by Former Member on Jan 10, 2015
Go to start of metadata
Symptom
You would like to know how credit update works.
Analysis
For the necessary customizing settings please read note 18613. Also you can use report CHECK_CM to check sales documents with regard to their credit management information in one step. You can read more about this HERE.
How the credit value is calculated, you can read HERE.
The open credit values are updated in the info structures S066 and S067 when you save the document. These are:
Open sales order credit value (S066-OEIKW)
Open delivery credit value (S067-OLIKW)
Open billing document credit value (S067-OFAKW)
With the update group (maintained in transaction OB45 for the relevant credit control area) you control at which point of time in the process flow the credit value should be updated.
There are 3 possible entries for that: 12, 15 and 18.
The default setting is '12' - Update with update group 12
Update for sales orders
The open sales order values are updated in the information structure S066. When the credit value is calculated, the open schedule line quantity (VBEPD-OLFMNG) is multiplied with the item credit price (VBAP-CMPRE). The open schedule line quantity is the confirmed quantity of the schedule line that is still open for delivery. The credit price is defined in accordance with the settings in the pricing for the item. The material availability date of the schedule line (VBEP-MBDAT) defines the period in which the open sales order value is updated. You use transaction OMO1 to define the period unit for the information structures.
If an item has no confirmed quantity (VBEP-BMENG), the system does not update an open sales order value. This also occurs for documents that are blocked by the credit check. As a result of the credit block, the confirmed quantities are deleted so that an open sales order value can no longer be updated. When sales orders with a credit block are released (for example, using transaction VKM1), a new availability check is performed. If the availability check can confirm the quantities, an open sales order value is updated accordingly.
Conclusion: Credit blocked documents do not increase the open credit values.
There are exceptions to these rules
1. Sales order items which are not relevant for delivery and do not have schedule lines relevant for delivery are not updated to S066 ('Open sales order credit value') rather to S067 ('Open delivery credit value'). You can find further information about this in Note 361637.
2. You can use requirements to delete confirmed quantities in credit blocked sales orders. These requirements are defined in transaction VOFM under the menu path 'Requirements -> Subsequent functions -> ...'. The system asks you for a credit status in the respective user requirement. If this is set to 'Blocked', the system cancels the confirmed quantity. You may want the system to behave differently. If this is the case, you can store a separate requirement which does not cancel the confirmed quantity. As a result, the sales order item has a confirmed quantity again and consequently, it updates the open sales order value although the document is credit blocked. For NON-MRP materials (materials without requirements planning), the system does not cancel the confirmed quantity despite a corresponding condition, as described in Note 393304. For further information about this, refer to Notes 674112 and 914627.
3. A delivery block in the sales order affects the update of open credit values. For more information, see Note 741980.
Update for deliveries
The open delivery values are updated in S067. The update does not occur in time units. There is only one entry in S067 for each credit control area and credit customer. If you create a delivery with reference to a sales order, the system clears the open sales order value in accordance with the delivery quantity (from S066) and posts the open delivery value for the delivery (to S067).
Deliveries with credit lock also write open values of goods to be delivered. Here, it is not possible that a credit-blocked document does not create an open credit value (as in the order). This is also correct from a business view, because the delivery already blocks the goods, and the value of the goods is therefore already consumed for the credit customer.
Update for billing documents
The open billing document values are also updated in S067. Also in this case, only one entry exists for each credit control area and credit customer.
If you create the billing document with reference to a preceding document, the system clears the open credit value in accordance with the invoiced quantity for the preceding document and posts the open billing document value for the billing document (to S067). If you transfer the billing document to accounting, the system clears the open billing document value (from S067). Now the value has been transferred to the open items and occurs as a receivable from the viewpoint of credit management. If the incoming payment occurs, the receivable is met and the consumption of the credit limit is reduced.
Update with update group 15
Order: No posting is done to open order values. The order is placed after the delivery is created.
Delivery: increases open delivery value (S067-OLIKW)
Invoice: reduces open delivery value (S067-OLIKW) and increases open invoice value (S067-OFAKW)
Accounting Document: reduces open invoice value (S067-OFAKW) and increases open items
This type of update group is used for orders without schedule lines – service items or orders with schedule lines that are not relevant for delivery.
Update with update group 18
No posting to open order values, only open delivery values (table S067) are updated
Sales order: increases open delivery value
Invoice: reduces open delivery value and increases open invoice value
Accounting Document: reduces open invoice value and increases open items (accounts receivable)
This update group will be always used by order items that are not relevant for delivery (for example, service items or value items) or for items that are billed as order-related (for example, for billing plans). In the following cases update group 18 is always set dynamically as opposed to the update group of the credit control area. This ensures that, in the case of these exceptions, the update occurs in the open delivery values (S067) and not in the open order values (S066). The update group is determined in the program LMCSBF10 in the form KREDIT_AKTIV:
1. Debit memo request: In the debit memo check, the items are not relevant for delivery and are billed as order-related. The customer has already received the goods to be billed - therefore, they have already been delivered. The order value is updated in the open delivery values.
2. Third-party order processing: You do not make a delivery to a third-party item yourself (item type TAS in the standard SAP system). The delivery is made by a third party. Therefore, you have no further influence on the delivery. The order value is also updated in the open delivery values.
3. Order items with billing plan: Billing according to the billing plan is order-related billing. The order values are also updated in the open delivery values.
4. Further examples are value items and service items for which there is no supply and which are also billed as order-related.
You can find further information about this in Note 361637.
If you change the update group in OB45, you need to rebuild the credit values. For that please read HERE.
Further information
I would like to track the credit value updates
GUIDE for inconsistencies
Credit Management Operations in SAP SD (SAP ERP)
by SAP PRESS on February 18, 2020
From a credit management point of view, important operations include releasing and rejecting blocked documents, credit review, and mass change of customer credit master records.
Let’s take a look at each.
Releasing Blocked Documents
When a sales document is blocked, a warning or error message appears, such as Maximum Percentage Open Items Exceeded. If you click on the question mark, you’ll find the details of the credit checks performed on the document, the ones it cleared (OK), and the ones it failed to clear (NOK). As shown in the figure below, the document was subjected to neither a static credit limit check nor any check for user exit 1, 2, or 3.
It cleared (OK) the check for dynamic credit limit, document value, critical fields, next check date, and maximum dunning level. It failed (NOK) the check for open items and oldest open item. You could still save the document can and have it reviewed by the credit representative by using Transaction VKM1 or following the menu path SAP Easy Access > Logistics > Sales and Distribution > Credit Management > Exceptions > Blocked SD Documents. All of the important information required for making the decision to either release or reject the document is available here.
By selecting a document, you can access the customer master record using the menu path Environment > Customer Master, or customer credit master record using the menu path Environment > Cust. Master Credit of the sold-to party for that document. You can see the other open sales using the menu path Environment > Open Sales Values > Open Sales Order, and deliveries or billing documents by using the menu path Environment > Open Sales Values > Open dlvs/Bill Docs.
...
