updating credit control area

[Former Member]

Dear experts,

Uploaded all opening balances with out credit control area, now i want to update credit control area for all posted documents. is there any way to update the all posted documents.

thanks

Satish

[Former Member]

Dear experts,

We got some issues in the credit limit check for customers while doing sales order creation like system was not validating the credit limit. We did configuration for SD credit control area which was derived from the Sales Area /Division/Distribution channel combination.

But we missed out to assign credit control area to respective company code with overwrite CC area check box under FI configuration.  We have done it now only after a month of implementation but we found that the customer’s advance payment was not considered for credit limit check.

We have uploaded the Opening balance of customers without the credit control area and also executed month’s transactions of customers without the same. We are not getting the customer down payments reflected in T code: FD32.

regards,

Satish

[Former Member]

Check Report RFDKLI20 this will update credit data in SD and FI in old documents.

[Former Member]

Credit management whenever activated will consider all open items till date.

[Former Member]

Dear Yaduveer Singh,

thanks for your immediate replay. here problem is, this is new project we uploaded opening balances without CCA .

[Former Member]

Yes than you must have only transferred open item balances so what's the harm. If you set credit control area now. and create credit management data for them it will take current open items balance into consideration.

[Former Member]

Problem is:

opening balances are not updated with CCA. so system not checvking customer balances. when doing sales invoice system giving error like "credit limit is exceeded" even having advances in that particular customer account.

that customer having advances but system saying that credit limit is exceeded. because of what are the balances uploaded and posted document not captured CCA code.

now how can update the all posted advances and posted documents.

thanks in advance,

[suma_mani]

Hi Satish,

It is just alternative solution,may be useful. Remove the risk category form credit master of each customer and post all documents.

After upload the same ,you have to reassign the same risk category and run the mentioned program for all customers. RVKRED09

All the best

Rgds

Mani

[Former Member]

If your uploaded docs are not listed with CCA then you should not get this error as you haven't done any postings in those customer and as per CCA balance should be 0.

But the error is coming that means it is taking those items.

Also please check the open balance of customer CCA takes as open invoice which will be debit - open advances which will be credit.

Ex:

Dr. 1000 (Open invoice)

Cr.  500 (advance)

Balance  500 Debit, thus if your credit limit is 500 then it wont allow you to make further invoice.